MultiLoad utility using delimited file.

Database
Enthusiast

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
2 REPLIES
Enthusiast

Re: MultiLoad utility using delimited file.

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!
Enthusiast

Re: MultiLoad utility using delimited file.

Thanks
This worked.