Data Column in Table Uses COLON

[beanNut]

Can anyone help me I'm using DB2 to select date range
and the column header was defined with a colon.
this doesn't seem to work below????


select db2admin."v_QISDBGARRY"."DATE"
from DB2ADMIN."v_QISDBGARRY"
where "DATE" between '2004-11-30' AND '2005-01-01'

 

[MarcLodge]

Bean,
Debug it bit by bit.
Get rid of the where clause and see if it runs.
If not, replace the specific field selection with a SELECT *
I've not seen a colon in a field name before and would have thought that it is a reserved symbol as it is used to determine host variables and null variables in programming languages that interface with DB2.

If it is at all possible, I would change the column name as without doing this I think you are bringing trouble and misunderstanding down on yourself.

Marc

 

[sureshhai]

What is the use of colon) symbol, in db2 and what does it do?

example:

:variable left outer join :variable

means what?

I appreciate u, if u reply for this que?

 

[sathyarams]

What is the error message?

: is acceptable if you enclose the col name within double quotes, afaik ...

:variable is a host variable

Sathyaram

For db2 resoruces visit

http://www.db2click.com

More DB2 questions answered at

http://www.dbforums.com/f8

&

http://www.idug.org/user/UserLogin.asp