Subject | How to set SQL DIALECT |
---|---|
Author | Ruggero Maffei |
Post date | 2003-12-23T14:31:56Z |
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]
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]