RCP with Teradata Multiload
Posted: Thu May 15, 2008 9:44 am
I want to create a generic job to get the schema file name and target table name and source file name as parameter.
The problem is that i can't make the RCP to work with Multiloader, i keep getting the following error:
0008 .layout internal indicators;
0009 .dml label tdmload;
0010 insert TEST.Testtable ()
values ();
0011 .import INFILE Testtable.dat format fastload layout internal
apply tdmload;
0012 .end mload;
**** 11:31:15 UTY1410 No 'FIELD' statements were entered for Layout 'INTERNAL'.
any ideas or help?
The problem is that i can't make the RCP to work with Multiloader, i keep getting the following error:
0008 .layout internal indicators;
0009 .dml label tdmload;
0010 insert TEST.Testtable ()
values ();
0011 .import INFILE Testtable.dat format fastload layout internal
apply tdmload;
0012 .end mload;
**** 11:31:15 UTY1410 No 'FIELD' statements were entered for Layout 'INTERNAL'.
any ideas or help?