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]]

Operand	Explanation
columnlist	The column names that store the values specified with valuelist. 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	A query statement that retrieves the values to be inserted into the table. This can be any valid search criteria.
tablename	The name of the table into which you are inserting a row.
VALUES(list)	The column values for the new row. A value can be a character string, a numeric string, or a host variable. Values in the list are separated by commas.

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 will have 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. To do this, 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')
```
Now, suppose there is a table called NEWAPPS that has the identical column structure of the APPLICATIONS table. You might want to add a row to the APPLICATIONS table for each of the new applications that has been altered by users 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')
```