All Forums Tools
m_v_anita 9 posts Joined 07/12
03 Feb 2015
FAST LOAD Failing in mainframe job

I am trying to load a CSV file to a teradata table using FLOAD. I did an FTP of the file from my desktop to the mainframe server. The values in the file are comma separated. The Fload script in the mainframe job has the ' set record vartext "," ' command before the DEFINE command. My job keeps failing giving an error message " FDL4800 invalid fastload statement"
I am not sure what is the mistake here. Please advise.
Thanks in advance for the support.

dnoeth 4628 posts Joined 11/04
04 Feb 2015

The syntax looks ok, are you sure it's not due to a missing semicolon for the previous statement?


feinholz 1234 posts Joined 05/08
04 Feb 2015

As always, it would be very helpful to know the version of the tool you are using.


Fred 1096 posts Joined 08/04
05 Feb 2015

Use apostrophes (') not quotation marks (") around the delimiter.

You must sign in to leave a comment.