INSERT Statement

The INSERT statement inserts new rows into a table. You can insert as many rows as needed.

LSQL INSERT INTO tablename [(columnlist)][[VALUES(list)] [querystatement]]

Parameters

columnlist: Column names that store the values that valuelist specified. If you do not specify columnlist values, the SQL server stores the values into the columns in the order in which they were defined on the CREATE TABLE statement for this table.
querystatement: Query statement that retrieves the values to be inserted into the table. This query can be any valid search criteria.
tablename: Name of the table into which you are inserting a row.
VALUES(list): Column values for the new row. A value can be a character string, a numeric string, or a host variable. Commas separate values in the list.

Notes:

You can use host variables for columnlist or tablename.
The order of the columns in columnlist must match the order of the values in list. You do not need to match the actual order of the columns in the table with columnlist. As long as the order of columnlist and list match each other, the values are inserted into the columns properly.

Examples

Suppose you want to insert a row into the APPLICATIONS table. This row has the value APPL29 in the APPL_ID column, TSOUSR29 in the USER_ID column, 2002‑03‑13 in the UPDATE column, and UP in the STATUS column. You could issue the following LSQL command:
```
LSQL INSERT INTO APPLICATIONS (APPL_ID,USER_ID,UPDATE,STATUS)
     VALUES ('APPL29','TSOUSR29', DATE '2002‑03‑13','UP')
```
Note: The DATE data type definition precedes the literal date value. See the description of the Select Statement for more details about the DATE, TIME, and TIMESTAMP data types. Also, that the column values match the order in which the columns appear in the table, so the column list could have been left out.
If you wanted to add a row with only the APPL_ID and STATUS columns, you could use the following statement:
```
LSQL INSERT INTO APPLICATIONS (APPL_ID, STATUS) VALUES   ('APPL29', 'UP')
```
Suppose that there is a table that is named NEWAPPS that has the identical column structure of the APPLICATIONS table. You could add a row to the APPLICATIONS table for each of the new applications that users have altered. TSOUSR1, TSOUSR2, and TSOUSR8. In this case, you could substitute the VALUES clause with a query statement, as follows:
```
INSERT INTO APPLICATIONS SELECT * FROM NEWAPPS WHERE USER_ID
  IN ('TSOUSR1', 'TSOUSR2', 'TSOUSR8')
```