IBM Tivoli Netcool/OMNIbus, Version 7.4

Inserting a new row of data into a table (INSERT command)

Use the INSERT command to insert a new row of data into an existing table.

Syntax

INSERT INTO [database_name.]table_name
 [ (column_name,...) ] VALUES (expression,...);

You must specify a value for every primary key column in the table.

If you are inserting values for every column in the row, specify the VALUES keyword followed by a comma-separated list of column values in parentheses. Enter the values in sequential column order.

If you are not inserting values for every column in the row, specify a comma-separated list of columns being inserted in parentheses, followed by the VALUES keyword, followed by a comma-separated list of column values in parentheses. Enter the values in the same sequence as the specified columns. All other columns are populated with default values.

Tip: You cannot assign values to system-maintained columns such as Serial.

Example

To insert an alert into the mydb.mystatus table specifying the values in the indicated columns, enter:

insert into mydb.mystatus (Identifier, Severity, LastOccurrence)
values ('MasterMachineStats15', 5, getdate);