If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Informix > Sql Problem

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-09-03, 05:14
hew212 hew212 is offline
Registered User
 
Join Date: Dec 2003
Posts: 26
Question Sql Problem

DO SOMEBODY KNOW WHAT WRONG WITH THIS SQL?

SELECT * FROM OE.SALES

A MESSAGE SAID QUALIFIED TABLE NAMES ARE NOT YET SUPPORTED.
Reply With Quote
  #2 (permalink)  
Old 12-09-03, 05:57
vpshriyan vpshriyan is offline
Registered User
 
Join Date: Nov 2003
Location: Mumbai, India
Posts: 92
Hi,

Instead Try:
SELECT * FROM sales ;

I feel that "oe" is the owner of sales table. Normally syntax like:
SELECT * FROM oe.sales ;

is suported across all types of databases (nolog, log, ansi), however it is explicitly mentioned under ANSI compliant databases.

Regards,
Shriyan
Reply With Quote
  #3 (permalink)  
Old 12-09-03, 10:00
hew212 hew212 is offline
Registered User
 
Join Date: Dec 2003
Posts: 26
Quote:
Originally posted by vpshriyan
Hi,

Instead Try:
SELECT * FROM sales ;

I feel that "oe" is the owner of sales table. Normally syntax like:
SELECT * FROM oe.sales ;

is suported across all types of databases (nolog, log, ansi), however it is explicitly mentioned under ANSI compliant databases.

Regards,
Shriyan
**************************************************
Thank for helping me. However, I had tried before by using
SELECT * FROM sales;
but it said " NO PRIVILAGE FILE"

I tried another file that without a dot ("."), e.g. named OE_SALES, it work. Is the dot (".") affect the SQL statement?
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On