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

DROP TRIGGER statement, 142
DROP VIEW statement, 142
EXECUTE statement, 142
EXPLAIN statement, 142
GRANT EXECUTE statement, 142
GRANT statement, 142
INSERT statement, 142
LOCK TABLE statement, 142
POPULATE INDEX utility, 143
PREPARE statement, 143
PURGEDATA utility, 143
REVOKE EXECUTE statement, 143
REVOKE statement, 143
ROLLBACK WORK statement, 143
SELECT ROW COUNT statement, 143
SELECT statement, 143
SET CATALOG statement, 143
SET MPLOC statement, 143
SET NAMETYPE statement, 143
SET SCHEMA, 143
SET TABLE TIMEOUT statement, 143
SET TRANSACTION statement, 143
SHOWCONTROL command, 143
SHOWDDL command, 143
UNLOCK TABLE command, 143
UPDATE statement, 143
UPDATE STATISTICS statement, 143
SQL terminator
setting, 57
showing, 57
SQL utilities, 142
SQL/MX Remote Conversational Interface, 52, 53
breaking across lines, 54
case sensitivity, 55
description of, 54
exiting, quitting, or disconnecting, 53
launching and running a script file, 50
launching from a Perl or Python command-line, 74
launching on Linux , 43
Perl wrapper script, 74
product banner, 54
prompts, 54
Python wrapper script, 74
SQLMX JDBC Type 4 Driver
See JDBC driver, 19
SQLPlus look-and-feel, 35
Standard prompt
customizing, 56
description of, 54
displaying the current time, 57
T
Tables
showing all tables in a schema, 59
wild-card search, 135
TDM_Default_DataSource, 45
Teradata look-and-feel, 35
Timeout, idle session, 56
Transaction, example of, 67
Type 4 driver
See JDBC driver, 19
U
UNIX launch file, location of, 32
UPDATE STATISTICS statement
description of, 143
User profile
setting _JAVA_OPTIONS, 38, 39
setting the PATH, 19, 43
Utilities, 142
V
VERSION command, 140
Views
showing all views in a schema, 59
wild-card search, 137
W
Wild-card characters, 97
Wild-card search
procedures, 129
schemas, 123, 131
tables, 135
views, 137
157