CODEWITHSUNDEEP
db2db2-luwbulk-load
Ravi G
Ravi G

Reputation: 11

DB2 LOAD / IMPORT, Load1 flat file into multiple tables

Need to load a flat file into 4 different tables (i.e 1 row in flat file goes into 4 different tables). These 4 different tables maintain one common key to identify the association. How do I load such data using DB2 load/import. Does DB2 load / import provide such capability? Hard part is maintaining the association.

Upvotes: 1

Views: 438

Answers (1)

mustaccio
mustaccio

Reputation: 18945

Neither LOAD nor IMPORT support loading data into multiple tables at once. You will have to make four files out of your one file, making sure each one contains your common key, and load them separately.

Upvotes: 1

Related Questions