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

Contents
About this document......................................................................................6
Intended audience....................................................................................................................6
Document organization.............................................................................................................6
New and changed information in this edition...............................................................................6
Notation conventions................................................................................................................6
Related documentation..............................................................................................................8
Publishing history....................................................................................................................10
HP encourages your comments.................................................................................................10
1 Introduction to RMXCI...............................................................................11
2 Installing RMXCI.......................................................................................12
Pre-installation procedures.......................................................................................................12
Installation procedure..............................................................................................................14
Post-installation procedures......................................................................................................16
3 Launching RMXCI.....................................................................................22
Launching RMXCI ..................................................................................................................22
Logging in to the database platform..........................................................................................23
Exiting RMXCI........................................................................................................................32
4 Interactively running commands in RMXCI....................................................33
Running commands................................................................................................................33
Using RMXCI commands.........................................................................................................34
Running SQL statements...........................................................................................................40
Executing CREATE TRIGGER statements.....................................................................................44
Logging output.......................................................................................................................45
5 Running scripts in RMXCI...........................................................................48
Creating a script file...............................................................................................................48
Running a script file................................................................................................................49
Logging output.......................................................................................................................50
Running scripts in parallel........................................................................................................50
6 Running RMXCI from Perl or Python.............................................................51
Login environment variables.....................................................................................................51
Perl and Python wrapper scripts................................................................................................52
Launching RMXCI from the Perl or Python command-line...............................................................52
A RMXCI commands....................................................................................54
@ command..........................................................................................................................57
/ command...........................................................................................................................57
ALIAS command.....................................................................................................................58
CLEAR command....................................................................................................................59
CONNECT command.............................................................................................................59
DELAY command....................................................................................................................60
DISCONNECT command........................................................................................................61
ENV command......................................................................................................................61
EXIT command.......................................................................................................................63
FC command.........................................................................................................................64
GET STATISTICS command.......................................................................................................66
GOTO command....................................................................................................................67
HELP command......................................................................................................................68
HISTORY command.................................................................................................................68
IF...THEN command................................................................................................................69
Contents 3