Hi
I was trying to insert the records from file to oracle table
but
In my previous experience when Ever I want to insert
I used to opt for Upsert(udate and Insert)
I used to give the condition in update as 1=2 ie update can never happen as 1 can never be equal to 2
so this is how I inserted records
Now in my present job i am trying to load records using the write metod :LOAD
but job is getting aborted, the same job is working with upsert and getting aborted with load method
Could any one who has the the experience of using the LOAD method
can suggest me how to over come this prob and load the records into oracle target
thanks
Suresh
The orcle write method :LOAD
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
The orcle write method :LOAD
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
Suresh - could you post your exact error message, there are many possible causes for failure.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Also please advise what stage type you are using. The answer may be different depending on which it is. I assume, from your subject line, that it's the Orcle Enterprise stage. But please verify.
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.
-
- Participant
- Posts: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
load method failure
Hi Suresh Garu,
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.
pls find the attachment also
thanks
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.
pls find the attachment also
thanks
ArndW wrote:Suresh - could you post your exact error message, there are many possible causes for failure. ...
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: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
load
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
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
ArndW wrote:Suresh - could you post your exact error message, there are many possible causes for failure. ...
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: 57
- Joined: Sat Jun 09, 2007 1:14 am
- Location: chicago
the stages used
The stages I am using is seq file(source) transformer and oracle(target stage
ray.wurlod wrote:Also please advise what stage type you are using. The answer may be different depending on which it is. I assume, from your subject line, that it's the Orcle Enterprise stage. But please verify. ...
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