473,386 Members | 1,846 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 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 3477
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Uwe Ziegenhagen | last post by:
Hello, my fellows and me implement a c++ tool that is able to divide blank/tab separated files into <number>, <text>, <c-singlelinecomment> and <multilinecomment>. So far it's not working bad,...
7
by: Zhang Weiwu | last post by:
Hello. This is problem puzzled me a long time. I wish to organize some block elements and let them flow one after each other like text. Think about a album, I wish the album have 12 thumbnails,...
1
by: René | last post by:
Hello group, I have a question about a script i use. The function of the script is to dynamically write an ftp script and execute this with dos ftp.exe . This script always worked on a Windows...
2
by: ruby_bestcoder | last post by:
Hi Im having problem in firefox with display:none/block. I have essentially 3 li elements. In each element there are a few nested div:s. Clicking on one of the divs, makes another div to...
7
by: Aj-India | last post by:
Is there anyway that I could preserve the comments when creating an SP from Command Editor,so that when i import the SP in the development center I can see them. The reason for such a request is...
18
by: John Salerno | last post by:
I'm still tyring to figure out what "Pythonic" means, and I have a feeling the answer to my question may fall into that category. Are block comments somehow unpythonic?
8
by: Andrew Robinson | last post by:
Are these two equivalent? Is one better than the other? I tend to go with #1 but started wondering.... Thanks, 1: using (SqlConnection cn = new SqlConnection(DataConnection)) using...
3
by: MartinRinehart | last post by:
Tomorrow is block comment day. I want them to nest. I think the reason that they don't routinely nest is that it's a lot of trouble to code. Two questions: 1) Given a start and end location...
3
by: Richard | last post by:
Again, new to DB2. Trying to do something I can do in Sybase ASE. In any Sybase SQL script I can use /* */ to comment out a block of code. In the DB2 9.0 SQL Reference Manual V1 it says: ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

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.