Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    26

    Question Unanswered: table name with period "."

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

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


    Can somebody help Me ?
    Last edited by hew212; 12-11-03 at 02:34.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780

    Re: table name with period "."

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •