Skip to content

DB setup initialization for viral patel example

hri123 edited this page May 6, 2014 · 2 revisions

a. Derby

ij> connect 'jdbc:derby:<path to DBs directory>\DBs\sample;create=true';

ij> CREATE TABLE CONTACTS (
id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
firstname VARCHAR(30),
lastname VARCHAR(30),
telephone VARCHAR(15),
email VARCHAR(30),
created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

ij> insert into "CONTACTS" (FIRSTNAME, LASTNAME, TELEPHONE, EMAIL) values ('AAA', 'BBB', '123456', 'aaa@aaa.com');

b. DB2

drop table db2admin.contacts;

CREATE TABLE "DB2ADMIN"."CONTACTS"
(
id INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1),
firstname VARCHAR(30),
lastname VARCHAR(30),
telephone VARCHAR(15),
email VARCHAR(30),
created TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
);

insert into "DB2ADMIN"."CONTACTS" (FIRSTNAME, LASTNAME, TELEPHONE, EMAIL) values ('AAA', 'BBB', 123456, 'aaa@aaa.com')

Clone this wiki locally