Hi All
I am using two lookup stages and their respective Relational stages from which they do the look up.
But in the cobol code generated , one of the sql is generated using cursor. and for the other look up stage its just a direct row fetch.
I am not able to find out how can i stop the cursor generation for the SQL query
Here are the two queries:
=======================
* DECLARE CURSOR FOR SCAN CLIENT_TAB2
*
*
EXEC SQL
DECLARE CNT_TAB2 CURSOR FOR
SELECT CNT_TAB_REF_C_1.CNT_ID
FROM (SELECT CNT_TA1.CNT_ID
FROM CNT_TAB AS CNT_TA1) CNT_TAB_REF_C_1
END-EXEC
*
==================================
The other look up
==================================
* ---------------------------------------------------------------
* DB2-CM-POL-SCHE1: GETROW
* ---------------------------------------------------------------
DB2-CM-POL-SCHE1-GETROW.
EXEC SQL
SELECT DB2_CLM_POL_SCHE_0.POLICY_NBR,
DB2_CLM_POL_SCHE_0.MTA_QTE_ID,
INTO
:HOSTVARS1.HV--POLICY-NBR-DS3750
:HOSTVARS1.HV--POLICY-NBR-DS3750-I,
:HOSTVARS1.HV-MTA-QTE-ID-DS3752
:HOSTVARS1.HV-MTA-QTE-ID-DS3752-I,
FROM (SELECT GLOBAL_CD_RE1.POLICY_NBR,
GLOBAL_CD_RE1.MT_QTE_ID,
FROM GLOBAL_CD_REF AS GLOBAL_CD_RE1
END-EXEC
If Some body can help.
Thanks in Advance
Rupesh
Look up and Relation stage in MVS
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The only place you have any customization control is by managing the JCL templates. As far as I am aware you can not influence the COBOL source that is generated. But I'd be happy to be corrected.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: