INSERT - Short Form

Syntax

INSERT { dbtab | *dbtab }.

Effect

This statement is a short form of the following Open SQL statement for accessing a single database table dbtab:

INSERT dbtab FROM { dbtab | *dbtab }.

The explicit specification of a work area is missing in the short form. A table work area dbtab or *dbtab is implicitly used as the work area. The table work area must be declared using TABLES. If the name *dbtab is used instead of the name of the database table dbtab, dbtab is accessed, but the additional table work area is used.

Note

The short form is not allowed in classes. You must use an explicit work area instead.