ij> AUTOCOMMIT OFF;
ij> -- MODULE  DML141  

-- SQL Test Suite, V6.0, Interactive SQL, dml141.sql
-- 59-byte ID
-- TEd Version #

-- AUTHORIZATION FLATER
   set schema FLATER;
0 rows inserted/updated/deleted
ij> --0   SELECT USER FROM HU.ECCO;
  VALUES USER;
1                                                                                                                               
--------------------------------------------------------------------------------------------------------------------------------
FLATER                                                                                                                          
ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment
   ROLLBACK WORK;
ij> -- date_time print

-- NOTE Direct support for SQLCODE or SQLSTATE is not required
-- NOTE    in Interactive Direct SQL, as defined in FIPS 127-2.
-- NOTE   ********************* instead ***************************
-- NOTE If a statement raises an exception condition,
-- NOTE    then the system shall display a message indicating that
-- NOTE    the statement failed, giving a textual description
-- NOTE    of the failure.
-- NOTE If a statement raises a completion condition that is a
-- NOTE    "warning" or "no data", then the system shall display
-- NOTE    a message indicating that the statement completed,
-- NOTE    giving a textual description of the "warning" or "no data."

-- TEST:0514 SQLSTATE 23502: integrity constraint violation!

-- NOT NULL constraint violated
   INSERT INTO HU.STAFF VALUES (NULL, NULL, NULL, NULL);
ERROR 23502: Column 'EMPNUM'  cannot accept a NULL value.
ij> -- PASS:0514 If ERROR, integrity constraint violation, 0 rows inserted?

-- UNIQUE constraint violated
   INSERT INTO HU.STAFF VALUES ('E1', 'Agnetha', 12, 'Paris');
ERROR 23505: The statement was aborted because it would have caused a duplicate key value in a unique or primary key constraint or unique index identified by 'STAFF_UNIQUE' defined on 'STAFF'.
ij> -- PASS:0514 If ERROR, integrity constraint violation, 0 rows inserted?

   ROLLBACK WORK;
ij> -- END TEST >>> 0514 <<< END TEST
-- *************************************************////END-OF-MODULE
;
ij>