DB2 Load import auto-increment field data

DB2 Load imports auto-increment field data [SQL] when creating a table, the primary keys of some tables are set to auto-increment, which makes it much easier to insert, modify, and delete data in the table, however, once the primary key of the table is used as the foreign key of other tables, Data Mismatch may occur during data migration, how can we solve the data matching problem between auto-increment fields and data files. After in-depth research on load, we found that there are three ways for load to import auto-incremental data: IDENTITYIGNOR, IDENTITYMISSING, and IDENTITYOVERRIDE. After the actual test, for IDENTITYIGNOR and IDENTITYMISSING, the auto-incrementing fields are accumulated by counter; For IDENTITYOVERRIDE, the auto-incrementing fields are imported into the table according to the data in the data file. CREATE a TABLE: [SQL] CREATE TABLE AAD (A_1 INT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1), A_2 VARCHAR (50 )); data File Content (e: \ load.txt): [SQL] 2, "22" 3, "33" Import command: [SQL] LOAD CLIENT FROM 'e: \ LOAD. TXT 'of del modified by identityoverride replace into aad; after IDENTITYOVERRIDE is added, Load will fill the values in the data file INTO the auto-increment field OF the table.