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?
RCP with Teradata Multiload
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Wed Sep 19, 2007 10:11 am
- Location: Canada
-
- Charter Member
- Posts: 299
- Joined: Wed Nov 13, 2002 5:38 pm
- Location: USA
The multi-load stage needs column names in order to build the script.
You'll notice that your script SQL statement has none;
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.
You'll notice that your script SQL statement has none;
No can do-ski with RCP.0010 insert TEST.Testtable ()
values ();
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.