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
56
57
58
59
|
AUTOCOMMIT OFF;
-- MODULE DML016
-- SQL Test Suite, V6.0, Interactive SQL, dml016.sql
-- 59-byte ID
-- TEd Version #
-- AUTHORIZATION SULLIVAN
create schema SULLIVAN;
set schema SULLIVAN;
--O SELECT USER FROM HU.ECCO;
VALUES USER;
-- RERUN if USER value does not match preceding AUTHORIZATION comment
-- date_time print
-- TEST:0064 SELECT USER!
SELECT USER, PNAME
FROM HU.PROJ;
-- PASS:0064 If 6 rows are selected and each USER = 'SULLIVAN' ?
-- END TEST >>> 0064 <<< END TEST
-- ***********************************************************
-- NO_TEST:0172 SELECT USER into short variable!
-- Tests Host Variable
-- **********************************************************
-- TEST:0065 SELECT CHAR literal and term with numeric literal!
SELECT 'USER',PNAME
FROM HU.PROJ;
-- PASS:0065 If 6 rows are selected and first column is value 'USER'?
SELECT PNUM,'BUDGET IN GRAMS IS ',BUDGET * 5
FROM HU.PROJ
WHERE PNUM = 'P1';
-- PASS:0065 If values are 'P1', 'BUDGET IN GRAMS IS ', 50000?
-- END TEST >>> 0065 <<< END TEST
-- ************************************************************
-- TEST:0066 SELECT numeric literal!
SELECT EMPNUM,10
FROM HU.STAFF
WHERE GRADE = 10;
-- PASS:0066 If 1 row with values 'E2' and 10?
SELECT EMPNUM, 10
FROM HU.STAFF;
-- PASS:0066 If 5 rows are selected with second value always = 10?
-- PASS:0066 and EMPNUMs are 'E1', 'E2', 'E3', 'E4', 'E5'?
-- END TEST >>> 0066 <<< END TEST
-- *************************************************////END-OF-MODULE
|
