ObjectServer SQL command reference

Use this information as a reference for ObjectServer SQL commands.

The commands are listed alphabetically for ease of reference.

ADD COLUMN
To add columns to an existing table, use the ADD COLUMN setting with the ALTER TABLE command.
ALTER COLUMN
To alter columns in an existing table, use the ALTER COLUMN setting with the ALTER TABLE command.
ALTER FILE
Use the ALTER FILE command to change the configuration of an existing ObjectServer file.
ALTER GROUP
Use the ALTER GROUP command to change user settings for the specified group. You can change more than one setting in a single ALTER GROUP command.
ALTER ROLE
Use the ALTER ROLE command to modify the description of an existing role.
ALTER SYSTEM
Use the ALTER SYSTEM command to change the default and current settings of the ObjectServer. Run the command to set properties, shut down the ObjectServer, drop user connections, redirect clients to a different ObjectServer, or back up the ObjectServer.
ALTER TABLE
Use the ALTER TABLE command to change the characteristics of an existing table and its columns. You can add, drop, and alter columns, and manually set the value of fields of type INCR.
ALTER TRIGGER
Use the ALTER TRIGGER command to change the settings of an existing trigger. You can change more than one setting in a single ALTER TRIGGER command.
ALTER TRIGGER GROUP
Use the ALTER TRIGGER GROUP command to enable or disable an existing trigger group.
ALTER USER
Use the ALTER USER command to change the settings, such as the password, for the specified user. You can change more than one setting in a single ALTER USER command.
CANCEL
Use the CANCEL command within a database trigger to cancel the action of the database trigger (INSERT, UPDATE, DELETE).
CASE WHEN
When constructing the body of an SQL procedure, you can use the CASE WHEN statement to perform one or more actions based on a condition. If the condition is not met, you can optionally perform a different action.
CHECK STATEMENT
The CHECK STATEMENT command parses and checks the syntax of the SQL commands enclosed in quotation marks and returns either a success message or a description of any errors.
CREATE DATABASE
Use the CREATE DATABASE command to create a database.
CREATE FILE
Use the CREATE FILE command to create an ObjectServer file.
CREATE GROUP
Use the CREATE GROUP command to create a group of one or more users.
CREATE INDEX
Use the CREATE INDEX command to create an index on a database table.
CREATE PROCEDURE (external procedures)
Use the CREATE PROCEDURE command to create external procedures.
CREATE PROCEDURE (SQL procedures)
Use the CREATE PROCEDURE command to create SQL procedures.
CREATE RESTRICTION FILTER
Use the CREATE RESTRICTION FILTER command to create a restriction filter.
CREATE ROLE
Use the CREATE ROLE command to create a role, which is a collection of permissions.
CREATE SIGNAL
Use the CREATE SIGNAL command to create a user-defined signal. When you create a signal, you define a list of data-typed attributes.
CREATE TABLE
Use the CREATE TABLE command to create a table.
CREATE TRIGGER (database trigger)
Use the CREATE TRIGGER command to create database triggers that fire when a modification or attempted modification to an ObjectServer table occurs (or when a modification or attempted modification to a view affects a base table).
CREATE TRIGGER (signal trigger)
Use the CREATE TRIGGER command to create a signal trigger that fires in response to incidents in the ObjectServer, or that fires in response to a user-defined signal.
CREATE TRIGGER (temporal trigger)
Use the CREATE TRIGGER command to create temporal triggers that fire at a specified frequency.
CREATE TRIGGER GROUP
Use the CREATE TRIGGER GROUP command to create a new trigger group. When you create a trigger, you must assign it to a trigger group.
CREATE USER
Use the CREATE USER command to add a user to the ObjectServer.
CREATE VIEW
Use the CREATE VIEW command to create a view.
DELETE
Use the DELETE command to delete one or more rows of data from an existing table.
DESCRIBE
Use the DESCRIBE command to display information about the columns of the specified table or view.
DROP COLUMN
To drop columns from an existing table, use the DROP COLUMN setting with the ALTER TABLE command.
DROP DATABASE
Use the DROP DATABASE command to drop an existing database.
DROP FILE
Use the DROP FILE command to drop an existing ObjectServer file.
DROP GROUP
Use the DROP GROUP command to delete the specified group.
DROP INDEX
Use the DROP INDEX command to remove a redundant index on a database table.
DROP PROCEDURE
Use the DROP PROCEDURE command to drop an existing procedure.
DROP RESTRICTION FILTER
Use the DROP RESTRICTION FILTER command to drop an existing restriction filter.
DROP ROLE
Use the DROP ROLE command to drop an existing role.
DROP SIGNAL
Use the DROP SIGNAL command to drop a user-defined signal.
DROP TABLE
Use the DROP TABLE command to drop an existing table.
DROP TRIGGER
Use the DROP TRIGGER command to drop an existing trigger.
DROP TRIGGER GROUP
Use the DROP TRIGGER GROUP command to drop an existing trigger group.
DROP USER
Use the DROP USER command to delete the specified user.
DROP VIEW
Use the DROP VIEW command to drop an existing view.
EXECUTE PROCEDURE
After you create a procedure, you must run it using the EXECUTE PROCEDURE command for the actions in the procedure to occur. You can do this using the SQL interactive interface (nco_sql) or in a trigger or procedure.
FOR
When constructing the body of an SQL procedure, you can use the FOR loop to perform actions a set number of times, based on a counter variable.
FOR EACH ROW
When constructing the body of an SQL procedure, you can use the FOR EACH ROW loop to perform actions on a set of rows that match a certain condition.
GRANT
Use the GRANT command to assign system and object permissions to roles. System permissions control the commands that can be run in the ObjectServer. Object permissions control access to individual objects, such as tables.
GRANT ROLE
After you have created roles as collections of permissions, you can assign the roles to groups and revoke the roles from groups. Use the GRANT ROLE command to assign roles to groups.
IF THEN ELSE
When constructing the body of an SQL procedure, you can use the IF THEN ELSE statement to perform one or more actions based on the specified conditions.
IDUC EVTFT
Use the IDUC EVTFT command to activate pop-up notifiers for accelerated events to be sent to clients, and to enable click-across functionality to the desktop event list or the Web GUI Active Event List.
IDUC FLUSH
Use the IDUC FLUSH command to send IDUC notifications to IDUC clients.
IDUC SNDMSG
Use the IDUC SNDMSG command to send information messages to an Accelerated Event Notification client.
INSERT
Use the INSERT command to insert a new row of data into an existing table.
RAISE SIGNAL
Use the RAISE SIGNAL command to raise a user-defined signal.
REVOKE
Use the REVOKE command to revoke system and object permissions from roles.
REVOKE ROLE
Use the REVOKE ROLE command to revoke roles from groups.
SELECT (scalar)
The scalar SELECT command retrieves columns and rows from a table based on specified criteria.
SELECT (aggregate)
An aggregate SELECT command performs a calculation on a number of rows and returns a single value.
SELECT (GROUP BY)
You can use a SELECT command with a GROUP BY clause to group all rows that have identical values in a specified column or combination of columns, into a single row. You can also find the aggregate value for each group of column values.
SET
When constructing the body of an SQL procedure, you can use a SET assignment statement to write the value of an expression to a variable or parameter.
SET DATABASE and USE DATABASE
Use the SET DATABASE or USE DATABASE command to set a database as the default for an SQL interactive interface nco_sql session. These two commands perform the same function.
SVC
Use the SVC command to add or update the state of a service status alert in the service.status table for IBM Tivoli Composite Application Manager for Internet Service Monitoring.
UPDATE
Use the UPDATE command to update one or more columns in an existing row of data in a table.
WRITE INTO
Use the WRITE INTO command to write logging information to ObjectServer files. For example, you can use the command to write output from a trigger to a log file. An ObjectServer file is a logical file, which has a corresponding file or set of files on the physical file system.

Parent topic: Reference

Related concepts

ObjectServer SQL