Re: Fun with SQL
Posted in 2005
ART KAGEL, BLOOMBERG/ 731 LEXIN — — source: IIUG Forums & Mailing Lists
Read the release notes for IDS 7.31. There was a massive effort as part of that
release and the equivalent codeline 9.21 to remove all unneccessary keywords
per ANSI SQL-92 standards.
Art S. Kagel
----- Original Message -----
From: John Bejarano <jbejarano@sbcglobal.net>
At: 5/18 15:58
So, I have to tip my hat to the engineers who wrote
the SQL parser for Informix. Believe it or not, the
following SQL will run with no errors:
create table from
(select integer,
where varchar(10),
and varchar(10),
or varchar(10));
select select from from where where = '=' and andmatches 'matches' or or like 'like';
Keywords, what are those?
--John Bejarano.