I just noticed that there are many SQL syntax with MODE DB2SQL in the help
document and many do not have this. What is the different bewteen them ?

Thanks for any help
Tom

More : What are the modes other than DB2SQL mode ? Which DB2 document I
should look at for more details.

cmc wrote:
> More : What are the modes other than DB2SQL mode ? Which DB2 document I
> should look at for more details.
MODE DB2SQL is used whenever a critical DDL statement was introduced
before the SQL Standard blessed the syntax or semantics. This allows
development to introduce standard compliant syntax later without using
database switches.
A couple of examples are
CREATE TYPE and CREATE TRIGGER.
Note that in CREATE TRIGGER "MODE DB2SQL" is optional in DB2 V8.2.
It will likely be completely removed from the docs in the next release
because triggers in DB2 comply with teh SQL Standards.

Cheers
Serge



--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

"cmc" <cmc3232@yahoo.com> wrote in message
news:4tu9e.10878$Jg5.693539@news20.bellglobal.com. ..
> More : What are the modes other than DB2SQL mode ? Which DB2 document I
> should look at for more details.
>
The phrase MODE DB2SQL is required for certain statements like CREATE
TRIGGER. It is completely irrelevant for most other statements: it has no
relevance to CREATE TABLE, for example, so it is not required there.


At the moment, MODE DB2SQL doesn't do anything, as far as I know, it is just
required for statements like CREATE TRIGGER. I'm not sure if IBM requires
this clause in statements like CREATE TRIGGER or if this is forced by one of
the SQL standards like SQL99. I haven't used other vendors databases very
much so I don't know if there CREATE TRIGGER statements also include MODE
DB2SQL.

Rhino