F-Anagrams - Re: informix market share - off topic

You are right. Madness had invaded by DDL. I actually ran soem tests now: db2 => create table select(from int); DB20000I The SQL command completed successfully. db2 => select from from select; FROM ----------- 0 record(s) selected. db2 => create table as (as int); DB20000I The SQL command completed successfully. -- Oops unfounded allegation here. I stand in shame db2 => SELECT AS FROM FROM AS SELECT; SQL0204N "SRIELAU.FROM" is an undefined name. SQLSTATE=42704 -- In need of a little help db2 => SELECT AS "FROM" FROM AS SELECT; FROM ----------- 0 record(s) selected. -- But now we're back on track :-) db2 => SELECT AS AS FROM FROM AS AS SELECT; FROM ----------- 0 record(s) selected. db2 => It's a "feature" called soft-keyword recovery. The intent is to minimize impact on legacy apps when adding new keywords. The reason why the second example fails, I believe, must be because 2 key words need to be transformed to identifier.. too much. Let's run your example: db2 => CREATE TABLE FROM (AS INT, SELECT INT); DB20000I The SQL command completed successfully. db2 => CREATE TABLE SELECT (AS INT, FROM INT); DB20000I The SQL command completed successfully. db2 => CREATE TABLE AS (AS INT, SELECT INT, FROM INT); DB20000I The SQL command completed successfully. db2 => SELECT SELECT FROM FROM; SELECT ----------- 0 record(s) selected. db2 => SELECT AS FROM SELECT AS FROM; AS ----------- 0 record(s) selected. db2 => SELECT FROM FROM SELECT; FROM ----------- 0 record(s) selected. db2 => SELECT AS FROM FROM AS SELECT; AS ----------- 0 record(s) selected. db2 => SELECT AS AS FROM FROM AS AS SELECT; FROM ----------- 0 record(s) selected. So what about Oracle? Any takers for the Anagram and keyword challenge?? Cheers Serge -- Serge Rielau DB2 SQL Compiler Development IBM Toronto Lab