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

Hi,
 
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"
SET RECORD VARTEXT ","  ;
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?

Dieter

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.
 

--SteveF

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.