Comment out SQL Statement

Antonis Galaios

Comment out SQL Statement
Dear listers hi

I have in a program an SQL statement comment out , but it is written in
our Plan_Table and in SYSIBM.SYSPACKSTMT . I also run a query against
Plan_Table in order to find the queries within our Cobol programs that
do Table Space Scan and I get this comment out SQL statement .Is there a
way to exclude all comment out statements? We are in DB2 V7.1 for z/OS



Disclaimer:
This e-mail is confidential. If you are not the intended recipient, you should not copy it, re-transmit it, use it or disclose its contents, but should return it to the sender immediately and delete the copy from your system.
EFG Eurobank Ergasias S.A. is not responsible for, nor endorses, any opinion, recommendation, conclusion, solicitation, offer or agreement or any information contained in this communication.
EFG Eurobank Ergasias S.A. cannot accept any responsibility for the accuracy or completeness of this message as it has been transmitted over a public network. If you suspect that the message may have been intercepted or amended, please call the sender.


---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Dave Nance

Re: Comment out SQL Statement
(in response to Antonis Galaios)
I think you may mean that you have commented out the call to this sql statement, so it will not be executed. There is still an exec sql and a valid sql statement. To not have it in plan table and sysstatement, the entire statement must be commented out. Like I said this is a guess, but something I have answered for developers a few times in the past.

Galeos Antonis <[login to unmask email]> wrote: Dear listers hi
I have in a program an SQL statement comment out , but it is written in our Plan_Table and in SYSIBM.SYSPACKSTMT . I also run a query against Plan_Table in order to find the queries within our Cobol programs that do Table Space Scan and I get this comment out SQL statement .Is there a way to exclude all comment out statements? We are in DB2 V7.1 for z/OS

Disclaimer:
This e-mail is confidential. If you are not the intended recipient, you should not copy it, re-transmit it, use it or disclose its contents, but should return it to the sender immediately and delete the copy from your system.
EFG Eurobank Ergasias S.A. is not responsible for, nor endorses, any opinion, recommendation, conclusion, solicitation, offer or agreement or any information contained in this communication.
EFG Eurobank Ergasias S.A. cannot accept any responsibility for the accuracy or completeness of this message as it has been transmitted over a public network. If you suspect that the message may have been intercepted or amended, please call the sender.
--------------------------------------------------------------------------------- Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


---------------------------------
Access over 1 million songs - Yahoo! Music Unlimited.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm