table name with period "."

hew212 · #1 (**permalink**) 12-11-03, 01:25

My table name got a "." , e.g. OE.SALES

sql> SELECT * FROM "OE.CSSALES2";
SELECT * FROM "OE.CSSALES2";
-----------------------------^
syntax error.

Can somebody help Me ?

gurey · #2 (**permalink**) 12-11-03, 10:12

Quote:

Originally posted by hew212
My table name got a "." , e.g. OE.SALES

sql> SELECT * FROM "OE.CSSALES2";
SELECT * FROM "OE.CSSALES2";
-----------------------------^
syntax error.

Can somebody help Me ?

Hi,

Please define environment variable DELIMIDENT=1, next dbaccess database name then run sql.
SELECT * FROM "OE.CSSALES2";

Gustavo.

Internet Services

Web Development

Digital Marketing

Consumer Tech