Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

What the problem is with -124 SQLCODE

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
Jatin saraf

New User


Joined: 30 Mar 2007
Posts: 22
Location: United States of america

PostPosted: Wed Jul 11, 2007 9:53 pm    Post subject: What the problem is with -124 SQLCODE
Reply with quote

Any idea on what the problem is with -124 SQLCODE??
Error Assist does not have any explanation for this.
Back to top
View user's profile Send private message

dick scherrer

Site Director


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

PostPosted: Wed Jul 11, 2007 9:58 pm    Post subject:
Reply with quote

Hello,

Please post your code that caused the -124 sqlcode.
Back to top
View user's profile Send private message
Jatin saraf

New User


Joined: 30 Mar 2007
Posts: 22
Location: United States of america

PostPosted: Wed Jul 11, 2007 10:05 pm    Post subject:
Reply with quote

The error is coming while opening the cursor:-
EXEC SQL
OPEN WDC_STR
END-EXEC.

The cursor is defined as:-

EXEC SQL
DECLARE WDC_STR CURSOR FOR
SELECT DISTINCT NUM_STR
FROM PROD.WHS_LOAD_GROUP
WHERE NUM_STR = 01973
AND NUM_WH = 9995
ORDER BY NUM_STR
END-EXEC.
The table is a Datacom table.
Back to top
View user's profile Send private message
dick scherrer

Site Director


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

PostPosted: Wed Jul 11, 2007 11:05 pm    Post subject:
Reply with quote

Hello,

I will move this to the CA Products section of the forum. Datacom is a CA product.

Do you have the Datacom manuals? If so, the info should be in the Datacom documentation. If you don't have the documentation and your organization is licensed to use Datacom, the documentation is available for free from teh CA support site.

You might also ask yuour Datacom DBA about the -124 and it there is a local copy of the documentation.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Strings with double quotes having pro... raja Arumugam All Other Mainframe Topics 11 Thu Mar 30, 2017 10:34 am
No new posts Problem reading GTF trace output danik56 ABENDS & Debugging 7 Thu Mar 16, 2017 1:02 pm
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts ROUNDED Problem with COMPUTE statement shalem COBOL Programming 11 Thu Feb 09, 2017 8:16 pm
No new posts SYMNAMES problem jacobdng DFSORT/ICETOOL 7 Thu Dec 22, 2016 7:47 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us