Look up and Relation stage in MVS
Posted: Tue Dec 12, 2006 11:02 am
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
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