View previous topic :: View next topic
|
Author |
Message |
Susanta
Active User
Joined: 17 Nov 2009 Posts: 126 Location: India
|
|
|
|
My rexx program using sql cursor.
It is giving error -514( THE CURSOR IS NOT IN A PREPARED STATE ).
Please help. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
Back to top |
|
|
Marso
REXX Moderator
Joined: 13 Mar 2006 Posts: 1353 Location: Israel
|
|
|
|
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 |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009 Posts: 2481 Location: Netherlands, Amstelveen
|
|
|
|
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 |
|
|
ofer71
Global Moderator
Joined: 27 Dec 2005 Posts: 2358 Location: Israel
|
|
Back to top |
|
|
|