Generate a type tree from empty stored procedure ?

Popopol · Post by **Popopol** » Fri Apr 17, 2009 1:27 am

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

Vishal1982 · Post by **Vishal1982** » Wed Apr 29, 2009 12:49 pm

Hi ,
Could you please tell me how you are calling the stored procedure
in database interface designer,so that i can help you

jvmerc · Post by **jvmerc** » Fri May 01, 2009 12:47 pm

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.