Posted: Sun Sep 29, 2002 3:09 pm Post subject: Setting up Output after SQL Call
Acolyte
Joined: 19 Sep 2002 Posts: 74 Location: Newton, MA
I take in a primary key to a record through an MQInput node and using this key I extract a single row of data from the database into the Environment Variables
Environment.Variables= THE (select T.* from Database.Mytable where
pid = "InputBody"."PID");
I'd now like to pass these environment variables to the next node and/or set up some data to pass to an MQOutput.
I've tried several variations and I keep getting:
"Path does not match any of the selected references"
If I do the following (which is based on an IBM example):
CREATE FIELD OutputRoot.XML.Data;
--- Does this create a new field that I can now refer to that will be output
--- in XML?
DECLARE MyOutput REFERENCE TO OutputRoot.XML.Data;
SET MyOutput.LastName=Environment.Variables.LastName;
--- I'm assuming that because I have a column in the table I select
--- from called LastName - I would get Environment.Variables.LastName
--- is this right?
Thanks in advance,
Melissa _________________ M Marquis
--- I'm assuming that because I have a column in the table I select
--- from called LastName - I would get Environment.Variables.LastName
--- is this right?
Once you print Environment tree using Trace node you would know the structure of retrieved data. I think it is case sensitive. You should refer to it as Environment.Variables.LASTNAME _________________ Kiran
IBM Cert. Solution Designer & System Administrator - WBIMB V5
IBM Cert. Solutions Expert - WMQI
IBM Cert. Specialist - WMQI, MQSeries
IBM Cert. Developer - MQSeries
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum