Fehler 335544569

[erich.wanker]

Funktioniert bei einer mini-kleinen Datenbank ohne Probleme ..

Zitat:

SET SQL DIALECT 3;

/* CREATE DATABASE 'H:\source*******.fdb' PAGE_SIZE 4096

DEFAULT CHARACTER SET NONE */

/* External Function declarations */

DECLARE EXTERNAL FUNCTION RDB$GET_CONTEXT
VARCHAR(80) CHARACTER SET NONE, VARCHAR(80) CHARACTER SET NONE
RETURNS VARCHAR(255) CHARACTER SET NONE FREE_IT
ENTRY_POINT 'get_context' MODULE_NAME 'system_module';


DECLARE EXTERNAL FUNCTION RDB$SET_CONTEXT
VARCHAR(80) CHARACTER SET NONE, VARCHAR(80) CHARACTER SET NONE, VARCHAR(255) CHARACTER SET NONE
RETURNS INTEGER BY VALUE
ENTRY_POINT 'set_context' MODULE_NAME 'system_module';



/* Table: db_company, Owner: SYSDBA */

CREATE TABLE "db_company"
(
"inr" INTEGER NOT NULL,
"f_company_name" CHAR(200) CHARACTER SET ISO8859_1 COLLATE DE_DE,
CONSTRAINT "PK_db_company" PRIMARY KEY ("inr")
);

/* Table: db_jobs, Owner: SYSDBA */

CREATE TABLE "db_jobs"
(
"inr" INTEGER NOT NULL,
"f_job_name" CHAR(200) CHARACTER SET ISO8859_1 COLLATE DE_DE,
"f_job_link" CHAR(500) CHARACTER SET ISO8859_1 COLLATE DE_DE,
"f_job_parameter" CHAR(10) CHARACTER SET ISO8859_1 COLLATE DE_DE,
CONSTRAINT "PK_db_jobs" PRIMARY KEY ("inr")
);

/* Table: db_zyklus, Owner: SYSDBA */

CREATE TABLE "db_zyklus"
(
"inr" INTEGER NOT NULL,
"f_company" INTEGER,
"f_job" INTEGER,
"f_zyklus" INTEGER,
"f_script" CHAR(500) CHARACTER SET ISO8859_1 COLLATE DE_DE,
"f_mode" INTEGER,
CONSTRAINT "PK_db_zyklus" PRIMARY KEY ("inr")
);

CREATE GENERATOR "NUMMERNPOOL";

/* Grant Roles for this database */


/* Grant permissions for this database */