# DB2

echo Populate Restricted

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 ('9999-12-31'))"

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

db2 "SELECT * FROM LOT"