Archives of the TeradataForum
Message Posted: Tue, 14 Jun 2005 @ 12:52:10 GMT
Subj: | | Re: MultiLoad With VARTEXT/Delimited Input File |
|
From: | | Sridevi Lakshminarasimhan |
In the layout we specify something like the below:
.LAYOUT INSLAYOUT;
.FIELD NAME * VARCHAR(10);
.FIELD AMT1 * VARCHAR(20);
.FIELD AMT2 * VARCHAR(20);
Can someone tell me what is the significance of VARCHAR(xx) in the above.
I initially tried giving a longer input than the one specified for each field thinking that MLOAD will automatically truncate the exceeded
length than specified, but the job abended.
Can someone help me !
Thanks.
|