Hi ,
I need help in understanding if i can directly(there are 100s of different structured files i get in text format with & hence dont wnat to manually define the structure for each file manually) create a db2 table with the structure & data as in excel or flat file by importing the flat file .I have only DB@ enterprise server.No other tools....DTS in MS SQL saves this complete effort(even if it means all fields are varchar...it still recognizes all column names from the flat file automatically.
I need help in understanding if i can directly(there are 100s of different structured files i get in text format with & hence dont wnat to manually define the structure for each file manually) create a db2 table with the structure & data as in excel or flat file by importing the flat file .I have only DB@ enterprise server.No other tools....DTS in MS SQL saves this complete effort(even if it means all fields are varchar...it still recognizes all column names from the flat file automatically.