Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 SQLCODE 518 while executing DB2 module. abdulrafi DB2 8 Wed Feb 07, 2018 10:46 am
No new posts SQLCODE=100 and SQLSTAE 02000 pshongal DB2 12 Fri Jan 19, 2018 10:14 am
No new posts Having a problem FTP'ng to the MF pahiker All Other Mainframe Topics 2 Fri Nov 10, 2017 8:20 pm
No new posts LMINIT problem - not finding DDNAME Danielle.Filteau CLIST & REXX 7 Tue Sep 19, 2017 9:57 pm
No new posts Problem commiting to DB2 from IMS MPP Ole Soerensen IMS DB/DC 2 Wed Jul 26, 2017 5:19 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us