RE: informix market share - off topic
Serge madgiggled:
> Try this (works in DB2 for LUW):
> CREATE TABLE FROM(SELECT INT);
Table created.
>
> SELECT FROM FROM SELECT;
206: The specified table (select) is not in the database.
111: ISAM error: no record found.
Error in line 1Near character position 23
>
> CREATE TABLE AS(AS INT);
Table created.
> SELECT AS FROM FROM AS SELECT;
217: Column (as) not found in any table in the query (or SLV is undefined).
Error in line 1Near character position 11
> SELECT AS AS FROM AS AS SELECT;
201: A syntax error has occurred.
Error in line 1Near character position 19
>
I would be truly fascinated if the above actually works on DB2.
So I renamed your tables and tried, again. I think this might be the SQL you want, which will at least execute in IDS 9.40.TC4.
CREATE TABLE FROM (AS INT, SELECT INT);
CREATE TABLE SELECT (AS INT, FROM INT);
CREATE TABLE AS (AS INT, SELECT INT, FROM INT);
SELECT SELECT FROM FROM;
SELECT AS FROM SELECT AS FROM;
SELECT FROM FROM SELECT;
SELECT AS FROM FROM AS SELECT;
SELECT AS AS FROM FROM AS AS SELECT;
And if you enjoy that, tell me if this works in DB2, since it gives a -201 in IDS:
SELECT FROM AS SELECT FROM AS SELECT;
It might if "SELECT AS AS FROM AS AS SELECT;" works.
And, yes, this was far more fun than reading yet another interminable thread on why IBM is [good|bad|indifferent] for Informix which will always be [better|worse|on a separate plane of existence] than that O ther database, so, thanks.
Sincerely,
Christopher Coleman
Steering Committee President
Kansas City Informix Users Group
www.iiug.org/kciug
Database Analyst
Pharmacy Division
Mediware Information Systems, Inc.
sending to informix-list