I am able to import csv's into a db2 database using:
db2 connect to DB01user USERNAME using PASSWORD
db2 -tvf C:\files\create_tables.sql
However this ignores the column header and imports the data in the order in which it appears in the csv. Is there any way I can get the data to be imported according to the order of the column names in the first row?
The csv's are obtained from a number of sources which I don't have access to and so it would be very useful if I could make use of the column names to reorder the data to match my database.