| Author |
Message
|
| pratikp.vasani |
 Posted: Wed Jul 06, 2011 5:30 am Post subject: |
 |
|
Novice
Joined: 04 Jul 2011
Posts: 11
|
Hey I have tried and it is working and my transaction mode is AUTOMATIC.
I have tried it for single table in a sample flow.I will try it out for two related tables.Hope it should work. |
|
| Back to top |
|
 |
| madi |
| Posted: Thu Jul 07, 2011 8:55 am Post subject: |
|
|
Chevalier
Joined: 17 Jan 2006
Posts: 475
|
if the flow is transactional, would that not rollback your database changes if there is an exception in the flow and is left unhandled?
_________________
IBM Certified Solutions Developer - WMB 6.0 |
|
| Back to top |
|
|
| pratikp.vasani |
| Posted: Wed Jul 13, 2011 2:44 am Post subject: Syntax of Passthru(ROLLBACK) |
|
|
Novice
Joined: 04 Jul 2011
Posts: 11
|
I am using PASSTHRU 'ROLLBACK TABLE {SCHEMANAME}.TABLENAME1' TO Database.{DATABASENAME};
Where the SCHEMANAME,TABLENAME1 and DATABASENAME are External variables.
When I am usind the values in place of External variables, the ROLLBACK is happening.
Can someone suggest a syntax for it. |
|
| Back to top |
|
|
| j.f.sorge |
| Posted: Wed Jul 13, 2011 3:01 am Post subject: Re: Syntax of Passthru(ROLLBACK) |
|
|
Master
Joined: 27 Feb 2008
Posts: 218
|
| pratikp.vasani wrote: |
I am using PASSTHRU 'ROLLBACK TABLE {SCHEMANAME}.TABLENAME1' TO Database.{DATABASENAME};
Where the SCHEMANAME,TABLENAME1 and DATABASENAME are External variables.
When I am usind the values in place of External variables, the ROLLBACK is happening.
Can someone suggest a syntax for it. |
You will have to concat (||) the external variables as they are CHARACTERS and won't be evaluated within the PASSTHRU statement. PASSTHRU statement needs the complete CHARACTER string which should be executed and without the evaluation it tries to ROLLBACK TABLE {SCHEMANAME}.TABLENAME1.
_________________
IBM Certified Solution Designer - WebSphere MQ V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.0
IBM Certified Solution Developer - WebSphere Message Broker V6.1
IBM Certified Solution Developer - WebSphere Message Broker V7.0 |
|
| Back to top |
|
|
| mqnewbie771 |
| Posted: Mon Jun 10, 2013 7:40 am Post subject: esql v8 |
|
|
Newbie
Joined: 10 Jun 2013
Posts: 5
|
hello
i am trying to do the same on v8 that pratikp tried.
however the rollback isnt happening.
i have written an exit handler preceding the 2 insert statements. configured the transaction mode as automatic. Yet it doesnt seem to work. Any ideas? |
|
| Back to top |
|
|
| lancelotlinc |
| Posted: Mon Jun 10, 2013 11:23 am Post subject: Re: esql v8 |
|
|
Jedi Knight
Joined: 22 Mar 2010
Posts: 4941
Location: Bloomington, IL USA
|
| mqnewbie771 wrote: |
hello
i am trying to do the same on v8 that pratikp tried.
however the rollback isnt happening.
i have written an exit handler preceding the 2 insert statements. configured the transaction mode as automatic. Yet it doesnt seem to work. Any ideas? |
If you read the posts above, you will note that compensation is not automatic. You must compensate your transactions with code. Read. Especially the InfoCentre.
_________________
http://leanpub.com/IIB_Tips_and_Tricks
Save $20: Coupon Code: MQSERIES_READER |
|
| Back to top |
|
|
|
|
