Archives of the TeradataForum

Message Posted: Fri, 10 Jun 2005 @ 17:52:12 GMT

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

HI:

I am trying to get Fastload to work for the mainframe but I seem to be getting syntax errors I can't seem to resolve.

Do I need to define the EORRORFILE tables? If so, where do I find how they should be defined. The manual did not state.

My script looks like:

     .LOGON TDPP/A,xxx
     .SHOW                                     ;
     .SESSIONS 4                               ;
      BEGIN LOADING HCCLCO_USHARE.FASTLOAD_TEST
            ERRORFILES ERRNAME1, ERRNAME2;
       DEFINE KEYCL (CHAR(9)),
       DDNAME=INFILE;
       INSERT INTO HCCLCO_USHARE.FASTLOAD_TEST (KEYCL) VALUES (:KEYCL);
     .LOGOFF
     .EXIT


     **** 10:13:57 RDBMS error 3808: Database unspecified for 'ERRNAME1'.

Thanks

Capp Luckett

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