You should contemplate on using database tables or environment variables to access the codes that you want to compare against.
| "JoE JK" <[EMAIL PROTECTED]>
Sent by: "MQSeries List" <[EMAIL PROTECTED]> 05-Jun-2003 10:07
|
To: MQSERIES cc: 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
