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

Contents
About this document....................................................................................10
Intended audience..................................................................................................................10
Document organization...........................................................................................................10
New and changed information in this edition.............................................................................10
Notation conventions..............................................................................................................10
General syntax notation......................................................................................................10
Related documentation............................................................................................................12
NonStop SQL/MX customer library......................................................................................12
Publishing history....................................................................................................................14
HP encourages your comments.................................................................................................14
1 Introduction to RMXCI...............................................................................15
2 Installing RMXCI.......................................................................................16
Pre-installation procedures.......................................................................................................16
Installing and verifying the Java Runtime Environment (JRE)......................................................16
Installing and verifying the NonStop JDBC Type 4 Driver.........................................................19
(Optional) Installing Perl or Python........................................................................................20
Installation procedures.............................................................................................................20
Downloading the Installer...................................................................................................20
Verifying the installer file version..........................................................................................22
Installing RMXCI................................................................................................................22
Post-installation procedures......................................................................................................32
Verifying the installed software files......................................................................................32
Verifying the installed version of RMXCI................................................................................32
Setting the Look-and-Feel of RMXCI.......................................................................................33
Testing the RMXCI launch....................................................................................................39
3 Launching RMXCI.....................................................................................41
Launching RMXCI on Windows using graphic tools.....................................................................41
Launching RMXCI on Linux.......................................................................................................43
Setting the rmxci.sh PATH....................................................................................................43
Presetting the optional launch parameters.............................................................................44
Logging in to the database platform..........................................................................................44
Default login.....................................................................................................................44
Login parameters...............................................................................................................47
Using optional launch parameters........................................................................................47
Exiting RMXCI........................................................................................................................53
4 Interactively running commands in RMXCI....................................................54
Running commands................................................................................................................54
Product banner..................................................................................................................54
Interface prompts...............................................................................................................54
Breaking the command line.................................................................................................54
Case sensitivity..................................................................................................................55
Using RMXCI commands.........................................................................................................55
Showing the session attributes.............................................................................................55
Setting and showing the idletimeout value for the session........................................................56
Customizing the standard prompt.........................................................................................56
Setting and showing the SQL terminator................................................................................57
Displaying the elapsed time................................................................................................57
Setting and showing the current schema................................................................................58
Limiting the result set of a query...........................................................................................58
Contents 3