All Forums Database
Pervez Ahmed 19 posts Joined 05/06
03 May 2006
MultiLoad utility using delimited file.

I have created a delimeted file and wanted to use against FASTLOAD and MLOAD Utilities. To define these delimeted fields in FASTLOAD, I used .SET RECORD as follows:.set record vartext "|";define LASTNAME (VARCHAR(10)), MIDINITIAL(VARCHAR(1)), FIRSTNAME(VARCHAR(10)), SSNUMBER (varCHAR(9)), BIRTHDATE (varCHAR(10))The FASTLOAD Inserted the rows into the table. I am not sure what is the equivalent for .set record vartext "|" for MLOAD;or how can I define delimeted files in MLOAD? I will apprecaite help. please see attached for mload scripts

pietroNardella 5 posts Joined 05/06
04 May 2006

Perez, you have to insert this statement in .IMPORT directive:format vartext '|'that's say in your example we have:.import INFILE c:\pervez\family.txt layout INPUTLAYOUT format vartext '|' apply inserts;Good luck!

Pervez Ahmed 19 posts Joined 05/06
04 May 2006

ThanksThis worked.

You must sign in to leave a comment.