insert (language command)

Description

Using a language command, insert adds a new row to a table or view.

Syntax

insert [into] database.[owner.]{table_name|view_name}[(column_list)] 
 values (value1, [,value2]...) 

NoteAny valid object in the catalog can be substituted for table_name or view_name.

Parameters

into

is optional.

column_list

is a list of one or more columns to which data is to be added. The columns can be in any order, but the incoming data (whether in a values clause or a select clause) is in the same order.

values

is a keyword that introduces a list of expressions.

Examples

Example 1

insert titles (title_id, title, type, pub_id, notes, pubdate,contract)
 values (docid, docno, docdate)

Usage

Not defined.