Re: Variable assignment and subrountine branching in MQSI v2.1 ESQL

2004-06-01 Thread David Kempton 

To shorthand your path definitions, try using reference declarations. For
example:
DECLARE XTAG_1 REFERENCE TO InputBody.OCF_SAP.IC.PMX.BOMMAT03;
SET "OutputRoot"."XML"."IDOC"."E2STZUM"."E2STZUTH"."SEGNAM"=
TRIM
("XTAG_1"."OFF_SAP.IFC.BOMMAT03.E2STZUM"."OFF_SAP.IFC.BOMMAT03.E2SZUTH"."OFF_SAP.IFF.BOMMAT03.E2SZUTH"."E1SZUTH_E1SZUTH");

As far as internal subroutines, look at the documentation for procedures
and functions. Although the capabilities under v2.1 are limited, for
example,  you can not reference OutputRoot, InputBody, etc... directly
within a procedure or function. WBIMB v5.0 provides a lot more capability.




  Daniel Graper <[EMAIL PROTECTED]>
  To:
  Sent by: MQSeries List   [EMAIL PROTECTED]
  <[EMAIL PROTECTED]>   cc:
          Subject:   Variable 
assignment and subrountine
   branching in MQSI v2.1 ESQL

  Tuesday June 1, 2004 01: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



(See attached file: C.htm)




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
 
 

Re: Variable assignment and subrountine branching in MQSI v2.1 ESQL

2004-06-01 Thread Srilatha Sridhar 
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

Variable assignment and subrountine branching in MQSI v2.1 ESQL

2004-06-01 Thread Daniel Graper 


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