Unable to Query Column With Same Name as Keyword

Anthony Gerhardt <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Organization http://groups.google.com
Message-ID <[email protected]>
I've got a query in Sybase IQ 15.1:

SET quoted_identifier on
SELECT col."default"
FROM   systabcol col

Which runs fine in my query tool (QTODBC 70).  However the same query
in PerlDBI is return an error:

DBD::Sybase::db selectcol_arrayref failed: Server message number=102
severity=15 state=0 line=0 text=SQL Anywhere Error -131: Syntax error
near 'default' on line 2
 [for Statement "
                SET quoted_identifier on
                SELECT col."default"
                FROM   systabcol col
"]

I've also tried \"default\".
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.