I working in MF cobol in UNIX environment. I declared cursor as followd.
EXEC SQL
DECLARE TRANTRGR-ROW-ENTRY CURSOR FOR
SELECT DTC_CNTRL_NBR
,TRGR_TYPE
,TRGR_STAT
,CREATE_USER
,CREATE_TMSTP
,UPDATE_USER
,UPDATE_TMSTP
FROM DB2.TRANTRGR
WHERE TRGR_TYPE = :WS-LIT-C-DTC-AFF-TXN AND
TRGR_STAT = :WS-LIT-C-NEW-TRIGGER
FOR UPDATE OF TRGR_STAT
,UPDATE_USER
,UPDATE_TMSTP
END-EXEC.
During comilation i am getting the following error.
[exec] * Micro Focus SQL External Compiler Module for IBM DB2 UDB
[exec] * Version 4.0.05 (C) copyright 1997-2008 Micro Focus (IP) Ltd.
[exec] 4792 END-EXEC.
[exec] * 801-S************ ( 0)**
[exec] ** External Compiler Module message
[exec] ** DB0100 SQL4946N The cursor or statement name "TRANTRGR-ROW-ENTRY" is
[exec] ** not defined. SQLSTATE=34000
Please help me to resolve the issue.
EXEC SQL
DECLARE TRANTRGR-ROW-ENTRY CURSOR FOR
SELECT DTC_CNTRL_NBR
,TRGR_TYPE
,TRGR_STAT
,CREATE_USER
,CREATE_TMSTP
,UPDATE_USER
,UPDATE_TMSTP
FROM DB2.TRANTRGR
WHERE TRGR_TYPE = :WS-LIT-C-DTC-AFF-TXN AND
TRGR_STAT = :WS-LIT-C-NEW-TRIGGER
FOR UPDATE OF TRGR_STAT
,UPDATE_USER
,UPDATE_TMSTP
END-EXEC.
During comilation i am getting the following error.
[exec] * Micro Focus SQL External Compiler Module for IBM DB2 UDB
[exec] * Version 4.0.05 (C) copyright 1997-2008 Micro Focus (IP) Ltd.
[exec] 4792 END-EXEC.
[exec] * 801-S************ ( 0)**
[exec] ** External Compiler Module message
[exec] ** DB0100 SQL4946N The cursor or statement name "TRANTRGR-ROW-ENTRY" is
[exec] ** not defined. SQLSTATE=34000
Please help me to resolve the issue.