DB2 Stored procedure error



IBM's flagship relational database management system

DB2 Stored procedure error

Postby p19689 » Mon Dec 13, 2010 8:54 pm

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.
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 Stored procedure error

 

Re: DB2 Stored procedure error

Postby GuyC » Tue Dec 14, 2010 7:24 pm

I can explain it to you, but i can not understand it for you.
GuyC
 
Posts: 315
Joined: Tue Aug 11, 2009 3:23 pm
Has thanked: 1 time
Been thanked: 4 times

Re: DB2 Stored procedure error

Postby p19689 » Wed Dec 15, 2010 7:26 pm

Thanks , it was bound with defaults. It works now.
p19689
 
Posts: 65
Joined: Fri Oct 01, 2010 1:13 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post