Joined: 20 May 2001 Posts: 107 Location: Zurich Financial Services
I wish to query an external database from a comput node and output the results to an XML message.
So for example, I can code the following:
SET "OutputRoot".XML.ClaimEvent.(XML.attr)AssignedOffice = THE
(SELECT ITEM T1.ASSGN_OFFC
FROM Database.C01 AS T1
WHERE T1.CLM_NBR = Parm);
However, if I wish to query 2 columns from the same row on the database to assign to 2 differently named XML fields, I do not want to issue two distinct queries as this would be inefficient.
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