ij> -- -- Licensed to the Apache Software Foundation (ASF) under one or more -- contributor license agreements. See the NOTICE file distributed with -- this work for additional information regarding copyright ownership. -- The ASF licenses this file to You under the Apache License, Version 2.0 -- (the "License"); you may not use this file except in compliance with -- the License. You may obtain a copy of the License at -- -- http://www.apache.org/licenses/LICENSE-2.0 -- -- Unless required by applicable law or agreed to in writing, software -- distributed under the License is distributed on an "AS IS" BASIS, -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. -- See the License for the specific language governing permissions and -- limitations under the License. -- AUTOCOMMIT OFF; ij> -- *************************************************************** -- ****** THIS FILE SHOULD BE RUN UNDER AUTHORIZATION ID HU ****** -- *************************************************************** -- MODULE BASETAB -- SQL Test Suite, V6.0, Interactive SQL, basetab.sql -- 59-byte ID -- TEd Version # -- AUTHORIZATION HU --0 SELECT USER FROM HU.ECCO; VALUES USER; 1 -------------------------------------------------------------------------------------------------------------------------------- HU ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment -- date_time print -- This routine initializes the contents of tables: -- STAFF, PROJ, WORKS, STAFF3, VTABLE, and UPUNIQ -- This routine may be run at any time to re-initialize tables. DELETE FROM HU.ECCO; 0 rows inserted/updated/deleted WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. ij> INSERT INTO HU.ECCO VALUES ('NL'); 1 row inserted/updated/deleted ij> DELETE FROM HU.STAFF; 0 rows inserted/updated/deleted WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. ij> DELETE FROM HU.PROJ; 0 rows inserted/updated/deleted WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. ij> DELETE FROM HU.WORKS; 0 rows inserted/updated/deleted WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. ij> INSERT INTO HU.STAFF VALUES ('E1','Alice',12,'Deale'); 1 row inserted/updated/deleted ij> INSERT INTO HU.STAFF VALUES ('E2','Betty',10,'Vienna'); 1 row inserted/updated/deleted ij> INSERT INTO HU.STAFF VALUES ('E3','Carmen',13,'Vienna'); 1 row inserted/updated/deleted ij> INSERT INTO HU.STAFF VALUES ('E4','Don',12,'Deale'); 1 row inserted/updated/deleted ij> INSERT INTO HU.STAFF VALUES ('E5','Ed',13,'Akron'); 1 row inserted/updated/deleted ij> INSERT INTO HU.PROJ VALUES ('P1','MXSS','Design',10000,'Deale'); 1 row inserted/updated/deleted ij> INSERT INTO HU.PROJ VALUES ('P2','CALM','Code',30000,'Vienna'); 1 row inserted/updated/deleted ij> INSERT INTO HU.PROJ VALUES ('P3','SDP','Test',30000,'Tampa'); 1 row inserted/updated/deleted ij> INSERT INTO HU.PROJ VALUES ('P4','SDP','Design',20000,'Deale'); 1 row inserted/updated/deleted ij> INSERT INTO HU.PROJ VALUES ('P5','IRM','Test',10000,'Vienna'); 1 row inserted/updated/deleted ij> INSERT INTO HU.PROJ VALUES ('P6','PAYR','Design',50000,'Deale'); 1 row inserted/updated/deleted ij> INSERT INTO HU.WORKS VALUES ('E1','P1',40); 1 row inserted/updated/deleted ij> INSERT INTO HU.WORKS VALUES ('E1','P2',20); 1 row inserted/updated/deleted ij> INSERT INTO HU.WORKS VALUES ('E1','P3',80); 1 row inserted/updated/deleted ij> INSERT INTO HU.WORKS VALUES ('E1','P4',20); 1 row inserted/updated/deleted ij> INSERT INTO HU.WORKS VALUES ('E1','P5',12); 1 row inserted/updated/deleted ij> INSERT INTO HU.WORKS VALUES ('E1','P6',12); 1 row inserted/updated/deleted ij> INSERT INTO HU.WORKS VALUES ('E2','P1',40); 1 row inserted/updated/deleted ij> INSERT INTO HU.WORKS VALUES ('E2','P2',80); 1 row inserted/updated/deleted ij> INSERT INTO HU.WORKS VALUES ('E3','P2',20); 1 row inserted/updated/deleted ij> INSERT INTO HU.WORKS VALUES ('E4','P2',20); 1 row inserted/updated/deleted ij> INSERT INTO HU.WORKS VALUES ('E4','P4',40); 1 row inserted/updated/deleted ij> INSERT INTO HU.WORKS VALUES ('E4','P5',80); 1 row inserted/updated/deleted ij> COMMIT WORK; ij> --O SELECT COUNT(*) FROM HU.PROJ; SELECT * FROM HU.PROJ; PN&|PNAME |PTYPE |BUDGET |CITY ---------------------------------------------------------- P1 |MXSS |Design|10000 |Deale P2 |CALM |Code |30000 |Vienna P3 |SDP |Test |30000 |Tampa P4 |SDP |Design|20000 |Deale P5 |IRM |Test |10000 |Vienna P6 |PAYR |Design|50000 |Deale ij> -- PASS:Setup if count = 6? --O SELECT COUNT(*) FROM HU.STAFF; SELECT * FROM HU.STAFF; EM&|EMPNAME |GRADE|CITY ---------------------------------------------- E1 |Alice |12 |Deale E2 |Betty |10 |Vienna E3 |Carmen |13 |Vienna E4 |Don |12 |Deale E5 |Ed |13 |Akron ij> -- PASS:Setup if count = 5? --O SELECT COUNT(*) FROM HU.WORKS; SELECT * FROM HU.WORKS; EM&|PN&|HOURS -------------- E1 |P1 |40 E1 |P2 |20 E1 |P3 |80 E1 |P4 |20 E1 |P5 |12 E1 |P6 |12 E2 |P1 |40 E2 |P2 |80 E3 |P2 |20 E4 |P2 |20 E4 |P4 |40 E4 |P5 |80 ij> -- PASS:Setup if count = 12? DELETE FROM HU.STAFF3; 0 rows inserted/updated/deleted WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. ij> DELETE FROM HU.VTABLE; 0 rows inserted/updated/deleted WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. ij> DELETE FROM HU.UPUNIQ; 0 rows inserted/updated/deleted WARNING 02000: No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. ij> INSERT INTO HU.STAFF3 SELECT * FROM HU.STAFF; 5 rows inserted/updated/deleted ij> INSERT INTO HU.VTABLE VALUES(10,+20,30,40,10.50); 1 row inserted/updated/deleted ij> INSERT INTO HU.VTABLE VALUES(0,1,2,3,4.25); 1 row inserted/updated/deleted ij> INSERT INTO HU.VTABLE VALUES(100,200,300,400,500.01); 1 row inserted/updated/deleted ij> INSERT INTO HU.VTABLE VALUES(1000,-2000,3000,NULL,4000.00); 1 row inserted/updated/deleted ij> INSERT INTO HU.UPUNIQ VALUES(1,'A'); 1 row inserted/updated/deleted ij> INSERT INTO HU.UPUNIQ VALUES(2,'B'); 1 row inserted/updated/deleted ij> INSERT INTO HU.UPUNIQ VALUES(3,'C'); 1 row inserted/updated/deleted ij> INSERT INTO HU.UPUNIQ VALUES(4,'D'); 1 row inserted/updated/deleted ij> INSERT INTO HU.UPUNIQ VALUES(6,'F'); 1 row inserted/updated/deleted ij> INSERT INTO HU.UPUNIQ VALUES(8,'H'); 1 row inserted/updated/deleted ij> COMMIT WORK; ij> --O SELECT COUNT(*) FROM HU.STAFF3; SELECT * FROM HU.STAFF3; EM&|EMPNAME |GRADE|CITY ---------------------------------------------- E1 |Alice |12 |Deale E2 |Betty |10 |Vienna E3 |Carmen |13 |Vienna E4 |Don |12 |Deale E5 |Ed |13 |Akron ij> -- PASS:Setup if count = 5? --O SELECT COUNT(*) FROM HU.VTABLE; -- PASS:Setup if count = 4? --O SELECT COUNT(*) FROM HU.UPUNIQ; SELECT * FROM HU.UPUNIQ; NUM&|COL2 --------- 1 |A 2 |B 3 |C 4 |D 6 |F 8 |H ij> -- PASS:Setup if count = 6? -- *************************************************////END-OF-MODULE disconnect; ij>