SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.1 (H06.23+, J06.12+)

running multiple files in parallel, 50
running one file at a time, 49
running when launching SQL/MX Remote
Conversational Interface, 29
SELECT statement
description of, 120
example of, 40
Session, 35
SESSION command, 109
SET COLSEP command, 83, 84
SET commands, in a script file, 29
SET FETCHSIZE command, 85
SET HISTOPT command, 86
SET IDLETIMEOUT command
syntax of, 87
SET LIST_COUNT command, 87
SET MARKUP command, 89
SET PARAM command
examples of, 42, 43
syntax of, 92
SET PROMPT command
example of, 35
syntax of, 93
SET SCHEMA statement
description of, 120
example of, 37, 49
SET SQLPROMPT command, 94
SET SQLTERMINATOR command
example of, 36
syntax of, 96
SET STATISTICS command
syntax of, 96
SET TIME command
examples of, 36
syntax of, 97
SET TIMING command
examples of, 36
syntax of, 98
SHOW ACTIVITYCOUNT command, 98
SHOW ALIAS command, 99
SHOW ALIASES command, 100
SHOW CATALOG command, 100
SHOW CATALOGS command, 100
SHOW COLSEP command, 101
SHOW ERRORCODE command, 102
SHOW FETCHSIZE command, 102
SHOW HISTOPT command, 102
SHOW IDLETIMEOUT command
syntax of, 103
SHOW LASTERROR command, 104
SHOW LIST_COUNT command, 104
SHOW MARKUP command, 105
SHOW PARAM command
example of, 42
syntax of, 105
SHOW PREPARED command, 106
SHOW PROCEDURES command, 106
SHOW RECOUNT command, 107
SHOW SCHEMA command
example of, 37
syntax of, 108
SHOW SCHEMAS command
example of, 38
syntax of, 108
SHOW SESSION command, 109
SHOW SQLPROMPT command, 111
SHOW SQLTERMINATOR command, 111
SHOW STATISTICS command, 112
SHOW TABLES command
example of, 38
syntax of, 112
SHOW TIME command, 113
SHOW TIMING command, 113
SHOW VIEWS command
example of, 38
syntax of, 114
SPOOL command
examples of, 45
syntax of, 115
Spooling see Logging output
SQL parameters
displaying, 42
resetting, 43
setting, 42
SQL statement
breaking across lines, 33
displaying the elapsed time, 36
editing, 64, 66
preparing and executing, 41
repeating, 40, 80
running in the SQL/MX Remote Conversational Interface,
40
running when launching Remote Conversational
Interface, 28
terminating, 34
SQL statements, supported in
ALTER INDEX statement, 119
ALTER SQLMP ALIAS statement, 119
ALTER TABLE statement, 119
SQL statements, supported in RMXCI
ALTER TRIGGER statement, 119
ALTER VIEW statement, 119
BEGIN WORK statement, 119
CALL statement, 119
COMMIT WORK statement, 119
CREATE CATALOG statement, 119
CREATE INDEX statement, 119
CREATE SCHEMA, 119
CREATE SQLMP ALIAS statement, 119
CREATE TABLE, 119
CREATE TRIGGER statement, 119
CREATE VIEW statement, 119
DELETE statement, 119
DROP CATALOG statement, 119
DROP INDEX statement, 119
DROP SCHEMA statement, 119
DROP SQLMP ALIAS statement, 119
DROP TABLE statement, 119
133