When an error occurs, LOAD returns one of the following codes to the calling environment:
~ 1 : -8888 SERVERDB NOT ACCESSIBLE
~ 2 : -8000 SERVERDB MUST BE RESTARTED
~ 3 : -1021 TOO MANY USERS CONNECTED
~ 4 : -4008 UNKNOWN USER NAME/PASSWORD COMBINATION
~ 5 : Invalid call option. (The specified command is not available to this tool.)
~ 6 : The protocol file cannot be created.
~ 7 : SQL error
~ 8 : LOAD error
~ 9 : Rows rejected by DATALOAD or DATAUPDATE
10 : File error in a statement
Remarks:
For LOAD BATCH, the return codes 1 to 6 implicitly mean that the job was not started. The return codes 7 to 10 are default return codes. LOAD terminates with one of these codes when the LOAD command file does not contain a statement to set a special return code. These values should be avoided when a return code is set by using the STOP or RETURNCODE statement.