Unanswered: Default qualifier in a stored procedure
I am using DB2 v8.1 on linux. I created a SQL stroed procedure SP1 under schema1 which accesses an unqualifed Table1. Now under schema2, I call SP1:
What would be the qualifier of Table1? It seems to be schema1. But what I really need is to output the qualifier and the table name (in a format of "qualifier.Table1") into a script so I can use the script outside of the SP. Hard coding it as "schema1" is not my choice. And I know special register "current schema" would be become schema2 at run time. Could you please advise and give me a reference (DB2 manuals) if possible?