ij> AUTOCOMMIT OFF; ij> -- MODULE DML076 -- SQL Test Suite, V6.0, Interactive SQL, dml076.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 -- NO_TEST:0435 Host variables in UPDATE WHERE CURRENT! -- Testing cursors -- ************************************************************* -- TEST:0436 NULL values for various SQL data types! INSERT INTO BB VALUES(NULL); 1 row inserted/updated/deleted ij> INSERT INTO EE VALUES(NULL); 1 row inserted/updated/deleted ij> INSERT INTO GG VALUES(NULL); 1 row inserted/updated/deleted ij> INSERT INTO HH VALUES(NULL); 1 row inserted/updated/deleted ij> INSERT INTO II VALUES(NULL); 1 row inserted/updated/deleted ij> INSERT INTO JJ VALUES(NULL); 1 row inserted/updated/deleted ij> INSERT INTO MM VALUES(NULL); 1 row inserted/updated/deleted ij> INSERT INTO SS VALUES(NULL); 1 row inserted/updated/deleted ij> SELECT CHARTEST FROM BB; CHA& ---- NULL ij> -- PASS:0436 If CHARTEST is NULL (Implementor defined print format)? SELECT INTTEST FROM EE; INTTEST ----------- NULL ij> -- PASS:0436 If INTTEST is NULL (Implementor defined print format)? SELECT REALTEST FROM GG; REALTEST ------------- NULL ij> -- PASS:0436 If REALTEST is NULL (Implementor defined print format)? --O SELECT COUNT(*) SELECT * FROM GG WHERE REALTEST IS NULL; REALTEST ------------- NULL ij> -- PASS:0436 If count = 1? SELECT SMALLTEST FROM HH; SMALL& ------ NULL ij> -- PASS:0436 If SMALLTEST is NULL (Implementor defined print format)? SELECT DOUBLETEST FROM II; DOUBLETEST ---------------------- NULL ij> -- PASS:0436 If DOUBLETEST is NULL (Implementor defined print format)? --O SELECT COUNT(*) SELECT * FROM II WHERE DOUBLETEST IS NULL; DOUBLETEST ---------------------- NULL ij> -- PASS:0436 If count = 1? SELECT FLOATTEST FROM JJ; FLOATTEST ---------------------- NULL ij> -- PASS:0436 If FLOATTEST is NULL (Implementor defined print format)? --O SELECT COUNT(*) SELECT * FROM JJ WHERE FLOATTEST IS NULL; FLOATTEST ---------------------- NULL ij> -- PASS:0436 If count = 1? SELECT NUMTEST FROM MM; NUMTE& ------ NULL ij> -- PASS:0436 If NUMTEST is NULL (Implementor defined print format)? SELECT NUMTEST FROM SS; NUMTEST --------------- NULL ij> -- PASS:0436 If NUMTEST is NULL (Implementor defined print format)? -- restore ROLLBACK WORK; ij> -- END TEST >>> 0436 <<< END TEST -- ************************************************************* -- NO_TEST:0437 NULL values for various host variable types! -- Testing Host Variables & Indicator Variables -- ************************************************************* -- NO_TEST:0410 NULL value in OPEN CURSOR! -- Testing Cursors & Indicator Variables -- ************************************************************* -- NO_TEST:0441 NULL value for various predicates! -- Testing Indicator Variables -- *************************************************////END-OF-MODULE ; ij>