DB2 Insert Example

   

  Asked by SQL - DB2 Insert Example:
The following show you a sample SQL DB2 insert. This shows example code assuming you were inserting into a DB2 table that was named "SAMPTAB", where it has 3 columns in the table each defined differently.  One is an integer column, one is a decimal column, and one is a 5 byte char column as shown.

Although this sample is showing a mainframe DB2 SQL sample, these are mostly the same everywhere so the platform doesnt really matter much.

INSERT INTO SAMPTAB
VALUES (5, 17.2, 'TEST1');


Add your reply below ...


Your Nickname:

Your Reply:

Type the code: