Does anyone know where the name of Table1 element in the resulting
generated
schemas comes from? Do you have any control over this or is it it all
determined by the wizard? I am involved in my first project integrating an
AS400 system with other systems using BizTalk. Everything is going
amazingly
well but I am trying to understand what the DB2 generation wizards are
doing
in a bit more detail.
I get a xml like;
<WorkAssignments xmlns="http://DTA.BT_GET_WORKASSIGNMENTS">
<Table1 QUEUE="01" ASSIGNMENT="201729" DIRECTIVE="1" />
</WorkAssignments>
when I generate a DB2 receive adapter from a stored procedure of the
general
pattern;
CREATE PROCEDURE DTA.BT_GET_WORKASSIGNMENTS ( )
LANGUAGE SQL
MODIFIES SQL DATA
BEGIN
--Get some work assigments and remember them
--Get all the next Work assignments and associated directives
P1 : BEGIN
DECLARE wa_CURSOR CURSOR WITH RETURN TO CLIENT FOR
SELECT BT . QUEUE ,
BT . ASSIGNMENT ,
BT . DIRECTIVE
FROM DTA . WA2PD AS BT
P2 : BEGIN
/*
--Delete some rows so we don't pick them up again
*/
OPEN wa_CURSOR;
END P2;
END P1;
END;