RE: Wizard generation of DB2 Receive adapters

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 
routinely witn the SQL adapter and have discovered the DB2 is rather
limited 
e.g. I wanted to generate a schema with a second element. If use the SQL 
adapter wizard with a stored proc that has a SELECT statement that has a
JOIN 
to another table I get schemas of this form. If i do the same with the DB2

adapter wizard I just get everything as a list of attributes under one 
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

schema without any element other than 'Table1".



"lindaBztk" wrote:

> I haven't worked on DB2 store procedures, but I am just wondering if you

> modify the schema manually, e.g. change Table1 to any name you like,
would it 
> affect the executing of that store proc? If not, you can give it any
name to 
> the output table from SP.
> 
>