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

Showing information about SQL database objects..................................................................59
Displaying run commands...................................................................................................60
Editing and rerun a command.............................................................................................60
Clearing the interface window.............................................................................................60
Obtaining help..................................................................................................................61
Running SQL statements...........................................................................................................61
Executing an SQL Statement................................................................................................61
Repeating an SQL Statement...............................................................................................61
Preparing and executing SQL Statements..............................................................................62
Executing CREATE TRIGGER statements.....................................................................................65
Logging output.......................................................................................................................66
Starting the logging process................................................................................................66
Stopping the logging process..............................................................................................67
Viewing the contents of a log file.........................................................................................67
5 Running scripts in RMXCI...........................................................................69
Creating a script file...............................................................................................................69
Supported SQL statements in script files................................................................................69
Permitted RMXCI commands in script files..............................................................................69
Comments.........................................................................................................................69
Section headers.................................................................................................................69
Example of a script file.......................................................................................................70
Running a script file................................................................................................................70
Logging output.......................................................................................................................71
Running scripts in parallel........................................................................................................71
6 Running RMXCI from Perl or Python.............................................................72
Login environment variables.....................................................................................................72
Setting the login environment variables ................................................................................72
Perl and Python wrapper scripts................................................................................................74
Launching RMXCI from the Perl or Python command-line...............................................................74
Example of a Perl Program (example.pl)................................................................................74
A RMXCI commands....................................................................................76
@ command..........................................................................................................................79
Syntax..............................................................................................................................79
Examples..........................................................................................................................79
/ command...........................................................................................................................79
Syntax..............................................................................................................................79
Considerations..................................................................................................................80
Example...........................................................................................................................80
ALIAS command.....................................................................................................................80
Syntax..............................................................................................................................80
Considerations..................................................................................................................80
Examples..........................................................................................................................80
CLEAR command....................................................................................................................81
Syntax..............................................................................................................................81
Considerations..................................................................................................................81
Example...........................................................................................................................81
CONNECT command.............................................................................................................81
Syntax..............................................................................................................................81
Considerations..................................................................................................................82
Examples..........................................................................................................................82
DELAY command....................................................................................................................82
Syntax..............................................................................................................................82
Considerations..................................................................................................................83
4 Contents