Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Alejandro
Dunno if this will help but you may try:
select * from "alex".customers
HTH
Sujit
______________________________ Reply Separator _________________________________
Subject: Tablename qualifiers in ODBC
Author: "Alejandro Alberola Arias" <alberola@bio.es> at Internet
Date: 10/23/1998 8:22 PM
Hello,
I have a table named customers and an user named alex.
If I execute the following statement from the SQL Editor,
it doesn't work:
select * from alex.customers
I suppose that IDS don't support tablename qualifiers.
But when I run Windows applications using ODBC
(Openlink ODBC or Intersolv ODBC) they use
statements like the former. And of course they
don't work properly and I get an error like this:
"The specified table (alex.customers) is not in the
database"
How can I configure the ODBCs or IDS to avoid this ?
Thanks in advance.
Alejandro Alberola
alberola@bio.es
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.