FLOAD CANNOT OPEN FILE,RETURN CODE 12

Tools & Utilities

FLOAD CANNOT OPEN FILE,RETURN CODE 12

Cannot open file:
'file'
===================================================================
= =
= Logoff/Disconnect =
= =
===================================================================

**** A:B:C Logging off all sessions
**** D:E:F Total processor time used = 'Z Seconds'
. Start : X X X X
. End : Y Y Y Y
. Highest return code encountered = '12'.

pLEASE LET ME NOW WHAT SHALL BE REASON,AS PER MY KNOWLWDGE SHOULD BE

1) FLOAD DOES NOT HAVE ACCESS TO THAT FILE
2) FORMAT OF FILE IS DIFFERENT FROM WHAT IT SHALL BE CORRESPONDING TO FLOAD SCRIPT

CORRECT ME IF I AM WRONG AND SUGGEST
1 REPLY
Teradata Employee

Re: FLOAD CANNOT OPEN FILE,RETURN CODE 12

It looks like the output has been edited to remove timestamps and such.
It would be best to provide as much of the output as possible without any editing.
My guess would be that:

1. file does not exist
2. file has certain access rights and the user, under which the job is being run, does not have the proper permissions to access and/or read the file

Can you show us that the filename specified is correct and the file exists?
Can you show the access rights for that file?

-- SteveF