Archives of the TeradataForum
Message Posted: Fri, 10 Jun 2005 @ 17:52:12 GMT
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'.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|