ODBC stage problem
Moderators: chulett, rschirm, roy
ODBC stage problem
H;
I have a job which inserts records to an oracle table through ODBC statge. I wrote a custom sql. There was a syntax error in the sql while I ran the job. But the job just showed warning message for that error and showed finished status. It never showed Failed status with fatal error. Can you please tell me how to rectify this?
Thanks
Rajani
I have a job which inserts records to an oracle table through ODBC statge. I wrote a custom sql. There was a syntax error in the sql while I ran the job. But the job just showed warning message for that error and showed finished status. It never showed Failed status with fatal error. Can you please tell me how to rectify this?
Thanks
Rajani
---Raj
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
Exactly what I was going to ask... perhaps in ODBC a warning (Database side) will only generate a warning (Datastage side) as opposed to a fatal? We need to know the details involved to have any chance of assisting please.
Mark Winter
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
<i>Nothing appeases a troubled mind more than <b>good</b> music</i>
Thanks for the replys guys
custom sql is
UPDATE
test_table
SET
col2 = ORCHESTRATE.col2
WHERE
col1 ORCHESTRATE.col1
and the warning the datastage is throwing is:
ODBC_Enterprise_5,0: [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00920: invalid relational operator
Thanks for the quick replies again
custom sql is
UPDATE
test_table
SET
col2 = ORCHESTRATE.col2
WHERE
col1 ORCHESTRATE.col1
and the warning the datastage is throwing is:
ODBC_Enterprise_5,0: [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-00920: invalid relational operator
Thanks for the quick replies again
---Raj
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
That seems reasonable. There was no error in the stage per se.
I vaguely recall that there is a "treat warnings as fatal" check box available. Perhaps you could use that.
I vaguely recall that there is a "treat warnings as fatal" check box available. Perhaps you could use that.
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: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom