Hi Dan:
Did you try putting double quotes instead of single quotes?
SET XTAG_1 = "OCF_SAP.IC.PMX.BOMMAT03";
Thanks.
Srilatha Sridhar(Sri)
Middleware Team
HartfordLife
763-765-4322
Daniel Graper
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
OM> cc:
Sent by: Subject: Variable assignment and
subrountine branching in MQSI v2.1 ESQL
MQSeries List
<[EMAIL PROTECTED]
EN.AC.AT>
06/01/2004 12:24
PM
Please respond
to MQSeries List
I have some huge set statements that I would like to shorten using ESQL
defined variables. I have tried several things but have had no success yet.
An example of my set statement is as follows:
SET "OutputRoot"."XML"."IDOC"."E2STZUM"."E2STZUTH"."SEGNAM"=
TRIM
("InputBody"."OCF_SAP.IC.PMX.BOMMAT03"."OFF_SAP.IFC.BOMMAT03.E2STZUM"."OFF_SAP.IFC.BOMMAT03.E2SZUTH"."OFF_SAP.IFF.BOMMAT03.E2SZUTH"."E1SZUTH_E1SZUTH");
I was trying to define OCF_SAP.IC.PMX.BOMMAT03 as XTAG_1 using the set
statment
SET XTAG_1 = 'OCF_SAP.IC.PMX.BOMMAT03';
but the variable does not work when I try to place it in the set statement
SET "OutputRoot"."XML"."IDOC"."E2STZUM"."E2STZUTH"."SEGNAM"=
TRIM
("InputBody".XTAG_1."OFF_SAP.IFC.BOMMAT03.E2STZUM"."OFF_SAP.IFC.BOMMAT03.E2SZUTH"."OFF_SAP.IFF.BOMMAT03.E2SZUTH"."E1SZUTH_E1SZUTH");
Does anyone know how I can do this?
Also, is there a way in ESQL to branch to an internal subroutine?
Any feedback is greatly appreciated,
Dan
*************************************************************************
PRIVILEGED AND CONFIDENTIAL: This communication, including attachments, is for the
exclusive use of addressee and may contain proprietary, confidential and/or privileged
information. If you are not the intended recipient, any use, copying, disclosure,
dissemination or distribution is strictly prohibited. If you are not the intended
recipient, please notify the sender immediately by return e-mail, delete this
communication and destroy all copies.
*************************************************************************
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