MQSeries.net
Search
Tech Exchange
Education
Certifications
Library
Info Center
SupportPacs
LinkedIn
Search
FAQ
 Â
Usergroups
Register
::
Log in
Log in to check your private messages
RSS Feed - WebSphere MQ Support
RSS Feed - Message Broker Support
MQSeries.net Forum Index
»
WebSphere Message Broker (ACE) Support
»
Passing Update and Commit in a Single statement
Passing Update and Commit in a Single statement
«
View previous topic
::
View next topic
»
Author
Message
vdharanikota
Posted: Tue Dec 26, 2017 11:32 am
Post subject: Passing Update and Commit in a Single statement
Novice
Joined: 07 Jul 2014
Posts: 18
Hi Everyone,
I am using IIB10 and Oracle DB.
I have a requirement to update and commit the transaction in a single statement.
I have used individual statements as below :
PASSTHRU('UPDATE Table1 SET Col1= ? where Col2= ? and Col3= ?','a','b','c');
PASSTHRU('COMMIT');
The above statements are working good.
Is there any chance that we can combine the above two statements into one and pass at singe shot....?
Back to top
mpong
Posted: Tue Dec 26, 2017 12:46 pm
Post subject:
Disciple
Joined: 22 Jan 2010
Posts: 164
I don't think you can achieve in a single ESQL statement unless you write COMMIT. Probably you can try out java SQL Parser to do the commit using JCN.
Back to top
Display posts from previous:
All Posts
1 Day
7 Days
2 Weeks
1 Month
3 Months
6 Months
1 Year
Oldest First
Newest First
Page
1
of
1
MQSeries.net Forum Index
»
WebSphere Message Broker (ACE) Support
»
Passing Update and Commit in a Single statement
Jump to:
Select a forum
General Discussion
----------------
Read First for All New to IBM MQ, Integration, Messaging, WebSphere - Only Moderators Post Here
General Discussion
Messaging and Integration Technologies FAQ
News/Updates
Links
Job Seekers
Job Postings
General Forums Information
Requirements, Wishlists & Enhancement Requests
----------------
RFEs - Requirements, Wishlists & Enhancement Requests - Open Forum
IBM MQ Support
----------------
General IBM MQ Support
IBM MQ Cloud and SaaS, Cloud Hybrid and Containers
IBM MQ Installation/Configuration Support
Clustering
IBM MQ Telemetry / Low Latency Messaging / Everyplace
Mainframe, CICS, TXSeries
iSeries, OpenVMS, HP-NSS
IBM MQ Performance Monitoring
IBM MQ Security
IBM MQ Development
----------------
IBM MQ Java / JMS
IBM MQ API Support
Multiphase Commit
User Exits
WebSphere Message Broker
----------------
WebSphere Message Broker (ACE) Support
WMB Patterns Repository - Available for Download
WebSphere Application Server
----------------
WebSphere Application Server
Web Services
----------------
WebSphere DataPower
Products that use IBM MQ
----------------
Workflow Engines - IBM MQ Workflow & Business Process Choreographer
WebSphere Process Server (WID/WPS/WAS+)
WebSphere Interchange Server + Adapters
IBM MQ File Transfer Edition
Resources, Files, Samples, Archives, Misc
----------------
Files and Code Samples
Archives - All
Challenge Forum
Sponsored Forums
----------------
Cressida Technology
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
Theme by
Dustin Baccetti
Powered by
phpBB
© 2001, 2002 phpBB Group
Copyright © MQSeries.net. All rights reserved.