Database reserved words

[Glaucio Scheibel <gl...@datasul.com.br>]

Hi,

I am evaluating ddlutils for my actual project and didn't find this 
information. Does ddlutils knows each database reserved words? Ex: in 
db2, I can't have a table with name 'order'.

Thanks in advance
Glaucio

Re: Database reserved words

[Thomas Dudziak <to...@gmail.com>]

On 2/8/06, Thorbjørn Ravn Andersen <th...@gmail.com> wrote:

> I have seen databases where you could use reserved words anyway by
> enclosing them in quotes when being used as table names etc.
>
> Does that apply to DB2 too?

Yep, every database that DdlUtils supports except Axion is able to use
delimited identifers. These allow to use reserved words, whitespaces
etc. in table names, column names, ...
You can use these in DdlUtils by setting the corresponding property in
the Ant task or in the PlatformInfo instance of the platform (if using
the Api).
Btw, currently the delimited identifier mode is the default though
this is likely to change before the 1.0.

Tom

Re: Database reserved words

[Thorbjørn Ravn Andersen <th...@gmail.com>]

Glaucio Scheibel wrote:

> Hi,
>
> I am evaluating ddlutils for my actual project and didn't find this 
> information. Does ddlutils knows each database reserved words? Ex: in 
> db2, I can't have a table with name 'order'.
>
> Thanks in advance
> Glaucio
>
>
I have seen databases where you could use reserved words anyway by 
enclosing them in quotes when being used as table names etc.

Does that apply to DB2 too?

-- 
  Thorbjørn

Re: Database reserved words

[Thomas Dudziak <to...@gmail.com>]

On 2/6/06, Glaucio Scheibel <gl...@datasul.com.br> wrote:

> I am evaluating ddlutils for my actual project and didn't find this
> information. Does ddlutils knows each database reserved words? Ex: in
> db2, I can't have a table with name 'order'.

Nope, DdlUtils does not check any names (tables, columns, ...) because
this would involve a lot of tedious work. E.g. you cannot stop at
reserved words - databases like Oracle or Db2 also create tables
themselves whose name you cannot use, and most databases create
indices for primary keys and sometimes for foreign keys with special
names that you then cannot take either.

Tom