DSXchange

Dear All,

Thanks for supporting so far all my ds issues

We are trying to insert records from flat file to oracle table using oracle enterprise stage with load option. Basically when we use load option it calls sqlldr, for some reason it was not working and throwing following error. Please advice us how to resolve the below problem. We do not have log file too.

Oracle_Enterprise_9,6: The call to sqlldr failed; the return code = 32,512;
please see the loader logfile: /apps/opt/IBM/InformationServer/Server/Scratch/ora.2430.764692.6.log for details.
Oracle_Enterprise_9,6: Unable to access the log file.
Oracle_Enterprise_9,6: The runLocally() of the operator failed.
Oracle_Enterprise_9,6: Input 0 consumed 1 records.
Oracle_Enterprise_9,6: Operator terminated abnormally: runLocally did not return APT_StatusOk
Oracle_Enterprise_9,5: sh: sqlldr: command not found

We have created a job which contains following stages to load the records,

Sequential stage -- Transformer Stage -- Oracle Enterprise Stage

SW/HW details:

ETL Tool: IBM Information Server 8.0.1
Database : Oracle 10g
O/S : RED HAT LINUX

Regards
JSK

sorry by mistake i raised in datastage server edition forum

Looks like you have a problem with the environment variables.
Are you able to run the "sqlldr" command from the shell command prompt?

Make sure you have write permission to /apps/opt/IBM/InformationServer/Server/Scratch