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

Index
Symbols
-DrmxciLF property, 18
-dsn parameter, 26
-h parameter, 26
-help, 27
-host parameter, 26
-noconnect parameter, 27
-p parameter, 26
-password parameter, 26
-q parameter
description of, 27
examples of, 28, 29
-s parameter
description of, 27
-script parameter, 27
-sql parameter, 27
-u parameter, 26
-user parameter, 26
-version, 27
/ command
example of, 40
syntax of, 57
@ command
example of, 49
syntax of , 57
_JAVA_OPTIONS environment variable
setting at a command-line prompt, 20
setting in the user profile, 20
A
ALIAS command, 58
B
bin directory, 16
C
Case sensitivity, 34
Change bars, 6
CLEAR command, 59
CLEAR option, 45
Command line, breaking, 33
Comments, 48
CONNECT command, 59
Continuation prompt, 33
CREATE SCHEMA statement
description of, 119
example of, 28, 49
CREATE TABLE statement
description of, 119
example of, 49
CREATE TRIGGER statement
example of, 44
D
Data definition language (DDL) statements, running
simultaneously, 50
Data source connection, 33
Database, creating, 50
Default schema, 37
DELAY command, 60
DISCONNECT command, 61
Documents, related information, 8
E
Editing commands, FC, 65
Elapsed time, displaying, 36
Enable trace
setting the Java option property, 20
ENV command, 61
Environment variables
_JAVA_OPTIONS, 20
PATH, 22
RMXCI_PERL_JSERVER, 51
RMXCI_PERL_JSERVER_PORT, 51
RMXCI_PYTHON_JSERVER, 51
Error messages, 40
EXECUTE statement
description of, 119
examples of, 43
EXIT command, 63
EXPLAIN statement
description of, 119
F
FC command, 64
G
GET STATISTICS command, 66
GOTO command, 67
H
HELP command, 68
HISTORY command, 68
Host name, 24
I
Idle timeout value, 35
IF...THEN command, 69
Indexes, showing all indexes of a table, 38
INSERT statement
description of, 119
example of, 36
Installation procedures
testing the launch of Remote Conversational Interface,
20
IP address, 24
131