IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Is it required to bind a rexx program if it has sql ?


IBM Mainframe Forums -> CLIST & REXX
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Susanta

Active User


Joined: 17 Nov 2009
Posts: 126
Location: India

PostPosted: Mon Mar 08, 2010 11:06 am
Reply with quote

My rexx program using sql cursor.

It is giving error -514( THE CURSOR IS NOT IN A PREPARED STATE ).

Please help.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Mon Mar 08, 2010 11:17 am
Reply with quote

Hello,

The forum search can be your friend icon_smile.gif

See if this previous topic has info that will help:
ibmmainframes.com/viewtopic.php?t=44443&highlight=rexx+sql
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1353
Location: Israel

PostPosted: Mon Mar 08, 2010 11:21 am
Reply with quote

Check SQLCODE after each statement (DECLARE and PREPARE too)

Check a sample here

edit: oops, same link as posted by d.sch.
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2358
Location: Israel

PostPosted: Mon Mar 08, 2010 11:23 am
Reply with quote

You don't need to bind each REXX EXEC accessing DB2, but you do need to bind the REXX language support modules when you install DB2, as described in the fine manual.

O.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen

PostPosted: Mon Mar 08, 2010 5:19 pm
Reply with quote

ofer71 wrote:
You don't need to bind each REXX EXEC accessing DB2, but you do need to bind the REXX language support modules when you install DB2, as described in the fine manual.

O.


Tzohora'im Tovim Ofer,

indeed thats a fine manual.

Kol Tov.
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2358
Location: Israel

PostPosted: Mon Mar 08, 2010 5:53 pm
Reply with quote

2014.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> CLIST & REXX

 


Similar Topics
Topic Forum Replies
No new posts Using API Gateway from CICS program CICS 0
No new posts Running REXX through JOB CLIST & REXX 13
No new posts Error to read log with rexx CLIST & REXX 11
No new posts isfline didnt work in rexx at z/OS ve... CLIST & REXX 7
No new posts run rexx code with jcl CLIST & REXX 15
Search our Forums:

Back to Top