| Author |
Message
|
| bhupa_sri |
 Posted: Fri Feb 24, 2006 6:49 am Post subject: UPDATE Statement Problem in MB6.0 |
 |
|
Apprentice
Joined: 30 Dec 2004
Posts: 30
Location: India
|
Hi all,
I want Update the Oracle databse using Update statement in ESQL(Compute Node)
UPDATE Database.DSNNAME.C_KMTCRD SET TRAILER_CTL= CAST Environment.TRAILERCTL AS CHAR), SHIP=CAST(Environment.SHIP AS CHAR),SHIP_DATE=CAST(Environment.SHIPDATE AS CHAR),SHIP_TIME=CAST(Environment.SHIPTIME AS CHAR),RECVD_LOC=CAST(Environment.RECVDLOC AS CHAR) WHERE C_KMTCRD.CCN=CAST(Environment.CCN AS CHAR) AND C_KMTCRD.TCARD=CAST(Environment.TCARD AS CHAR);
But i got error "Driver does not support this function".
In my system we using "MQSeries DataDirect Technologies 5.0 32-BIT Oracle" ODBC driver.
Please give me any idea...
Appreciate for your Response |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Fri Feb 24, 2006 6:54 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
What version of Oracle?
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| bhupa_sri |
| Posted: Fri Feb 24, 2006 7:01 am Post subject: |
|
|
Apprentice
Joined: 30 Dec 2004
Posts: 30
Location: India
|
|
| Back to top |
|
|
| samgunddi |
| Posted: Fri Feb 24, 2006 7:20 am Post subject: |
|
|
Acolyte
Joined: 17 May 2004
Posts: 54
|
You might already know this,
the version of oracle supported is Oracle 9i Release 2
_________________
IBM Certified System Administrator
- WebSphere Message Queue V5.3
- WebSphere Message Broker v6.0 |
|
| Back to top |
|
|
| bhupa_sri |
| Posted: Fri Feb 24, 2006 7:32 am Post subject: |
|
|
Apprentice
Joined: 30 Dec 2004
Posts: 30
Location: India
|
Thanks for quick response..
Yes we have Oracle 9i Release 2..
I am trying using EVAL
EVAL('UPDATE Database.DSN.C_KMTCRD SET TRAILER_CTL=' || Environment.TRAILERCTL || ',SHIP='|| Environment.SHIP || ',SHIP_DATE=' || Environment.SHIPDATE || ',SHIP_TIME=' || Environment.SHIPTIME || ',RECVD_LOC=' || Environment.RECVDLOC || ' WHERE C_KMTCRD.CCN=' || Environment.CCN || ' AND C_KMTCRD.TCARD=' || Environment.TCARD ||';');
I got the Error "Expected ;"
Please give me solution...
Thanks in advace |
|
| Back to top |
|
|
| mgk |
| Posted: Fri Feb 24, 2006 7:56 am Post subject: |
|
|
Padawan
Joined: 31 Jul 2003
Posts: 1642
|
Have you tried to do this with PASSTHRU? It will perform MUCH faster if you do. You should not need to use EVAL if you use PASSTHRU with parameter markers ('?'). EVAL can be very slow, and should always be avoided if their is an alternative.
regards,
_________________
MGK
The postings I make on this site are my own and don't necessarily represent IBM's positions, strategies or opinions. |
|
| Back to top |
|
|
| samgunddi |
| Posted: Fri Feb 24, 2006 8:24 am Post subject: |
|
|
Acolyte
Joined: 17 May 2004
Posts: 54
|
|
| Back to top |
|
|
| bhupa_sri |
| Posted: Fri Feb 24, 2006 9:05 am Post subject: |
|
|
Apprentice
Joined: 30 Dec 2004
Posts: 30
Location: India
|
|
| Back to top |
|
|
|
|
