I have a text file which has following format and I want to load into multiple tables in db2.
A,'Abcd',12344,'89','Cad'
B,09122008,04
C,'Unit','Unit Number 3899','Institute',2002-11-10
A,'Cabd',88388,'90','DAC'
B,08112007,03
C,'Unit','Unit Number 3939','Institute',2001-10-05
All A's goes to one table, B goes another and C goes another table.
I wrote a control file in Oracle but I am new to this DB2 and how shall I achieve this. If there is any step by step process that will be really helpful.
A,'Abcd',12344,'89','Cad'
B,09122008,04
C,'Unit','Unit Number 3899','Institute',2002-11-10
A,'Cabd',88388,'90','DAC'
B,08112007,03
C,'Unit','Unit Number 3939','Institute',2001-10-05
All A's goes to one table, B goes another and C goes another table.
I wrote a control file in Oracle but I am new to this DB2 and how shall I achieve this. If there is any step by step process that will be really helpful.