MVSFORUMS.com

[ranga_subham]

Hi,

I am very sorry if this is very basic question.

I have a COBOL-DB2 program with embedded SQL statements.

SELECT EMP-NAME, EMP-AGE
FROM EMPTABL
WHERE EMP-LAST-NAME = 'KOLUSU';

SELECT EMP-NAME, EMP-GENDER
FROM EMPTABL
WHERE EMP-GENDER = 'F';

SELECT EMP-DOB, EMP-ADDR
FROM EMPTABL
WHERE EMP-FRST-NAME = 'KOLUSU';

Now, I would like to know how the COBOL converts them to the equivalent CALL statements of each.

Please explain in detail.

Thanks in advance.
_________________
Ranga
*****
None of us is as smart as all of us - Ken Blanchard

[shekar123]

ranga_subham,

After you pre-compile a COBOL-DB2 program , check for the compile listing in the spool and you wil be able to see the SQL statements being converted to equivalent CALL statements.

A sample of conversion would be below.Similarly check in the spool the entire conversion of SQL statements.

[ranga_subham]

Thanks Shekar.
_________________
Ranga
*****
None of us is as smart as all of us - Ken Blanchard