sdl012.out

derby database source code.good for you.

ij> AUTOCOMMIT OFF;
ij> -- MODULE SDL012
-- SQL Test Suite, V6.0, Interactive SQL, sdl012.sql
-- 59-byte ID
-- TEd Version #
-- AUTHORIZATION HU
   set schema HU;
0 rows inserted/updated/deleted
ij> --O   SELECT USER FROM HU.ECCO;
  VALUES USER;
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
HU                                                                                                                              
ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
-- date_time print
-- TEST:0148 CREATE Table with NOT NULL!
     INSERT INTO STAFF1(EMPNAME,GRADE,CITY)
            VALUES('Carmen',40,'Boston');
ERROR 23502: Column 'EMPNUM'  cannot accept a NULL value.
ij> -- PASS:0148 If ERROR, NOT NULL constraint, 0 rows inserted?
-- NOTE:0148 Not Null Column EMPNUM is missing.
--O      SELECT COUNT(*)
      SELECT *
           FROM STAFF1;
EM&|EMPNAME             |GRADE|CITY           
----------------------------------------------
ij> -- PASS:0148 If count = 0?
-- restore
     ROLLBACK WORK;
ij> -- END TEST >>> 0148 <<< END TEST
-- *************************************************////END-OF-MODULE
;
ij>