471,049 Members | 1,407 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

Block comments in DB2 Command center

Hi ,
Could anybody tell us how to use block comments in IBM DB2 Command
Center .The version of the client that I'm using is 8.1.6 . I need to
comment multiple lines that appear consecutively in an SQL statement.

Also using /* ...... */ did not work as a block comment.
Below is the SQL we were trying...

select
col1,
/* col2,
col3 */
col4
from schm1.tabname1
where col1 = 81640 with ur

The following error was received .
SQL0104N An unexpected token "/" was found following "select col1, ".
Expected tokens may include: "<term>

Thanks.

Sep 6 '06 #1
2 3360
jo********@gmail.com wrote:
Hi ,
Could anybody tell us how to use block comments in IBM DB2 Command
Center .The version of the client that I'm using is 8.1.6 . I need to
comment multiple lines that appear consecutively in an SQL statement.

Also using /* ...... */ did not work as a block comment.
Below is the SQL we were trying...

select
col1,
/* col2,
col3 */
col4
from schm1.tabname1
where col1 = 81640 with ur

The following error was received .
SQL0104N An unexpected token "/" was found following "select col1, ".
Expected tokens may include: "<term>
Some improvements have been made in the latest fixpack.
I'm not sure whether it covered command center. But it did cover CLP.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/
Sep 6 '06 #2

Serge Rielau wrote:
jo********@gmail.com wrote:
Hi ,
Could anybody tell us how to use block comments in IBM DB2 Command
Center .The version of the client that I'm using is 8.1.6 . I need to
comment multiple lines that appear consecutively in an SQL statement.

Also using /* ...... */ did not work as a block comment.
Below is the SQL we were trying...

select
col1,
/* col2,
col3 */
col4
from schm1.tabname1
where col1 = 81640 with ur

The following error was received .
SQL0104N An unexpected token "/" was found following "select col1, ".
Expected tokens may include: "<term>
Some improvements have been made in the latest fixpack.
I'm not sure whether it covered command center. But it did cover CLP.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/ond...ness/conf2006/

you can use -- meand double hyphen to comment your line

Ritesh Kumar

Sep 7 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Uwe Ziegenhagen | last post: by
1 post views Thread by René | last post: by
2 posts views Thread by ruby_bestcoder | last post: by
18 posts views Thread by John Salerno | last post: by
8 posts views Thread by Andrew Robinson | last post: by
3 posts views Thread by MartinRinehart | last post: by
3 posts views Thread by Richard | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.