Thread: DB2 Plan Question
View Single Post
  #3 (permalink)  
Old 01-05-09, 18:24
Marcus_A Marcus_A is online now
Registered User
  
Join Date: May 2003
Location: USA
Posts: 5,006
Quote:
Originally Posted by KevinYC
THE OPEN STATEMENT FOR CURSOR 'CUR_PMTYR' IS INVALID BECAUSE THE CURSOR WAS DEFINED BY AN ALLOCATE CURSOR STATEMENT.
Looks like we need to see the declare cursor and the open statement for this error.
__________________
M. A. Feldman
IBM Certified DBA on DB2 for Linux, UNIX, and Windows
IBM Certified DBA on DB2 for z/OS and OS/390
Reply With Quote