SQL/MX Remote Conversational Interface (RMXCI) Guide for SQL/MX Release 3.2 (H06.25+, J06.14+)

running multiple files in parallel, 71
running one file at a time, 70
running when launching SQL/MX Remote
Conversational Interface, 50
SELECT statement
description of, 143
example of, 61
Session, 56
SESSION command, 132
SET COLSEP command, 106, 107
SET commands, in a script file, 50
SET FETCHSIZE command, 108
SET HISTOPT command, 108
SET IDLETIMEOUT command
syntax of, 110
SET LIST_COUNT command, 110
SET MARKUP command, 111
SET PARAM command
examples of, 63, 64
syntax of, 114
SET PROMPT command
example of, 56
syntax of, 116
SET SCHEMA statement
description of, 143
example of, 58, 70
SET SQLPROMPT command, 117
SET SQLTERMINATOR command
example of, 57
syntax of, 118
SET STATISTICS command
syntax of, 119
SET TIME command
examples of, 57
syntax of, 120
SET TIMING command
examples of, 57
syntax of, 120
SHOW ACTIVITYCOUNT command, 121
SHOW ALIAS command, 121
SHOW ALIASES command, 122
SHOW CATALOG command, 123
SHOW CATALOGS command, 123
SHOW COLSEP command, 124
SHOW ERRORCODE command, 124
SHOW FETCHSIZE command, 125
SHOW HISTOPT command, 125
SHOW IDLETIMEOUT command
syntax of, 125
SHOW LASTERROR command, 126
SHOW LIST_COUNT command, 127
SHOW MARKUP command, 127
SHOW PARAM command
example of, 63
syntax of, 127
SHOW PREPARED command, 128
SHOW PROCEDURES command, 129
SHOW RECOUNT command, 130
SHOW SCHEMA command
example of, 58
syntax of, 130
SHOW SCHEMAS command
example of, 59
syntax of, 131
SHOW SESSION command, 132
SHOW SQLPROMPT command, 134
SHOW SQLTERMINATOR command, 134
SHOW STATISTICS command, 134
SHOW TABLES command
example of, 59
syntax of, 135
SHOW TIME command, 136
SHOW TIMING command, 136
SHOW VIEWS command
example of, 59
syntax of, 137
SPOOL command
examples of, 66
syntax of, 138
Spooling see Logging output
SQL parameters
displaying, 63
resetting, 64
setting, 63
SQL statement
breaking across lines, 54
displaying the elapsed time, 57
editing, 86, 89
preparing and executing, 62
repeating, 61, 102
running in the SQL/MX Remote Conversational Interface,
61
running when launching Remote Conversational
Interface, 49
terminating, 55
SQL statements, supported in
ALTER INDEX statement, 142
ALTER SQLMP ALIAS statement, 142
ALTER TABLE statement, 142
SQL statements, supported in RMXCI
ALTER TRIGGER statement, 142
ALTER VIEW statement, 142
BEGIN WORK statement, 142
CALL statement, 142
COMMIT WORK statement, 142
CREATE CATALOG statement, 142
CREATE INDEX statement, 142
CREATE SCHEMA, 142
CREATE SQLMP ALIAS statement, 142
CREATE TABLE, 142
CREATE TRIGGER statement, 142
CREATE VIEW statement, 142
DELETE statement, 142
DROP CATALOG statement, 142
DROP INDEX statement, 142
DROP SCHEMA statement, 142
DROP SQLMP ALIAS statement, 142
DROP TABLE statement, 142
156 Index