Yes it is possible to convert from static sql to dynamic sql. Refer to the DB2 product programming references for examples on how to do it.
Talk to your DBA about possible security adjustments and other issues dynamic sql bring to the table. Jeffrey Celander Software Contractor EGS Innovations, Inc. -----Original Message----- From: IBM Mainframe Discussion List [mailto:ibm-m...@bama.ua.edu] On Behalf Of Marco Gianfranco Indaco Sent: Wednesday, August 18, 2010 12:02 PM To: IBM-MAIN@bama.ua.edu Subject: Cobol Db2 Question Hi to all. Does somebody know if it's possible convert a static cursor into dynamic (or both)? Is there a special host-variable where the static cursor is stored to be called dynamically? Regards. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@bama.ua.edu with the message: GET IBM-MAIN INFO Search the archives at http://bama.ua.edu/archives/ibm-main.html
