为什么我的.sql文件运行错误？

shooterwin 2005-03-20 05:46:02

下面是.sql的部分文件
/*SET SQL DIALECT 3;*/
/* CREATE DATABASE 'd:\lfsofthotel\hoteldata.gdb' PAGE_SIZE 4096
DEFAULT CHARACTER SET */
/* Domain definitions */
CREATE DOMAIN "DOMAIN_BH" AS VARCHAR(5);
CREATE DOMAIN "DOMAIN_BZ" AS VARCHAR(60);
CREATE DOMAIN "DOMAIN_C10" AS VARCHAR(10);
CREATE DOMAIN "DOMAIN_C12" AS VARCHAR(12);
CREATE DOMAIN "DOMAIN_C16" AS VARCHAR(16);
CREATE DOMAIN "DOMAIN_C18" AS VARCHAR(18);
CREATE DOMAIN "DOMAIN_C2" AS VARCHAR(2);
CREATE DOMAIN "DOMAIN_C20" AS VARCHAR(20);
CREATE DOMAIN "DOMAIN_C4" AS VARCHAR(4);
CREATE DOMAIN "DOMAIN_C6" AS VARCHAR(6);
CREATE DOMAIN "DOMAIN_C7" AS VARCHAR(7);
CREATE DOMAIN "DOMAIN_C8" AS VARCHAR(8);
CREATE DOMAIN "DOMAIN_CURRENCY" AS FLOAT
DEFAULT 0;
CREATE DOMAIN "DOMAIN_DATETIME" AS TIMESTAMP;
CREATE DOMAIN "DOMAIN_DM" AS VARCHAR(10);
CREATE DOMAIN "DOMAIN_FS" AS VARCHAR(10);
CREATE DOMAIN "DOMAIN_LOGIC" AS CHAR(1)
DEFAULT 'F';
CREATE DOMAIN "DOMAIN_LXM" AS VARCHAR(30);
CREATE DOMAIN "DOMAIN_MC" AS VARCHAR(10);
CREATE DOMAIN "DOMAIN_MEMO" AS BLOB SUB_TYPE 0 SEGMENT SIZE 80;
CREATE DOMAIN "DOMAIN_SJ" AS CHAR(4);
CREATE DOMAIN "DOMAIN_SL" AS INTEGER
DEFAULT 0;
CREATE DOMAIN "DOMAIN_SLF" AS FLOAT
DEFAULT 0;
CREATE DOMAIN "DOMAIN_USEBH" AS VARCHAR(12);
CREATE DOMAIN "DOMAIN_XM" AS VARCHAR(8);
CREATE DOMAIN "DOMAIN_ZT" AS CHAR(1);

/* Table: BASICFMT, Owner: SYSDBA */

CREATE TABLE "BASICFMT"
(
"CLASS" "DOMAIN_BH",
"SDATE" "DOMAIN_C8",
"STIME" "DOMAIN_BH",
"LAST" "DOMAIN_SLF",
"NUMBER" "DOMAIN_C16"
);

/* Table: BH, Owner: SYSDBA */

CREATE TABLE "BH"
(
"D_YDBH" "DOMAIN_USEBH",
"D_YJBH" "DOMAIN_USEBH",
"D_KRBH" "DOMAIN_USEBH",
"D_ZDBH" "DOMAIN_USEBH",
"D_JZBH" "DOMAIN_USEBH",
"D_DCBH" "DOMAIN_USEBH"
);

/* Index definitions for all user tables */
CREATE INDEX "KFZT" ON "KFZT"("D_LCBH", "D_KFBH");
CREATE INDEX "YSKJZLSXFRQXMBH" ON "YSKJZLS"("D_XFRQ", "D_XMBH");
/* Grant Roles for this database */
/* Grant permissions for this database */

运行时提示“DOMAIN 附近有语法错误”怎么回事呢？

...全文