Insert Example - SQL Insert.

Community Help: DB2 Insert - Code example of a DB2 Insert

Share your own experience     View front page

The following is a DB2 insert example. This is an example of how to insert into a table named "YOURTABLE", where it has 3 columns defined as an 11 byte Char field, an integer field, and a decimal field

Although this sample is a mainframe DB2 SQL example, it really doesn't matter where you are running as this is pretty much the same everywhere.

INSERT INTO YOURTABLE
VALUES ('TEST STRING', 1, 5.25);