I need to load a DB2 table from a tab delimited flat file. Please let me know if there is a sample JCL/tool that I can use.
The data in the flat file is like:
0720916027037. 200704 N070401 .05.20070405. ACF .
Here the 'dots' are actually tabs. There is a column for each tab separated field. For example: After the load,
column 1 should have '0720916027037'
column 2 - '200704 N070401 '
column 3 - '05'
column 4 - '20070405' and so on.