What the problem is with -124 SQLCODE

Jatin saraf · Posted: Wed Jul 11, 2007 9:53 pm

Any idea on what the problem is with -124 SQLCODE??
Error Assist does not have any explanation for this.

dick scherrer · Posted: Wed Jul 11, 2007 9:58 pm

Hello,

Please post your code that caused the -124 sqlcode.

Jatin saraf · Posted: Wed Jul 11, 2007 10:05 pm

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.

dick scherrer · Posted: Wed Jul 11, 2007 11:05 pm

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.