DB2 DYNAMIC STORED PROCEDURE



IBM's flagship relational database management system

DB2 DYNAMIC STORED PROCEDURE

Postby Padma6 » Thu Jul 09, 2009 8:34 pm

Hello,

I have coded a dynamic SQL statement in my DB2 Stored Procedure.
When i run my stored procedure i am hitting a -805 on the Prepare and Execute statement.

What am i missing ?
Please advise.
Padma6
 
Posts: 1
Joined: Thu Jul 09, 2009 8:30 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 DYNAMIC STORED PROCEDURE

 

Re: DB2 DYNAMIC STORED PROCEDURE

Postby dick scherrer » Fri Jul 10, 2009 1:20 am

Hello,

Did you look in the db2 messages?
http://publibz.boulder.ibm.com/cgi-bin/ ... /2.1.6.398?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post