FAST LOAD Failing in mainframe job

Tools
Enthusiast

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.

3 REPLIES
Junior Contributor

Re: FAST LOAD Failing in mainframe job

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

Teradata Employee

Re: FAST LOAD Failing in mainframe job

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

-- SteveF
Teradata Employee

Re: FAST LOAD Failing in mainframe job

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