Page 1 of 1

DB2 Stored procedure error

PostPosted: Mon Dec 13, 2010 8:54 pm
by p19689
Hi, I'm having a error 'table undefined' (-204) when fired a dynamic SQL query via a stored procedure. It doesn't qualifier the table with the schema of the procedure. Insted it pick the primary authorid of the person who runs the stored procedure. Could you please advise how should I qualify the table in a dynamic SQL query as schema of the stored procedure without hard-coding?

Thanks a very much.

Re: DB2 Stored procedure error

PostPosted: Tue Dec 14, 2010 7:24 pm
by GuyC

Re: DB2 Stored procedure error

PostPosted: Wed Dec 15, 2010 7:26 pm
by p19689
Thanks , it was bound with defaults. It works now.