IBM Mainframe Forum

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.

dynamicrules()

http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db29.doc.apsg/db2z_dynamicrulesbindoption.htm

Thanks , it was bound with defaults. It works now.