MX Release 3.1 (H06.23+, J06.12+)

Welcome to the NonStop(TM) SQL/MX Remote Conversational Interface

SQL>SET SCHEMA NONSTOP.RMXCI_SAMPLE;

--- SQL operation complete.

SQL>

To display the SQL status messages in SQLPlus look-and-feel, set the -DrmxciLF property value

to SQLPlus. The following are examples of SQLPlus look-and-feel status messages:

Picked up _JAVA_OPTIONS: -DrmxciLF=SQLPLUS

Welcome to the NonStop(TM) SQL/MX Remote Conversational Interface

Connected to Data Source: TDM_Default_DataSource

SQL>SET SCHEMA NONSTOP.RMXCI_SAMPLE;

Schema set.

SQL>

The -DrmxciLF property value for setting the Teradata look-and-feel is BTEQ. Setting this property

results in a Teradata personality for the status messages logged for all SQL operations within

RMXCI. The following is the Teradata look-and-feel display:

Picked up_JAVA_OPTIONS: -DrmxciLF=BTEQ

Welcome to the NonStop(TM) SQL/MX Remote Conversational Interface

Connected to DataSource: TDM_Default_DataSource

SQL>set schema NONSTOP.RMXCI_SAMPLE;

*** Total Query time was 1 second.

*** Schema has been set.

*** Total elapsed time was 1 second(s).

SQL>select * from mgrlist;

*** Total Query time was 1 second.

FIRST_NAME LAST_NAME DEPARTMEMT

----------- ---------------- -----------—

JERRY HOWARD FINANCE

ROBERT WHITE PERSONNEL

THOMAS RUDOLF INVENTORY

MARY MILLER SHIPPING

JANE RAYMOND MARKETING

PAUL WINTER CANADA SALES

KLAUS SAFFERT GERMNY SALES

GLENN THOMAS ENGLND SALES

SHERRIE WONG ASIA SALES

RACHAEL MCKAY RESEARCH

ERIC BROWN PLANNING

ROGER GREEN CORPORATE

*** Query completed. 12 rows found. 4 columns returned.

*** Total elapsed time was 1 second(s).

SQL>

Post-installation procedures 19