Subject How to set SQL DIALECT
Author Ruggero Maffei
Hi to all,

I've got the following problem:

I take care of every addition or modification applied to my database in one xml file like this

<instruction>
CREATE TABLE PAGES_LCID (
LANG_INDEX INTEGER NOT NULL,
LCID INTEGER
);
</instruction>

in order to rebuild exactly the same structure from scratch by executing all the query specified inside the tag instruction..

Currently i'm not able to perform the operations:

SET SQL DIALECT 3;
CREATE DOMAIN D_BOOLEAN AS
INTEGER
DEFAULT 0
CHECK (VALUE BETWEEN 0 AND 1);

Is it possible to do it by executing a query or i need to use isql for these purposes?

Thanmk you very much..



[Non-text portions of this message have been removed]