Page 1 of 1

RCP with Teradata Multiload

Posted: Thu May 15, 2008 9:44 am
by landaghaar
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?

Posted: Thu May 15, 2008 10:58 am
by throbinson
The multi-load stage needs column names in order to build the script.
You'll notice that your script SQL statement has none;
0010 insert TEST.Testtable ()
values ();
No can do-ski with RCP.
I would hazard a guess that ONLY the Enterprise Stage can be used with RCP and Teradata because I have the very same problem with the Teradata API stage. My workaround was to parameterize the SQL statement. When that is done then RCP worked.