Hi,
Another idea...
After your MQInput node, insert a compute node and promote it's computeExpression property. Before deploy operation, you can update the promoted property, like
SET OutputRoot = InputRoot;
SET Environment.Variables.v1 = '0001';
SET Environment.Variables.v2 = '0002';
and change your ESQL in
IF (txncode = Environment.Variables.v1) or (txncode = Environment.Variables.v2) then
set accno = 999999;
END IF;
Isn't a perfect solution, but works and you can change the parameters without ESQL code modifications.
Best Regards,
=================================================
Zudor Sándor
vezető tanácsadó/senior consultant - T-Logic KFT.
Certified Solution Expert/Developer
IBM WebSphere MQ & MQ Integrator
e-mail: [EMAIL PROTECTED]
tel: +36-1-424.06.01
mobil: +36-20-956.97.70
fax: +36-1-227.57.16
url: www.t-logic.hu
====================================
| Mike Krueger <[EMAIL PROTECTED]>
Sent by: MQSeries List <[EMAIL PROTECTED]> 2003-06-05 17:08
|
|
Take a look at the "MQSI get environment variables plug-in" Support
Pack:
http://www-3.ibm.com/software/integration/support/supportpacs/individual
/ia06.html
-----Original Message-----
From: MQSeries List [mailto:[EMAIL PROTECTED] On Behalf Of JoE JK
Sent: Thursday, June 05, 2003 5:07 AM
To: [EMAIL PROTECTED]
Subject: mqsi - esql coding techniques?
hi,
I have the following code in one of the flow done by
our SI team(one of those thousand lines).
----------------------------------------------------
IF (txncode = '0001') or (txncode = '0002') then
set accno = 999999;
END IF;
-----------------------------------------------------
Is there anyway that i can improve further the above
code? Instead of hardcode the value inside, can I
define any variables or parameter outside the esql
which is modular or easy for me for future enhancement
requirements.
Any input & idea are greatly appreciated.
Thanks,
Joe
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
Instructions for managing your mailing list subscription are provided in
the Listserv General Users Guide available at http://www.lsoft.com
Archive: http://vm.akh-wien.ac.at/MQSeries.archive
