ij> AUTOCOMMIT OFF; ij> -- MODULE YTS799 -- SQL Test Suite, V6.0, Interactive SQL, yts799.sql -- 59-byte ID -- TEd Version # -- AUTHORIZATION CTS1 set schema CTS1; 0 rows inserted/updated/deleted ij> --O SELECT USER FROM HU.ECCO; VALUES USER; 1 -------------------------------------------------------------------------------------------------------------------------------- CTS1 ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment ROLLBACK WORK; ij> -- date_time print -- TEST:7531 as in ! SELECT TTA, TTB, TTC FROM CTS1.TT WHERE (SELECT TUD FROM TU WHERE TU.TUE = TT.TTA) IS NULL ORDER BY TTA DESC; TTA |TTB |TTC ----------------------------------- 5 |42 |26 2 |98 |NULL 1 |NULL |99 ij> -- PASS:7531 If 3 rows are selected in the following order? -- col1 col2 col3 -- ==== ==== ==== -- PASS:7531 If 5 42 26 ? -- PASS:7531 If 2 98 NULL? -- PASS:7531 If 1 NULL 99 ? SELECT TTA, TTB, TTC FROM CTS1.TT WHERE (SELECT TUD FROM TU WHERE TU.TUE = TT.TTA) IS NOT NULL ORDER BY TTA; TTA |TTB |TTC ----------------------------------- 3 |97 |96 4 |NULL |NULL ij> -- PASS:7531 If 2 rows are selected in the following order? -- col1 col1 col3 -- ==== ==== ==== -- PASS:7531 If 3 97 96 ? -- PASS:7531 If 4 NULL NULL? --O SELECT COUNT (*) FROM CTS1.TT SELECT * FROM CTS1.TT WHERE TTB IS NULL OR TTC IS NULL; TTA |TTB |TTC ----------------------------------- 1 |NULL |99 2 |98 |NULL 4 |NULL |NULL ij> -- PASS:7531 If COUNT = 3? --O SELECT COUNT (*) FROM CTS1.TT SELECT * FROM CTS1.TT WHERE TTB IS NOT NULL AND TTC IS NOT NULL; TTA |TTB |TTC ----------------------------------- 3 |97 |96 5 |42 |26 ij> -- PASS:7531 If COUNT = 2? --O SELECT COUNT (*) FROM CTS1.TT SELECT * FROM CTS1.TT WHERE NOT (TTB IS NULL AND TTC IS NULL); TTA |TTB |TTC ----------------------------------- 1 |NULL |99 2 |98 |NULL 3 |97 |96 5 |42 |26 ij> -- PASS:7531 If COUNT = 4? ROLLBACK WORK; ij> -- END TEST >>> 7531 <<< END TEST -- ********************************************* -- *************************************************////END-OF-MODULE ; ij>