-
1
- #1
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to load 'tab' delimited flat file? 1
- Thread starter choongyin
- Start date
sathyarams
IS-IT--Management
Check the coldel modifier in the LOAD COmmand ..
More DB2 questions answered at
More DB2 questions answered at
To load a tab delimeted file to DB2 is pretty easy.
First upload the text file to the AS/400.
The use the command CPYFRMIMPF (copy from import file). The parameters are self explanatory.
Please note that the character fields will have to have '' before and after.
First upload the text file to the AS/400.
The use the command CPYFRMIMPF (copy from import file). The parameters are self explanatory.
Please note that the character fields will have to have '' before and after.
- Status