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

J
JDBC driver
installation, 13
verifying the version, 13
JDBC Type 4 driver see JDBC driver
L
LABEL command, 71
Launch files, location of, 16
Launch parameters
descriptions of, 26
presetting on Linux or UNIX, 23
lib directory, 16
Linux launch file, location of, 16
LOCALHOST command, 71
LOG command, 72
Log files, 46
PRUN operation, 77
Logging in
default method, 23
using login parameters, 27
Logging output
concurrent sessions, 46
script file execution, 50
starting, 45
stopping, 46
viewing a log file, 46
Login environment variables
description of, 51
setting on a Linux command-line, 51
Login parameters
presetting on Linux or UNIX, 23
specifying on the command-line, 27
Look and feel
setting a look-and-feel type, 20
O
OBEY command, 49, 74
P
Parameters, SQL
displaying, 42
resetting, 43
setting, 42
PATH environment variable, 13, 22
Perl command-line
invoking SQL/MX Remote Conversational Interface, 52
Perl program
running, 52
Perl wrapper script
description of, 52
POPULATE INDEX utility
description of, 120
Port number, default, 24
PREPARE statement
description of, 120
Procedures
wild-card search, 106
Product banner, 33
Prompts
continuation, 33
standard, 33
PRUN
syntax, 77
Python command-line
invoking SQL/MX Remote Conversational Interface, 52
Python program
running, 52
Python wrapper script
description of, 52
Q
QUIT command, 79
R
RECONNECT command, 79
Remote Conversational Interface, 31
installation directory, 16
launching and running a command, 28
software files, 16
testing the launch of, 20
Remote SQL/MX Conversational Interface
description of, 11
logging output, 45
using in a script file, 48
REPEAT command, 80
RESET LASTERROR command, 81
RESET PARAM command
examples of, 43
syntax of, 82
rmxci directory, 16
RMXCI look—and—feel, 18
rmxci.jar, location of, 16
rmxci.pl
description of, 52
rmxci.py
description of, 52
location of, 16
rmxci.sh
location of, 16
setting the path of, 22
RMXCI_PERL_JSERVER environment variable, 51
RMXCI_PERL_JSERVER_PORT environment variable, 51
RMXCI_PYTHON_JSERVER environment variable, 51
RUN command, 82
S
Sample script files, 16
SAVEHIST command, 83
Schema
setting the current schema, 37
showing all schemas in the default catalog, 38
showing the current schema, 37
wild-card search, 100, 108
Script file
comments, 48
creating, 48
example of, 49
132 Index