Archives of the TeradataForum

Message Posted: Mon, 04 Oct 2004 @ 18:29:31 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Monday, October 04, 2004 14:18 -->

I am trying to add TENACITY and SLEEP commands to a fastload running in Unix. I cannot seem to find the correct placement of the statements.

No matter where I place them, I get these errors.

     0010 TENACITY=4;
     **** 13:00:35 FDL4800 Invalid FastLoad statement
     0011 SLEEP=10;
     **** 13:00:35 FDL4800 Invalid FastLoad statement

According to the manual, they should go before the logon statement, such as this. I also tried putting a '.' before the commands and received the same error.

     TENACITY=4;
     SLEEP=10;
     .logon f/aaa,bbb;
     Drop Table TESTDB01.DNMERR1;
     Drop Table TESTDB01.DNMERR2;

     Begin Loading TESTDB01.DNMINPUT
       Errorfiles TESTDB01.DNMERR1,
                  TESTDB01.DNMERR2;

When I run a fastload from MVS and place them before the logon, it works beautifully. What am I doing wrong in Unix?

	<Prev	Next>		<<First	<Prev	Next>	Last>>