Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to specify column header titles in a SQL CREATE TABLE statement?
Rhino wrote:
> However, I don't get quite the same results that you did from your two
> queries. I am running DB2 V7.2.7 on Windows XP.
>
> Given:
> db2 "select lastname as ""Lastname"" from employee where lastname like
> 'L%'"
>
> I get the following when I execute it on the DB2 command line:
> SQL0100N The string constant beginning with ""Lastname from employee where
> lastname like 'L%'" does not have an ending string delimiter.
> SQLSTATE=42603
>
> I can eliminate this error by putting *three* consecutive quotes after the
> alias, i.e.
> db2 "select lastname as ""Lastname""" from employee where lastname like
> 'L%'"
>
> This results in:
> Lastname
> -----------
> LUCCHESSI
> LUTZ
> LEE
>
> as you predicted.
>
> However, when I execute (on the DB2 command line):
> db2 "select lastname as \"Lastname\" from employee where lastname like
> 'L%'"
>
> I get:
> Lastname
> -----------
> LUCCHESSI
> LUTZ
> LEE
>
> just as you described.
>
> In any case, the original poster probably knows more now about column
> headings that he really wanted to know ;-)
You might want to look at the documentation for the DOS command prompt (or whatever you use) to figure out what it does with the quotes. A Unix shell, given
"abc \" def"
will pass the following string to the application
abc " def
The DOS command prompt works on the parameters as well somehow, and you have to counter that to get the " to DB2.
-- Knut Stolze Information Integration IBM Germany / University of JenaReceived on Mon Oct 18 2004 - 04:58:17 CDT