jovball wrote:
I strongly prefer not getting the resultsets during the meta-data retrieval and assigning the resultsets in the designer via catalog explorer. That avoids any data changes caused by executing the stored procedures.
Right-click on the procedure and select "Set Number of Resultsets." Usually it would be 1. If it is 0, the call will be created as an ActionProcedure rather than a RetrievalProcedure and you won't get a resultset.
I think you have to assign the resultset count prior to creating the call definition but Frans could confirm that.
That's correct, and it's an alternative way to get retrieval procs indeed, thanks for the heads up
Retrieving the resultset shapes can be beneficial tho, you can define typedviews on them, but if that's not your goal, the change to the # of resultsets for a proc is good enough