drop table jstl_tab1 !
create table jstl_tab1(idNum INT NOT NULL, firstName VARCHAR(20) NOT NULL, lastName VARCHAR(20) NOT NULL, primary key(idNum)) !

drop table jstl_tab2 !
create table jstl_tab2(idNum INT NOT NULL, dob DATETIME NOT NULL, firstName VARCHAR(20) NOT NULL, lastName VARCHAR(20) NOT NULL, rank INT NOT NULL, rating NUMERIC(10,2) NULL) !

drop table jstl_tab3 !
create table jstl_tab3(idNum INTEGER NOT NULL, aDate DATETIME NULL, aTime TIME NULL, aTimestamp DATETIME NULL) !

 
INSERT INTO jstl_tab1 VALUES(1, 'Lance', 'Andersen') !
INSERT INTO jstl_tab1 VALUES(2, 'Ryan', 'Lubke') !
INSERT INTO jstl_tab1 VALUES(3, 'Sandra', 'Roberts') !
INSERT INTO jstl_tab1 VALUES(4, 'Hong', 'Zhang') !
INSERT INTO jstl_tab1 VALUES(5, 'Raja', 'Perumal') !
INSERT INTO jstl_tab1 VALUES(6, 'Shelly', 'McGowan') !
INSERT INTO jstl_tab1 VALUES(7, 'Ryan', 'O''Connell') !
INSERT INTO jstl_tab1 VALUES(8, 'Tonya', 'Andersen') !
INSERT INTO jstl_tab1 VALUES(9, 'Eric', 'Jendrock') !
INSERT INTO jstl_tab1 VALUES(10, 'Carla', 'Mott') !
INSERT INTO jstl_tab2(idNum, dob, firstName, lastName, rank, rating) VALUES (1, {d '1999-05-05'}, 'Lance', 'Andersen', 1, 4.25) !
INSERT INTO jstl_tab2(idNum, dob, firstName, lastName, rank, rating) VALUES (99, {d '1999-05-05'}, 'Courtney', 'Andersen', 1, NULL) !
INSERT INTO jstl_tab3(idNum, aDate, aTime, aTimestamp) VALUES(1, {d '2001-08-30'}, {t '20:20:20'}, {ts '2001-08-30 20:20:20'}) !
INSERT INTO jstl_tab3(idNum, aDate, aTime, aTimestamp) VALUES(2, NULL, NULL, NULL) !
