INMOD and FORMAT VARTEXT

Tools
Enthusiast

INMOD and FORMAT VARTEXT

Hi,

When calling an INMOD routine to change the record delimiter, MLOAD seems not to do the delimiting on the record received back from the INMOD. Is it possible to do. Any suggestions

Record send to INMOD: "Name",01,"City","State"
Record received from INMOD: Name~01~City~State

*** Start of MLOAD ***
.logtable DB.CSV_TEST_LOG;
.logon Uid,Pword;
.begin import mload tables DB.CSV_TEST
WORKTABLES
DB.CSV_TEST_WT
ERRORTABLES
DB.CSV_TEST_ET
DB.CSV_TEST_UV CHECKPOINT 0;

.LAYOUT INTERNAL;
.FIELD NAME * VARCHAR(20);
.FIELD CODE * VARCHAR(2);
.FIELD CITY * VARCHAR(60);
.FIELD STATE * VARCHAR(60);

.DML LABEL INSERTS;
INSERT DEV_EDW.CSV_TEST(
NAME,
CODE,
CITY,
STATE)
VALUES (
:NAME,
:CODE,
:CITY,
:STATE);

.IMPORT INFILE c:\Teradata_Functions\C\csv.csv INMOD c:\Teradata_Functions\C\CSVIM.dll
FORMAT VARTEXT '~'
LAYOUT INTERNAL
APPLY INSERTS ;
.END MLOAD;
.LOGOFF;
*** End of MLOAD ***