1. Connect to DB2 iSeries database.
2. Create a schema.
e.g.
3. Create a table
e.g.
CREATE TABLE "test_db"."d_type" (
"c1_binary" FOR "C1_BI00001" BINARY(1),
"c2_bigint" FOR "C2_BI00001" BIGINT,
"c3_character" FOR "C3_CH00001" CHARACTER(25),
"c4_date" FOR "C4_DA00001" DATE,
"c5_decimal" FOR "C5_DE00001" DECIMAL(15,5),
"c6_float" FOR "C6_FL00001" FLOAT(53),
"c7_integer" FOR "C7_IN00001" INTEGER,
"c8_numeric" FOR "C8_NU00001" NUMERIC(15,5),
"c9_timestamp" FOR "C9_TI00001" TIMESTAMP
)
GO
e.g.
INSERT INTO "test_db"."d_type"("c1_binary", "c2_bigint", "c3_character", "c4_date", "c5_decimal", "c6_float", "c7_integer", "c8_numeric", "c9_timestamp")
VALUES(cast('1' as binary), 1234, 'pune', '2013-10-18', 1.2, 2.2, 567, 6.7, '2013-10-18 11:54:26')
GO
INSERT INTO "test_db"."d_type"("c1_binary", "c2_bigint", "c3_character", "c4_date", "c5_decimal", "c6_float", "c7_integer", "c8_numeric", "c9_timestamp")
VALUES(cast('001' as binary), 644, 'mumbai', '2012-11-16', 0.2, 7.32, 757, 6.7, '2013-12-28 10:24:46')
GO
INSERT INTO "test_db"."d_type"("c1_binary", "c2_bigint", "c3_character", "c4_date", "c5_decimal", "c6_float", "c7_integer", "c8_numeric", "c9_timestamp")
VALUES(cast('02' as binary), 64, 'canada', '2011-04-18', 1.2, 2.2, 567, 6.7, '2011-02-14 21:54:26')
GO
5. Right click on created table->Click on Edit Table Data option.
