View previous topic :: View next topic
|
Author |
Message |
thesexyone
New User
Joined: 02 Jan 2006 Posts: 7
|
|
|
|
Hi guys and gals,
Any ideas about this:
I have a simple COBOL/DB2. In working storage I have a declare cursor c1 for select emp from employees.
I compile in batch - but I get a pre-complilation error:
DSNH520I E DSNHSMUD LINE 72 COL 22 THE OPEN STATEMENT FOR CURSOR 'EMP_CUR' IS INVALID BECAUSE THE CURSOR WAS DEFINED BY AN ALLOCATE CURSOR STATEMENT.
Can't understand why..any ideas much appreciated!
Thanks |
|
Back to top |
|
|
thesexyone
New User
Joined: 02 Jan 2006 Posts: 7
|
|
|
|
sorry not c1 it's emp_cur in working storage. Typo |
|
Back to top |
|
|
senthilssg
New User
Joined: 09 Dec 2005 Posts: 64 Location: USA
|
|
|
|
Hi ,
The cursor is not defined properly .. Please check with the declaration of cursor .
I hpoe that this help you..
Regards ,
senthil |
|
Back to top |
|
|
DavidatK
Active Member
Joined: 22 Nov 2005 Posts: 700 Location: Troy, Michigan USA
|
|
|
|
thesexyone,
Can you please supply us with the exact cursor declare and the exact OPEN statement(s) for the cursor?
Thanks,
Dave |
|
Back to top |
|
|
thesexyone
New User
Joined: 02 Jan 2006 Posts: 7
|
|
|
|
Hi chaps and chapesses,
I've actually got past this problem now. I've realized I was using version 5 of DB2 and consequently you can't declare a cursor in the working storage section. It has to be declared in the procedure division.
Thanks |
|
Back to top |
|
|
|