MQSeries.net :: View topic

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » INSERT_UPDATE

INSERT_UPDATE

« View previous topic :: View next topic »

Author

Message

edasnarik

Posted: Wed Mar 03, 2010 1:34 am Post subject: INSERT_UPDATE

Acolyte

Joined: 10 Mar 2009
Posts: 61

INSERT_UPDATE Statement available in ESQL ?

Inserts if the record isn't there and Updates if it is present.

Gaya3

Posted: Fri Mar 05, 2010 4:04 am Post subject:

Jedi

Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US

why cant you use Passthru function

_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die

edasnarik

Posted: Sun Mar 07, 2010 9:55 pm Post subject:

Acolyte

Joined: 10 Mar 2009
Posts: 61

Code:

PASSTHRU('MERGE INTO ASADE.SIMPLE TA USING ( SELECT ( SNO) FROM ASADE.SIMPLE) AC ON ( TA.SNO = SNO )WHEN MATCHED THEN UPDATE SET TA.SNAME = '||SNAME||' WHEN NOT MATCHED
THEN INSERT(SNO,SNAME) VALUES('|| SNO ||','||SNAME||')');

I was trying on the same lines but was not able to achieve it.

Can you help me with a sample line of code ?

smdavies99

Posted: Mon Mar 08, 2010 12:24 am Post subject:

Jedi Council

Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.

I'd build the SQL as a complete string and then pass it to passthru.

Then in the debugger or via user trace you can see the complete string easily and check for syntax errors.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995

Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions.

edasnarik

Posted: Mon Mar 08, 2010 12:31 am Post subject:

Acolyte

Joined: 10 Mar 2009
Posts: 61

smdavies99 wrote:

build the SQL

Thts my problem.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » INSERT_UPDATE

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP