IBM Tivoli Netcool/OMNIbus, Version 7.4

Querying and manipulating data using ObjectServer SQL

You can use data manipulation language (DML) commands to query and modify data in existing tables, views, and files.

ObjectServer SQL provides the following commands for manipulating data.

Table 1. ObjectServer objects and associated DML commands
ObjectServer object	Allowed DML commands
TABLE	SELECT INSERT UPDATE DELETE DESCRIBE SVC
VIEW	SELECT DESCRIBE SVC
FILE	WRITE INTO

Tip: Restriction filters are automatically applied in SELECT, INSERT, UPDATE, and DELETE commands.