Block commenting in DB2 version 9.5

Hi,
How do I comment out a block of code in DB2 version 9.5?
In SQL Server I use /*  */
Any equivalent in DB2?
I'm using Command Center to create queries.
any help appreciated,
thanks
blossomparkAsked:
Who is Participating?
 
momi_sabagConnect With a Mentor Commented:
exactly the same as SQL Server
-- will comment until the end of the row
/* */ creates a comment block
0
 
sathyaram_sConnect With a Mentor Commented:
In the command editor, AFAIK, you cannot use block comments.

But, you can use the same /*   */ in the SQL PL (Triggers, procedures, functions)


HTH

Sathyaram
0
 
Kent OlsenConnect With a Mentor Data Warehouse Architect / DBACommented:
@Blossom

It's completely dependent up the client that you're using.

The DB2 Client doesn't recognize block comments, only the double-hyphen initiated inline comment.  Other clients recognize the *C* like block comments, but they actually filter out the commented text before sending it to DB2.

Which client(s) are you using?


Kent
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
blossomparkAuthor Commented:
Hi Kent,
             am using Control Center from  IBM DB2 General Administration Tools
0
 
sathyaram_sConnect With a Mentor Commented:
The control center does not recognize block comments. only "--" comment at the beginning of the line.
0
 
blossomparkAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 125 points for momi_sabag's comment http:/Q_27493221.html#37284761
Assisted answer: 125 points for sathyaram_s's comment http:/Q_27493221.html#37284795
Assisted answer: 125 points for Kdo's comment http:/Q_27493221.html#37285111
Assisted answer: 0 points for blossompark's comment http:/Q_27493221.html#37285136
Assisted answer: 125 points for sathyaram_s's comment http:/Q_27493221.html#37285199

for the following reason:

Hi Kdo,sathyaram s, momi sabag, thanks for all your inputs....thanks for clarifying that sathyaram s
0
 
blossomparkAuthor Commented:
i didn't mean to assign points to myself
0
 
blossomparkAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for blossompark's comment http:/Q_27493221.html#37285245
Assisted answer: 125 points for momi_sabag's comment http:/Q_27493221.html#37284761
Assisted answer: 125 points for sathyaram_s's comment http:/Q_27493221.html#37284795
Assisted answer: 125 points for Kdo's comment http:/Q_27493221.html#37285111
Assisted answer: 125 points for sathyaram_s's comment http:/Q_27493221.html#37285199

for the following reason:

I dont want to accept my own comment! how do i reverse out of this?
0
 
JustAModCommented:
Cancelling to adjust "Accepted Answers, by removing http:#37285245 by the author.

Thanks, '

JustAMod
CS Moderator
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.