1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
|
ij> -- MODULE DML050
-- SQL Test Suite, V6.0, Interactive SQL, dml050.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:0226 FIPS sizing - 10 tables in SQL statement!
-- FIPS sizing TEST
SELECT EMPNUM, EMPNAME
FROM STAFF
WHERE EMPNUM IN
(SELECT EMPNUM FROM WORKS
WHERE PNUM IN
(SELECT PNUM FROM PROJ
WHERE PTYPE IN
(SELECT PTYPE FROM PROJ
WHERE PNUM IN
(SELECT PNUM FROM WORKS
WHERE EMPNUM IN
(SELECT EMPNUM FROM WORKS
WHERE PNUM IN
(SELECT PNUM FROM PROJ
WHERE PTYPE IN
(SELECT PTYPE FROM PROJ
WHERE CITY IN
(SELECT CITY FROM STAFF
WHERE EMPNUM IN
(SELECT EMPNUM FROM WORKS
WHERE HOURS = 20
AND PNUM = 'P2' )))))))));
EM&|EMPNAME
------------------------
E1 |Alice
E2 |Betty
E3 |Carmen
E4 |Don
ij> -- PASS:0226 If 4 rows selected excluding EMPNUM='E5', EMPNAME='Ed'?
-- END TEST >>> 0226 <<< END TEST
-- *************************************************////END-OF-MODULE
;
ij>
|
