modify the schema manually, e.g. change Table1 to any name you like, would it
Thanks, I have moved on a bit from here. I tried your suggestion some time
back and it did not seem to work. Recently I tried to do some things I do
e.g. I wanted to generate a schema with a second element. If use the SQL
to another table I get schemas of this form. If i do the same with the DB2
element namely 'Table1'. I guess the DB2 wizard behaves quite differently
from the SQL adapter wizard. The DB2 adapter does not seem to generate XML
return the Table as a name I specified. After using the DB2 Adapter
> 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;
>
>
>
>
>
>
>
Email TopXML