Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Biz Talk Application Integration > Wizard generati...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 1237 of 1287
Post > Topic >>

Wizard generation of DB2 Receive adapters

by =?Utf-8?B?TWFyayBCcmltYmxl?= <MarkBrimble@[EMAIL PROTECTED] May 20, 2008 at 02:36 PM

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;
 




 5 Posts in Topic:
Wizard generation of DB2 Receive adapters
=?Utf-8?B?TWFyayBCcmltYmx  2008-05-20 14:36:44 
RE: Wizard generation of DB2 Receive adapters
=?Utf-8?B?bGluZGFCenRr?=   2008-06-05 10:17:02 
RE: Wizard generation of DB2 Receive adapters
=?Utf-8?B?TWFyayBCcmltYmx  2008-06-05 17:36:01 
RE: Wizard generation of DB2 Receive adapters
=?Utf-8?B?c2FtYWRraGFu?=   2008-08-19 04:34:03 
RE: Wizard generation of DB2 Receive adapters
=?Utf-8?B?TWFyayBCcmltYmx  2008-08-21 18:24:01 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Nov 20 21:50:13 CST 2008.