Statements That the Run Option Supports

Home | Previous Page | Next Page The Query-language Option > Running an SQL Statement >

Statements That the Run Option Supports

Table 6 lists the statements that you can execute with the Run option.

Table 6. SQL Statements for Run Option
	Options
SQL Statement	XPS	IDS
ALTER ACCESS_METHOD		x
ALTER FRAGMENT	x	x
ALTER FUNCTION		x
ALTER INDEX		x
ALTER PROCEDURE		x
ALTER ROUTINE		x
ALTER SEQUENCE		x
ALTER TABLE	x	x
BEGIN WORK	x	x
CLOSE DATABASE	x	x
COMMIT WORK	x	x
CONNECT	x	x
CREATE ACCESS_METHOD		x
CREATE AGGREGATE		x
CREATE CAST		x
CREATE DATABASE	x	x
CREATE DISTINCT TYPE		x
CREATE FRAGMENT	x	x
CREATE INDEX	x	x
CREATE OPAQUE TYPE		x
CREATE OPCLASS		x
CREATE FUNCTION		x
CREATE PROCEDURE	x	x
CREATE ROLE	x	x
CREATE ROW TYPE		x
CREATE SCHEMA	x	x
CREATE SEQUENCE		x
CREATE SYNONYM	x	x
CREATE TABLE	x	x
CREATE TRIGGER		x
CREATE VIEW	x	x
DATABASE	x	x
DELETE	x	x
DISCONNECT	x	x
DROP AGGREGATE		x
DROP CAST		x
DROP DATABASE	x	x
DROP DISTINCT TYPE		x
DROP INDEX	x	x
DROP OPAQUE TYPE		x
DROP OPCLASS		x
DROP FUNCTION		x
DROP PROCEDURE	x	x
DROP ROLE	x	x
DROP ROW TYPE		x
DROP SEQUENCE		x
DROP SYNONYM	x	x
DROP TABLE	x	x
DROP TRIGGER		x
DROP VIEW	x	x
EXECUTE PROCEDURE	x	x
EXECUTE FUNCTION		x
GRANT	x	x
GRANT FRAGMENT		x
INFO	x	x
INSERT	x	x
LOAD	x	x
LOCK TABLE	x	x
MERGE	x
MOVE TABLE	x
OUTPUT	x	x
RENAME COLUMN	x	x
RENAME DATABASE	x	x
RENAME SEQUENCE		x
RENAME TABLE	x	x
REVOKE	x	x
REVOKE FRAGMENT		x
ROLLBACK WORK	x	x
SAVE EXTERNAL DIRECTIVES		x
SELECT	x	x
SET	x	x
SET COLLATION		x
SET DATASKIP	x	x
SET DEBUG FILE TO	x	x
SET ENCRYPTION PASSWORD		x
SET ENVIRONMENT	x	x
SET EXPLAIN	x	x
SET ISOLATION	x	x
SET LOCK MODE	x	x
SET LOG	x	x
SET OPTIMIZATION	x	x
SET PDQPRIORITY	x	x
SET OPTIMIZATION	x	x
SET ROLE	x	x
SET SESSION AUTHORIZATION	x	x
SET STATEMENT CACHE		x
SET TRANSACTION	x	x
START VIOLATIONS TABLE	x	x
STOP VIOLATIONS TABLE	x	x
UNLOAD	x	x
UNLOCK TABLE	x	x
UPDATE	x	x
UPDATE STATISTICS	x	x

For information about additional statements for Optical Subsystem, see the IBM Informix: Optical Subsystem Guide.

Tip:

To execute statements that are not listed, use the SQL menu options New (or Use-editor) and Save to enter and save them, and then run the saved file from the command line.