JDBC Example Table

DROP TABLE db2admin.comments;

CREATE TABLE db2admin.comments (

    id INT NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1),

    user VARCHAR(30) NOT NULL,

    email VARCHAR(30), 

    commentdate DATE NOT NULL, 

    comment VARCHAR(400) NOT NULL,

    PRIMARY KEY (id)

);

/*

INSERT INTO db2admin.comments (user,email, commentdate, comment) 

VALUES('Bob', 'bob@mail.com', '2019-02-19', 'Very comprehensive and well developed book!');

DELETE FROM db2admin.comments;

*/