RE: Wizard generation of DB2 Receive adapters

Thanks.

"Mark Brimble" wrote:

> 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;
>  
> 
> 
> 
> 
> 
>