Page 1 of 1

Generate a type tree from empty stored procedure ?

Posted: Fri Apr 17, 2009 1:27 am
by Popopol
I'm trying to use a strored procedure as an output card that doesnt return anything.
It is simply updating things in the database.
But I need to have a type tree for it.
When I try to generate a type tree from the Database Interface Designer, I get: "The column definitions for the query could not be accessed." because there is no output from the proc.
How should I do?

Thanks a lot

Posted: Wed Apr 29, 2009 12:49 pm
by Vishal1982
Hi ,
Could you please tell me how you are calling the stored procedure
in database interface designer,so that i can help you

Posted: Fri May 01, 2009 12:47 pm
by jvmerc
Not being overly familiar with 8.2n and beyond I can't answer if IBM has changed this. Depending on your version, you are going to need to use a runmap which will call the stored procedure that will perform the updates.