Archives of the TeradataForum

Message Posted: Fri, 10 Jun 2005 @ 18:26:54 GMT


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

Subj:		Re: Fastload syntax errors: 3808

From:		Victor Sokovin

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.

Did you try the obvious, i.e. to add the database name?

     BEGIN LOADING HCCLCO_USHARE.FASTLOAD_TEST
           ERRORFILES HCCLCO_USHARE.ERRNAME1, HCCLCO_USHARE.ERRNAME2;

Of course, you could later try a different DB where your user can create tables. For syntax checking purposes any DB would do. As far as I know this is all you need to define. Don't worry about the table structures. TD should figure out them for you.

Regards,

Victor