SQL CODE -301 while trying to Open a Cursor

neelesht · Posted: Thu Aug 02, 2007 9:16 am

Hi All,

When I try to open a cursor I get -301 SQL Code.
I checked and the data types of the variables are correct.

Could you please let me know what could be the issue and what could be the resolution ?

Thanks
-Neelesh

Rajesh S · New User Joined: 11 Jul 2007 Posts: 54 Location: Chennai

Hai,

I think error in your table variables position. The input host variables in the SQLDA entry number indicate by position numbers.

Are you working in COBOL or PL/1?

Regards
Rajesh S

neelesht · Posted: Thu Aug 02, 2007 10:59 am

Hi rajesh,

Thanks
I am working on COBOL.

Thanks
-Neelesh

Rajesh S · New User Joined: 11 Jul 2007 Posts: 54 Location: Chennai

Hai Neelesh,

I'm not able to guess. From where you getting this error. With out known your codings....

Try to explain clearly

Suryanarayana.tadala · New User Joined: 03 Nov 2005 Posts: 43 Location: St.Louis

Could you please post the cursor and the scenario under which you are using this cursor.

Thanks

dbzTHEdinosauer · Posted: Fri Aug 03, 2007 1:09 am

The only variables at issue with the OPEN CURSOR statement are in the WHERE clause of the DECLARE CURSOR.

The host receiving variables are in the FETCH CURSOR statement, which has not been executed, and not in the DECLARE CURSOR statement.

So, find the host variables and/or literals in the WHERE clause are not correct - datatype, usage, etc...