ObjectServer SQL commands

ObjectServer SQL provides data definition language (DDL) and data manipulation language (DML) commands for creating and modifying ObjectServer objects and data.

You can create new objects or modify existing objects by using SQL definition files or the SQL interactive interface.

You can modify ObjectServer data by using the SQL interactive interface or Netcool/OMNIbus Administrator (nco_config).

The available commands are grouped in the following sections:

Object and data commands
Automation commands
User, group, and role commands
Other commands

Object and data commands

The following table lists the DDL and DML commands available in ObjectServer SQL.

Table 1. ObjectServer SQL object commands
ObjectServer object	SQL commands
ObjectServer	ALTER SYSTEM
Database	CREATE DATABASE DROP DATABASE SET DATABASE and USE DATABASE
Table	ADD COLUMN ALTER COLUMN ALTER TABLE CREATE TABLE DELETE DESCRIBE DROP COLUMN DROP TABLE INSERT SELECT (scalar) SELECT (aggregate) SELECT (GROUP BY) SVC UPDATE
Index	CREATE INDEX DROP INDEX
View	CREATE VIEW DESCRIBE DROP VIEW SELECT (scalar) SELECT (aggregate) SELECT (GROUP BY) SVC
Restriction filter	CREATE RESTRICTION FILTER DROP RESTRICTION FILTER
File	ALTER FILE CREATE FILE DROP FILE WRITE INTO

Automation commands

The following table lists the automation commands available in ObjectServer SQL.

Table 2. ObjectServer SQL automation commands
Automation object	SQL commands
Trigger group	ALTER TRIGGER GROUP CREATE TRIGGER GROUP DROP TRIGGER GROUP
Database trigger	ALTER TRIGGER CREATE TRIGGER (database trigger) DROP TRIGGER
Temporal trigger	ALTER TRIGGER CREATE TRIGGER (temporal trigger) DROP TRIGGER
Signal trigger	ALTER TRIGGER CREATE TRIGGER (signal trigger) DROP TRIGGER
User-defined signal	CREATE SIGNAL DROP SIGNAL RAISE SIGNAL
System signal	System signals are not intended to be modified.
SQL procedure	CREATE PROCEDURE (SQL procedures) DROP PROCEDURE EXECUTE PROCEDURE
External procedure	CREATE PROCEDURE (external procedures) DROP PROCEDURE EXECUTE PROCEDURE

User, group, and role commands

The following table lists the user, group, and role commands available in ObjectServer SQL.

Table 3. User, role, and group SQL commands
Object	SQL command
User	ALTER USER CREATE USER DROP USER
Group	ALTER GROUP CREATE GROUP DROP GROUP
Role	ALTER ROLE CREATE ROLE DROP ROLE GRANT (Assigns permissions to a role) GRANT ROLE (Assigns roles to groups) REVOKE (Revokes role permissions) REVOKE ROLE (Revokes group roles)

Other commands

The following table lists the remaining commands available in ObjectServer SQL.

Table 4. Other SQL commands
Object	SQL commands
IDUC client	IDUC EVTFT (Activates accelerated event notification) IDUC FLUSH (Sends notifications to ObjectServer clients) IDUC SNDMSG (Sends messages to accelerated event notification (AEN) clients)
SQL clause	CASE WHEN FOR FOR EACH ROW IF THEN ELSE SET
SQL syntax	CHECK STATEMENT (Verifies SQL syntax)