# DB2

echo Populate General

db2 "DROP TABLE LOT"

db2 "CREATE TABLE LOT(LOT_ID_NUM INT, GNDR_CODE CHAR(1), FROM_DATE DATE, TO_DATE DATE)"

db2 "INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE) VALUES (101, 'c', DATE('1998-01-01'), DATE ('1998-03-23'))"

db2 "INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE) VALUES (101, 's', DATE('1998-03-23'), DATE ('9999-12-31'))"

db2 "INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE) VALUES (234, 'c', DATE('1998-02-17'), DATE ('1998-03-22'))"

db2 "INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE) VALUES (234, 'c', DATE('1998-03-22'), DATE ('1998-04-01'))"

db2 "INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE) VALUES (234, 'c', DATE('1998-04-01'), DATE ('1998-05-10'))"

db2 "INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE) VALUES (234, 'c', DATE('1998-05-10'), DATE ('1998-06-29'))"

db2 "INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE) VALUES (234, 'c', DATE('1998-06-29'), DATE ('1998-10-17'))"

db2 "INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE) VALUES (234, 'c', DATE('1998-10-17'), DATE ('1998-10-19'))"

db2 "INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE) VALUES (234, 'c', DATE('1998-10-19'), DATE ('9999-12-31'))"

db2 "INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE) VALUES (799, 'c', DATE('1998-02-27'), DATE ('1998-03-12'))"

db2 "INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE) VALUES (799, 'c', DATE('1998-03-12'), DATE ('1998-04-09'))"

db2 "INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE) VALUES (799, 'c', DATE('1998-04-09'), DATE ('1998-05-21'))"

db2 "INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE) VALUES (799, 'c', DATE('1998-05-21'), DATE ('1998-09-13'))"

db2 "INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE, FROM_DATE, TO_DATE) VALUES (799, 'c', DATE('1998-09-13'), DATE ('9999-12-31'))"

db2 "SELECT * FROM LOT"