MVSFORUMS.com

[syam]

Hi,
I want to use Dynamic Sql Select Query in a cobol , DB2, CICS program, Please let me know the process and compiler options and any other issues to be taken care of.I want a practical programmable solution

Thanks
_________________
S Y A M
ONE CAN SMILE AND SMILE AND BE A VILLIAN

[kolusu]

syam,


Check this link which explains every thing about dynamic sql along with examples here

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/6.1?DT=20010710165542

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[syam]

Kolusu,

Thanks for the info.After fetching the rows , the rows are moved into SQLDA, How to retrieve these values from SQLDA.
_________________
S Y A M
ONE CAN SMILE AND SMILE AND BE A VILLIAN

[kolusu]

[syam]

Kolusu,
Thank you now i got the things. Any how i made the design changes so that the progarm could accomadate for fixed list selct. I have browsed the ibm link http://publib.boulder.ibm.com/infocenter/iseries/v5r3/index.jsp?topic=/sqlp/rbafyfixed.htm . He gave the below example
MOVE 'SELECT EMPNO, LASTNAME FROM CORPDATA.EMPLOYEE WHERE EMPNO>?'
TO DSTRING.
EXEC SQL
PREPARE S2 FROM :DSTRING END-EXEC.

EXEC SQL
DECLARE C2 CURSOR FOR S2 END-EXEC.

EXEC SQL
OPEN C2 USING :EMP END-EXEC.

PERFORM FETCH-ROW UNTIL SQLCODE NOT=0.

EXEC SQL
CLOSE C2 END-EXEC.
STOP-RUN.
FETCH-ROW.
EXEC SQL
FETCH C2 INTO :EMP, :EMPNAME END-EXEC.

Now what should be the Picture clause of S2. Awaiting for a quick reply.
_________________
S Y A M
ONE CAN SMILE AND SMILE AND BE A VILLIAN

[syam]

Kolusu,
Execution is successful without declaring S2, Thank you very much for the efforts put up.
_________________
S Y A M
ONE CAN SMILE AND SMILE AND BE A VILLIAN