|
|
Archives of the TeradataForum
Message Posted: Thu, 17 Feb 2005 @ 18:45:16 GMT
Subj: | | Re: UTY4017 Not enough data in vartext record number 1. |
|
From: | | Dieter Noeth |
Jyotsna Malineni wrote:
| I am running a teradata multiload job that is giving me this error. | |
| UTY4017 Not enough data in vartext record number 1. | |
| This is a simple job that reads from sequential file and loads teradata tables.I have checked all the column definitions and also tried
with all kinds of test data. | |
| sequential file has char, decimal and date data types. | |
If it's FORMAT VARTEXT then only VARCHAR/VARBYTE fields are allowed, nothing else.
data: 20050217|12345.67|bla
ct foo(
mydate date,
maydec dec(8,2),
mychar char(5)
);
.FIELD mydate * VARCHAR(8)
.FIELD mydec * VARCHAR(10)
.FIELD mychar * VARCHAR(5)
MLoad will try to cast it during the insert, so maybe you have to specify a Format string:
insert into mydate
(:mydate (date (format 'yyyymmdd')),
:mydec,
:mychar
);
Dieter
| |