DB2 specifications-log & lt; Continuous updates & gt;, db2 log

DB2 specifications-log <continuous update>, db2 log

8:40:23 on Tuesday morning 1. the overall specification keywords are capitalized, {} overall fast [] Option 1.2 note operator priority 1.3 Note link character 1.4 Delete duplicate row keyword distinct show 1.5 use dis [ribe] to indicate table structure 2. exercise 3. characters and dates must be included in single quotes. 3.1 characters in size. Sensitive date formats. 3.2 between and 3.3 in (set) between two values) the values in the two columns are equal to one in the Value List. You can take a look at the exercises. -- 3.4 you have installed quest central to practice local data. 8:59:05 on Wednesday. install the local DB2 1.1 familiar with the Association of related Tables 1.2 truncate table is faster than dekete table 1.3 time to use date or timestamp 1.4 to create a table id as primary key. The default value is 1.5 UR unread-important concepts 2. create a local database. Table 2.1 is familiar with creating, adding, deleting, and modifying tables, check the relationship between 2.2 tables and tables 2.3 fetch read the first X rows 2.4 Order by-asc desc 2.5 add the table field alter table add column field name type -- I personally think that the structure operation on DB2 tables is not very good convenience 2.6 change the field to the auto-increment field alter table name alter column ID set generated always as identity (start with 1, increment by 1, no cache) 2.7 self-connection external connection 3. function 3.1 case-sensitive function control-actually there is a size function pitfall that can only be encountered in actual operations 3.2 IF-THAN-ELSE use 3.3 related model specification basic data layer (BAS ): BAS, application summary layer (APP): APP, data aggregation layer (SHW): SHW, foreground access layer (foreground Management and Application): WI data management layer (log, scheduling, etc ): MNG 9:02:35, Thursday morning 1. process Flow of the Requirement List 1.1 locate the required fields and save the 1.2 group by and Having 1.3 using hasing key 1.4 Sub-queries in any all. 2. recursion related to DB2 2.1 tree-related -- with par1 () as (union all) 3. related Operations: understand the differences between transaction 3.1 and delete, and subquery 3.2 DML, DGL, and DCL statements. 3.3 Use commit and rollback statements. 3.4 transaction processes.