ij> -- LTRIM(string, trimSet)/RTRIM(string, trimSet) is not supported anymore. Mastering the -- output with errors for now. We may implement our own LTRIM_TRIMSET()/RTRIM_TRIMSET() -- functions for testing only in the future and replace usages of LTRIM/RTRIM here. AUTOCOMMIT OFF; ij> -- MODULE DML112 -- SQL Test Suite, V6.0, Interactive SQL, dml112.sql -- 59-byte ID -- TEd Version # -- AUTHORIZATION FLATER set schema FLATER; 0 rows inserted/updated/deleted ij> --O SELECT USER FROM HU.ECCO; VALUES USER; 1 -------------------------------------------------------------------------------------------------------------------------------- FLATER ij> -- RERUN if USER value does not match preceding AUTHORIZATION comment ROLLBACK WORK; ij> -- date_time print -- TEST:0621 DATETIME NULLs! CREATE TABLE MERCH ( ITEMKEY INT, ORDERED DATE, RDATE DATE, RTIME TIME, SOLD TIMESTAMP); 0 rows inserted/updated/deleted ij> -- PASS:0621 If table is created? COMMIT WORK; ij> --O CREATE TABLE TURNAROUND ( --O ITEMKEY INT, --O MWAIT INTERVAL MONTH, --O DWAIT INTERVAL DAY TO HOUR); -- PASS:0621 If table is created? --O COMMIT WORK; --O CREATE VIEW INVENTORY AS --O SELECT MERCH.ITEMKEY AS ITEMKEY, ORDERED, --O MWAIT, DWAIT FROM MERCH, TURNAROUND COR1 WHERE RDATE --O IS NOT NULL AND SOLD IS NULL AND --O MERCH.ITEMKEY = COR1.ITEMKEY --O UNION --O SELECT ITEMKEY, ORDERED, --O CAST (NULL AS INTERVAL MONTH), --O CAST (NULL AS INTERVAL DAY TO HOUR) FROM --O MERCH WHERE RDATE IS NOT NULL AND SOLD IS NULL --O AND MERCH.ITEMKEY NOT IN (SELECT ITEMKEY --O FROM TURNAROUND); -- PASS:0621 If view is created? --O COMMIT WORK; INSERT INTO MERCH VALUES (0, DATE( '1993-11-23'), NULL, NULL, NULL); 1 row inserted/updated/deleted ij> -- PASS:0621 If 1 row is inserted? INSERT INTO MERCH VALUES (1, DATE( '1993-12-10'), DATE( '1994-01-03'), CAST (NULL AS TIME), NULL); 1 row inserted/updated/deleted ij> -- PASS:0621 If 1 row is inserted? INSERT INTO MERCH VALUES (2, DATE( '1993-12-11'), NULL, --O NULL, CAST ('TIMESTAMP ''1993-12-11 13:00:00''' AS TIMESTAMP)); NULL, TIMESTAMP( '1993-12-11 13:00:00' )); 1 row inserted/updated/deleted ij> -- PASS:0621 If 1 row is inserted? INSERT INTO MERCH VALUES (4, DATE( '1993-01-26'), DATE( '1993-01-27'), NULL, NULL); 1 row inserted/updated/deleted ij> -- PASS:0621 If 1 row is inserted? --O INSERT INTO TURNAROUND VALUES (2, INTERVAL '1' MONTH, --O INTERVAL '20:0' DAY TO HOUR); -- PASS:0621 If 1 row is inserted? --O INSERT INTO TURNAROUND VALUES (5, INTERVAL '5' MONTH, --O CAST (NULL AS INTERVAL DAY TO HOUR)); -- PASS:0621 If 1 row is inserted? --O INSERT INTO TURNAROUND VALUES (6, INTERVAL '2' MONTH, NULL); -- PASS:0621 If 1 row is inserted? --O SELECT COUNT(*) FROM --O MERCH A, MERCH B WHERE A.SOLD = B.SOLD; -- PASS:0621 If count = 1? --O SELECT COUNT(*) FROM --O MERCH A, MERCH B WHERE A.RTIME = B.RTIME; -- PASS:0621 If count = 0? --O SELECT COUNT(*) FROM --O MERCH WHERE RDATE IS NULL; -- PASS:0621 If count = 2? --O SELECT COUNT(*) FROM --O TURNAROUND WHERE DWAIT IS NOT NULL; -- PASS:0621 If count = 1? --O SELECT DAY( RDATE) --O FROM MERCH, TURNAROUND WHERE MERCH.ITEMKEY = --O TURNAROUND.ITEMKEY; -- PASS:0621 If 1 row selected and value is NULL? SELECT ITEMKEY FROM MERCH WHERE SOLD IS NOT NULL; ITEMKEY ----------- 2 ij> -- PASS:0621 If 1 row selected and ITEMKEY is 2? --O SELECT HOUR( AVG (DWAIT)) --O FROM MERCH, TURNAROUND WHERE --O MERCH.ITEMKEY = TURNAROUND.ITEMKEY OR --O TURNAROUND.ITEMKEY NOT IN --O (SELECT ITEMKEY FROM MERCH); -- PASS:0621 If 1 row selected and value is 0? --O SELECT COUNT(*) --O FROM INVENTORY WHERE MWAIT IS NULL --O AND DWAIT IS NULL; -- PASS:0621 If count = 2? COMMIT WORK; ij> --O DROP TABLE MERCH CASCADE; DROP TABLE MERCH ; 0 rows inserted/updated/deleted ij> -- PASS:0621 If table is dropped? COMMIT WORK; ij> --O DROP TABLE TURNAROUND CASCADE; -- PASS:0621 If table is dropped? --O COMMIT WORK; -- END TEST >>> 0621 <<< END TEST -- ********************************************* -- TEST:0623 OUTER JOINs with NULLs and empty tables! CREATE TABLE JNULL1 (C1 INT, C2 INT); 0 rows inserted/updated/deleted ij> -- PASS:0623 If table is created? COMMIT WORK; ij> CREATE TABLE JNULL2 (D1 INT, D2 INT); 0 rows inserted/updated/deleted ij> -- PASS:0623 If table is created? COMMIT WORK; ij> CREATE VIEW JNULL3 AS SELECT C1, D1, D2 FROM JNULL1 LEFT OUTER JOIN JNULL2 ON C2 = D2; 0 rows inserted/updated/deleted ij> -- PASS:0623 If view is created? COMMIT WORK; ij> CREATE VIEW JNULL4 AS SELECT D1, D2 AS C2 FROM JNULL2; 0 rows inserted/updated/deleted ij> -- PASS:0623 If view is created? COMMIT WORK; ij> CREATE VIEW JNULL5 AS SELECT C1, D1, JNULL1.C2 FROM JNULL1 RIGHT OUTER JOIN JNULL4 ON (JNULL1.C2 = JNULL4.C2); 0 rows inserted/updated/deleted ij> -- PASS:0623 If view is created? COMMIT WORK; ij> CREATE VIEW JNULL6 (C1, C2, D1, D2) AS SELECT * FROM JNULL1 LEFT OUTER JOIN JNULL4 ON (JNULL1.C2 = JNULL4.C2); 0 rows inserted/updated/deleted ij> -- PASS:0623 If view is created? COMMIT WORK; ij> INSERT INTO JNULL1 VALUES (NULL, NULL); 1 row inserted/updated/deleted ij> -- PASS:0623 If 1 row is inserted? INSERT INTO JNULL1 VALUES (1, NULL); 1 row inserted/updated/deleted ij> -- PASS:0623 If 1 row is inserted? INSERT INTO JNULL1 VALUES (NULL, 1); 1 row inserted/updated/deleted ij> -- PASS:0623 If 1 row is inserted? INSERT INTO JNULL1 VALUES (1, 1); 1 row inserted/updated/deleted ij> -- PASS:0623 If 1 row is inserted? INSERT INTO JNULL1 VALUES (2, 2); 1 row inserted/updated/deleted ij> -- PASS:0623 If 1 row is inserted? SELECT COUNT(*) FROM JNULL3; 1 ----------- 5 ij> -- PASS:0623 If count = 5? SELECT COUNT(*) FROM JNULL3 WHERE D2 IS NOT NULL OR D1 IS NOT NULL; 1 ----------- 0 ij> -- PASS:0623 If count = 0? SELECT COUNT(*) FROM JNULL5; 1 ----------- 0 ij> ---- ON (C2); ---- SELECT D1, D2 AS C2 FROM JNULL2; -- PASS:0623 If count = 0? SELECT COUNT(*) FROM JNULL6 WHERE C2 IS NOT NULL; 1 ----------- 3 ij> -- PASS:0623 If count = 3? INSERT INTO JNULL2 SELECT * FROM JNULL1; 5 rows inserted/updated/deleted ij> -- PASS:0623 If 5 rows are inserted? UPDATE JNULL2 SET D2 = 1 WHERE D2 = 2; 1 row inserted/updated/deleted ij> -- PASS:0623 If 1 row is updated? SELECT COUNT(*) FROM JNULL3; 1 ----------- 9 ij> -- PASS:0623 If count = 9? SELECT COUNT(*) FROM JNULL3 WHERE C1 IS NULL; 1 ----------- 4 ij> -- PASS:0623 If count = 4? SELECT COUNT(*) FROM JNULL3 WHERE D1 IS NULL; 1 ----------- 5 ij> -- PASS:0623 If count = 5? SELECT COUNT(*) FROM JNULL3 WHERE D2 IS NULL; 1 ----------- 3 ij> -- PASS:0623 If count = 3? SELECT AVG(D1) * 10 FROM JNULL3; 1 ----------- 10 WARNING 01003: Null values were eliminated from the argument of a column function. ij> -- PASS:0623 If value is 15 (approximately)? SELECT COUNT(*) FROM JNULL6 WHERE C2 = 1; 1 ----------- 6 ij> -- PASS:0623 If count = 6? SELECT COUNT(*) FROM JNULL6 WHERE C2 IS NULL; 1 ----------- 2 ij> -- PASS:0623 If count = 2? SELECT COUNT(*) FROM JNULL6 WHERE C2 = C1 AND D1 IS NULL; 1 ----------- 2 ij> -- PASS:0623 If count = 2? COMMIT WORK; ij> --O DROP TABLE JNULL1 CASCADE; DROP VIEW JNULL3 ; 0 rows inserted/updated/deleted ij> DROP VIEW JNULL5 ; 0 rows inserted/updated/deleted ij> DROP VIEW JNULL6 ; 0 rows inserted/updated/deleted ij> DROP VIEW JNULL4 ; 0 rows inserted/updated/deleted ij> DROP TABLE JNULL1 ; 0 rows inserted/updated/deleted ij> -- PASS:0623 If table is dropped? COMMIT WORK; ij> --O DROP TABLE JNULL2 CASCADE; DROP TABLE JNULL2 ; 0 rows inserted/updated/deleted ij> -- PASS:0623 If table is dropped? COMMIT WORK; ij> -- END TEST >>> 0623 <<< END TEST -- ********************************************* -- TEST:0625 ADD COLUMN and DROP COLUMN! CREATE TABLE CHANGG (NAAM CHAR (14) NOT NULL PRIMARY KEY, AGE INT); 0 rows inserted/updated/deleted ij> -- PASS:0625 If table is created? COMMIT WORK; ij> CREATE VIEW CHANGGVIEW AS SELECT * FROM CHANGG; 0 rows inserted/updated/deleted ij> -- PASS:0625 If view is created? COMMIT WORK; ij> --O ALTER TABLE CHANGG --O DROP NAAM RESTRICT; -- PASS:0625 If ERROR, view references NAAM? --O COMMIT WORK; INSERT INTO CHANGG VALUES ('RALPH', 22); 1 row inserted/updated/deleted ij> -- PASS:0625 If 1 row is inserted? INSERT INTO CHANGG VALUES ('RUDOLPH', 54); 1 row inserted/updated/deleted ij> -- PASS:0625 If 1 row is inserted? INSERT INTO CHANGG VALUES ('QUEEG', 33); 1 row inserted/updated/deleted ij> -- PASS:0625 If 1 row is inserted? INSERT INTO CHANGG VALUES ('BESSIE', 106); 1 row inserted/updated/deleted ij> -- PASS:0625 If 1 row is inserted? SELECT COUNT(*) FROM CHANGG WHERE DIVORCES IS NULL; ERROR 42X04: Column 'DIVORCES' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'DIVORCES' is not a column in the target table. ij> -- PASS:0625 If ERROR, column does not exist? COMMIT WORK; ij> ALTER TABLE CHANGG ADD NUMBRR CHAR(11); 0 rows inserted/updated/deleted ij> -- PASS:0625 If column is added? COMMIT WORK; ij> SELECT MAX(AGE) FROM CHANGGVIEW; 1 ----------- 106 ij> -- PASS:0625 If value is 106? SELECT MAX(NUMBRR) FROM CHANGGVIEW; ERROR 42X04: Column 'NUMBRR' is either not in any table in the FROM list or appears within a join specification and is outside the scope of the join specification or appears in a HAVING clause and is not in the GROUP BY list. If this is a CREATE or ALTER TABLE statement then 'NUMBRR' is not a column in the target table. ij> -- PASS:0625 If ERROR, column does not exist ? COMMIT WORK; ij> --O DROP VIEW CHANGGVIEW CASCADE; DROP VIEW CHANGGVIEW ; 0 rows inserted/updated/deleted ij> -- PASS:0625 If view is dropped? COMMIT WORK; ij> --O ALTER TABLE CHANGG --O ADD COLUMN DIVORCES INT DEFAULT 0; -- PASS:0625 If column is added? --O COMMIT WORK; --O SELECT COUNT(*) --O FROM CHANGG WHERE NUMBRR IS NOT NULL --O OR DIVORCES <> 0; -- PASS:0625 If count = 0? --O UPDATE CHANGG --O SET NUMBRR = '837-47-1847', DIVORCES = 3 --O WHERE NAAM = 'RUDOLPH'; -- PASS:0625 If 1 row is updated? --O UPDATE CHANGG --O SET NUMBRR = '738-47-1847', DIVORCES = NULL --O WHERE NAAM = 'QUEEG'; -- PASS:0625 If 1 row is updated? DELETE FROM CHANGG WHERE NUMBRR IS NULL; 4 rows inserted/updated/deleted ij> -- PASS:0625 If 2 rows are deleted? --O INSERT INTO CHANGG (NAAM, AGE, NUMBRR) --O VALUES ('GOOBER', 16, '000-10-0001'); -- PASS:0625 If 1 row is inserted? --O INSERT INTO CHANGG --O VALUES ('OLIVIA', 20, '111-11-1111', 0); -- PASS:0625 If 1 row is inserted? --O SELECT AGE, NUMBRR, DIVORCES --O FROM CHANGG --O WHERE NAAM = 'RUDOLPH'; -- PASS:0625 If 1 row selected with values 54, 837-47-1847, 3 ? --O SELECT AGE, NUMBRR, DIVORCES --O FROM CHANGG --O WHERE NAAM = 'QUEEG'; -- PASS:0625 If 1 row selected with values 33, 738-47-1847, NULL ? --O SELECT AGE, NUMBRR, DIVORCES --O FROM CHANGG --O WHERE NAAM = 'GOOBER'; -- PASS:0625 If 1 row selected with values 16, 000-10-0001, 0 ? --O SELECT AGE, NUMBRR, DIVORCES --O FROM CHANGG --O WHERE NAAM = 'OLIVIA'; -- PASS:0625 If 1 row selected with values 20, 111-11-1111, 0 ? SELECT COUNT(*) FROM CHANGG; 1 ----------- 0 ij> -- PASS:0625 If count = 4? COMMIT WORK; ij> --O ALTER TABLE CHANGG DROP AGE CASCADE; -- PASS:0625 If column is dropped? --O COMMIT WORK; --O ALTER TABLE CHANGG DROP COLUMN DIVORCES RESTRICT; -- PASS:0625 If column is dropped? --O COMMIT WORK; --O SELECT COUNT(*) --O FROM CHANGG WHERE AGE > 30; -- PASS:0625 If ERROR, column does not exist? --O SELECT COUNT(*) --O FROM CHANGG WHERE DIVORCES IS NULL; -- PASS:0625 If ERROR, column does not exist? --O SELECT NAAM --O FROM CHANGG --O WHERE NUMBRR LIKE '%000%'; -- PASS:0625 If 1 row selected with value GOOBER ? --O COMMIT WORK; --O CREATE TABLE REFERENCE_CHANGG ( --O NAAM CHAR (14) NOT NULL PRIMARY KEY --O REFERENCES CHANGG); -- PASS:0625 If table is created? --O COMMIT WORK; --O INSERT INTO REFERENCE_CHANGG VALUES ('NO SUCH NAAM'); -- PASS:0625 If RI ERROR, parent missing, 0 rows inserted? --O COMMIT WORK; --O ALTER TABLE CHANGG DROP NAAM RESTRICT; -- PASS:0625 If ERROR, referential constraint exists? --O COMMIT WORK; --O ALTER TABLE CHANGG DROP NAAM CASCADE; -- PASS:0625 If column is dropped? --O COMMIT WORK; --O INSERT INTO REFERENCE_CHANGG VALUES ('NO SUCH NAAM'); -- PASS:0625 If 1 row is inserted? --O COMMIT WORK; --O ALTER TABLE CHANGG DROP NUMBRR RESTRICT; -- PASS:0625 If ERROR, last column may not be dropped? --O COMMIT WORK; --O DROP TABLE CHANGG CASCADE; DROP TABLE CHANGG ; 0 rows inserted/updated/deleted ij> -- PASS:0625 If table is dropped? COMMIT WORK; ij> --O DROP TABLE REFERENCE_CHANGG CASCADE; -- PASS:0625 If table is dropped? --O COMMIT WORK; -- END TEST >>> 0625 <<< END TEST -- ********************************************* -- TEST:0631 Datetimes in a ! --O CREATE TABLE OBITUARIES ( --O NAAM CHAR (14) NOT NULL PRIMARY KEY, --O BORN DATE DEFAULT DATE( '1880-01-01'), --O DIED DATE DEFAULT CURRENT_DATE, --O ENTERED TIMESTAMP DEFAULT CURRENT_TIMESTAMP, --O TESTING1 DATE, --O TESTING2 TIMESTAMP); -- PASS:0631 If table is created? --O COMMIT WORK; --O CREATE TABLE BIRTHS ( --O NAAM CHAR (14) NOT NULL PRIMARY KEY, --O CHECKIN TIME (0) --O DEFAULT TIME( '00:00:00'), --O LABOR INTERVAL HOUR --O DEFAULT INTERVAL '4' HOUR, --O CHECKOUT TIME --O DEFAULT CURRENT_TIME, --O TESTING TIME); -- PASS:0631 If table is created? --O COMMIT WORK; --O INSERT INTO OBITUARIES (NAAM, TESTING1, TESTING2) --O VALUES ('KEITH', CURRENT_DATE, CURRENT_TIMESTAMP); -- PASS:0631 If 1 row is inserted? --O INSERT INTO BIRTHS (NAAM, TESTING) --O VALUES ('BJORN', CURRENT_TIME); -- PASS:0631 If 1 row is inserted? --O SELECT HOUR( CHECKIN) + --O MINUTE( CHECKIN) + --O SECOND( CHECKIN) --O FROM BIRTHS; -- PASS:0631 If 1 row selected with value 0? --O SELECT HOUR( LABOR) FROM BIRTHS; -- PASS:0631 If 1 row selected with value 4? --O SELECT COUNT (*) FROM BIRTHS --O WHERE TESTING <> CHECKOUT OR CHECKOUT IS NULL; -- PASS:0631 If count = 0? --O SELECT COUNT (*) FROM OBITUARIES --O WHERE BORN <> DATE( '1880-01-01') --O OR BORN IS NULL --O OR DIED <> TESTING1 --O OR DIED IS NULL --O OR ENTERED <> TESTING2 --O OR ENTERED IS NULL; -- PASS:0631 If count = 0? --O COMMIT WORK; --O DROP TABLE BIRTHS CASCADE; -- PASS:0631 If table is dropped? --O COMMIT WORK; --O DROP TABLE OBITUARIES CASCADE; -- PASS:0631 If table is dropped? --O COMMIT WORK; -- END TEST >>> 0631 <<< END TEST -- ********************************************* -- TEST:0633 TRIM function! CREATE TABLE WEIRDPAD ( NAAM CHAR (14), SPONSOR CHAR (14), PADCHAR CHAR (1)); 0 rows inserted/updated/deleted ij> -- PASS:0633 If table is created? COMMIT WORK; ij> INSERT INTO WEIRDPAD (NAAM, SPONSOR) VALUES ('KATEBBBBBBBBBB', '000000000KEITH'); 1 row inserted/updated/deleted ij> -- PASS:0633 If 1 row is inserted? INSERT INTO WEIRDPAD (NAAM, SPONSOR) VALUES (' KEITH ', 'XXXXKATEXXXXXX'); 1 row inserted/updated/deleted ij> -- PASS:0633 If 1 row is inserted? SELECT LTRIM (RTRIM (SPONSOR,'X'),'X') FROM WEIRDPAD WHERE LTRIM (RTRIM (NAAM)) = 'KEITH'; ERROR 42X01: Syntax error: Encountered "," at line 3, column 32. Issue the 'help' command for general information on IJ command syntax. Any unrecognized commands are treated as potential SQL commands and executed directly. Consult your DBMS server reference documentation for details of the SQL syntax supported by your server. ij> -- PASS:0633 If 1 row selected with value KATE ? SELECT LTRIM (SPONSOR, 'X') FROM WEIRDPAD WHERE RTRIM (NAAM) = ' KEITH'; ERROR 42X01: Syntax error: Encountered "," at line 3, column 25. Issue the 'help' command for general information on IJ command syntax. Any unrecognized commands are treated as potential SQL commands and executed directly. Consult your DBMS server reference documentation for details of the SQL syntax supported by your server. ij> -- PASS:0633 If 1 row selected with value KATEXXXXXX ? SELECT LTRIM (SPONSOR, 'X') FROM WEIRDPAD WHERE RTRIM (SPONSOR, 'X') = 'XXXXKATE'; ERROR 42X01: Syntax error: Encountered "," at line 3, column 25. Issue the 'help' command for general information on IJ command syntax. Any unrecognized commands are treated as potential SQL commands and executed directly. Consult your DBMS server reference documentation for details of the SQL syntax supported by your server. ij> -- PASS:0633 If 1 row selected with value KATEXXXXXX ? SELECT LTRIM (B.NAAM) FROM WEIRDPAD A, WEIRDPAD B WHERE RTRIM (LTRIM (A.NAAM, 'B'),'B') = RTRIM (LTRIM (B.SPONSOR, 'X'),'X'); ERROR 42X01: Syntax error: Encountered "," at line 4, column 43. Issue the 'help' command for general information on IJ command syntax. Any unrecognized commands are treated as potential SQL commands and executed directly. Consult your DBMS server reference documentation for details of the SQL syntax supported by your server. ij> -- PASS:0633 If 1 row selected with value KEITH ? SELECT COUNT(*) FROM WEIRDPAD A, WEIRDPAD B WHERE LTRIM (A.SPONSOR, '0') = RTRIM (LTRIM (B.NAAM, ' '), ' '); ERROR 42X01: Syntax error: Encountered "," at line 4, column 39. Issue the 'help' command for general information on IJ command syntax. Any unrecognized commands are treated as potential SQL commands and executed directly. Consult your DBMS server reference documentation for details of the SQL syntax supported by your server. ij> -- PASS:0633 If count = 1? SELECT RTRIM (NAAM, 'BB') FROM WEIRDPAD WHERE NAAM LIKE 'KATE%'; ERROR 42X01: Syntax error: Encountered "," at line 3, column 22. Issue the 'help' command for general information on IJ command syntax. Any unrecognized commands are treated as potential SQL commands and executed directly. Consult your DBMS server reference documentation for details of the SQL syntax supported by your server. ij> -- PASS:0633 If ERROR, length of trim character must be 1 ? INSERT INTO WEIRDPAD (NAAM, SPONSOR) SELECT DISTINCT LTRIM (HU.STAFF.CITY, 'D'), RTRIM (PTYPE, 'n') FROM HU.STAFF, HU.PROJ WHERE EMPNAME = 'Alice'; ERROR 42X01: Syntax error: Encountered "," at line 4, column 42. Issue the 'help' command for general information on IJ command syntax. Any unrecognized commands are treated as potential SQL commands and executed directly. Consult your DBMS server reference documentation for details of the SQL syntax supported by your server. ij> -- PASS:0633 If 3 rows are inserted? SELECT COUNT(*) FROM WEIRDPAD; 1 ----------- 2 ij> -- PASS:0633 If count = 5? UPDATE WEIRDPAD SET SPONSOR = LTRIM (RTRIM (SPONSOR, 'X'), 'X'), NAAM = RTRIM (NAAM, 'B'); ERROR 42X01: Syntax error: Encountered "," at line 4, column 41. Issue the 'help' command for general information on IJ command syntax. Any unrecognized commands are treated as potential SQL commands and executed directly. Consult your DBMS server reference documentation for details of the SQL syntax supported by your server. ij> -- PASS:0633 If 5 rows are updated? SELECT COUNT(*) FROM WEIRDPAD WHERE NAAM = 'KATE' OR SPONSOR = 'KATE'; 1 ----------- 0 ij> -- PASS:0633 If count = 2? DELETE FROM WEIRDPAD WHERE LTRIM('Kest', 'K') = LTRIM(SPONSOR, 'T'); ERROR 42X01: Syntax error: Encountered "," at line 4, column 18. Issue the 'help' command for general information on IJ command syntax. Any unrecognized commands are treated as potential SQL commands and executed directly. Consult your DBMS server reference documentation for details of the SQL syntax supported by your server. ij> -- PASS:0633 If 1 row is deleted? SELECT COUNT(*) FROM WEIRDPAD; 1 ----------- 2 ij> -- PASS:0633 If count = 4? UPDATE WEIRDPAD SET PADCHAR = '0' WHERE SPONSOR = '000000000KEITH' OR NAAM = 'eale'; 1 row inserted/updated/deleted ij> -- PASS:0633 If 3 rows are updated? UPDATE WEIRDPAD SET SPONSOR = NULL WHERE SPONSOR = 'Desig'; 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> -- PASS:0633 If 1 row is updated? SELECT COUNT(*) FROM WEIRDPAD WHERE RTRIM (SPONSOR, PADCHAR) IS NULL; ERROR 42X01: Syntax error: Encountered "," at line 4, column 26. Issue the 'help' command for general information on IJ command syntax. Any unrecognized commands are treated as potential SQL commands and executed directly. Consult your DBMS server reference documentation for details of the SQL syntax supported by your server. ij> -- PASS:0633 If count = 2? SELECT COUNT(*) FROM WEIRDPAD WHERE LTRIM (SPONSOR, PADCHAR) = 'KEITH'; ERROR 42X01: Syntax error: Encountered "," at line 4, column 26. Issue the 'help' command for general information on IJ command syntax. Any unrecognized commands are treated as potential SQL commands and executed directly. Consult your DBMS server reference documentation for details of the SQL syntax supported by your server. ij> -- PASS:0633 If count = 1? COMMIT WORK; ij> --0 DROP TABLE WEIRDPAD CASCADE; DROP TABLE WEIRDPAD; 0 rows inserted/updated/deleted ij> -- PASS:0633 If table is dropped? COMMIT WORK; ij> -- END TEST >>> 0633 <<< END TEST -- *************************************************////END-OF-MODULE ; ij>