CREATE TABLE qwert.Rabocije
(ID        CHAR ( 11 )    NOT NULL PRIMARY KEY, 
 Imia    VARCHAR ( 20 ) NOT NULL, 
 Familija   VARCHAR ( 20 ) NOT NULL, 
 DataRozdenija   DATE         NOT NULL, 
 Zarplata      FLOAT        NOT NULL, 
 Telefon CHAR ( 11 ), 
 Dolznost  VARCHAR ( 20 ) NOT NULL, 
 RabotaetOt  DATE         NOT NULL);
 
CREATE TABLE qwert.Klient (
 ID CHAR ( 11 ) NOT NULL PRIMARY KEY,
 Imia VARCHAR ( 20 ) NOT NULL,
 Familija VARCHAR ( 20 ) NOT NULL,
 Telefon CHAR ( 11 ),
 Ulica VARCHAR ( 10 ),
 Dom INT,
 Kvartira INT,
 Registrirval CHAR ( 11 ) NOT NULL,
 RegData DATE NOT NULL DEFAULT CURRENT DATE,
  FOREIGN KEY Rabocije(Registrirval) REFERENCES qwert.Rabocije
 ON DELETE SET NULL ON UPDATE RESTRICT);

[DB/ 2 ][qwert@linux5 dbvs]$ db2 -t -f CreateTables.sql
DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0104N  An unexpected token "CREATE TABLE QWERT.RABOCIJE  (ID     "
was found following "BEGIN-OF-STATEMENT".  Expected tokens may include:
"<space>".  SQLSTATE= 42601 

[DB/ 2 ][stkr6769@linux5 dbvs]$ db2 -t -f CreateTables2.sql
DB20000I  The SQL command completed successfully.

DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0629N  SET NULL cannot be specified because FOREIGN KEY "RABOCIJE"
cannot contain null values.  SQLSTATE= 42834 

DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0629N  SET NULL cannot be specified because FOREIGN KEY "DARBUOTOJUI"
cannot contain null values.  SQLSTATE= 42834 

DB21034E  The command was processed as an SQL statement because it was not a
valid Command Line Processor command.  During SQL processing it returned:
SQL0548N  A check constraint that is defined with "CURRENT" is invalid.
SQLSTATE= 42621