Hi
My source is file and target is oracle
when I am usng the upsert method
the records are getting populated in the target
but when I am using the load method
the job is getting aborted giving the following error
Oracle_Enterprise_2,2: sh: line 1: sqlldr: command not found
The call to sqlldr failed; the return code = 32,512;
Unable to access the log file.
Oracle_Enterprise_2,2: The runLocally() of the operator failed.
thanks
write metho LOAD is aborting UPSERT running fine
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
write metho LOAD is aborting UPSERT running fine
Hi I have experience in parallel extender datastage I am ready to give/take help from other
hope we all help each other hand in hand
hope we all help each other hand in hand
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
sqlldr: Command not found
Says it all. Your PATH environment variable does not include the $ORACLE_HOME/bin directory and/or your ORACLE_HOME environment variable is not set.
Says it all. Your PATH environment variable does not include the $ORACLE_HOME/bin directory and/or your ORACLE_HOME environment variable is not set.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia