SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.1 (H06.23+, J06.12+)
B Supported SQL statements
RMXCI supports these SQL statements, SQL utilities, and other SQL-related commands. For more
information about these statements, see the SQL/MX Release 3.x Reference Manual.
DescriptionSQL Statement
Modifies an SQL/MX index by changing one or more file attributes of
the index.
ALTER INDEX
Changes the physical name of an SQL/MP table to which an existing
alias is mapped.
ALTER SQLMP ALIAS
Adds a column to a table or renames a table.ALTER TABLE
Enables or disables triggers, individually or by SQL table.ALTER TRIGGER
Renames a view.ALTER VIEW
Starts a transaction.BEGIN WORK
Invokes a stored procedure in Java (SPJ).CALL
Commits changes made during a transaction and ends the transaction.COMMIT WORK
Creates a new SQL/MX catalog.CREATE CATALOG
Creates an index on a table.CREATE INDEX
Creates a schema.CREATE SCHEMA
Defines mappings from an ANSI name to the physical names of an
SQL/MP table or view.
CREATE SQLMP ALIAS
Creates a table.CREATE TABLE
Creates a trigger on an SQL table. A trigger is a mechanism that
enables a database system to perform certain actions automatically
when specified events occur.
CREATE TRIGGER
Creates a view.CREATE VIEW
Deletes a row or rows from a table or an updateable view.DELETE
Deletes an empty SQL/MX catalog.DROP CATALOG
Deletes an index.DROP INDEX
Deletes a schema.DROP SCHEMA
Deletes mappings from ANSI names to physical names of SQL/MP
tables or views.
DROP SQLMP ALIAS
Deletes a table and any indexes, constraints, and inactive locks on the
table.
DROP TABLE
Deletes a trigger on an SQL table.DROP TRIGGER
Deletes a view.DROP VIEW
Executes an SQL statement previously compiled by a PREPARE statement.EXECUTE
Helps you review query execution plans.EXPLAIN
Grants access privileges for a table or view to specified users.GRANT
Grants privileges for calling a stored procedure in Java (SPJ) to one or
more specified users.
GRANT EXECUTE
Inserts rows of data into a table or view.INSERT
The INVOKE command generates a record description that corresponds
to a row in the specified table or view.
INVOKE
Locks the specified table (or underlying tables of a view) and its
associated indexes for the duration of the active transaction.
LOCK TABLE
119