SQL/MX Comparison Guide for SQL/MP Users

Index
HP NonStop SQL/MX Comparison Guide for SQL/MP Users—523735-003
Index-8
T
SQL/MX catalogs 6-2
STABLE access
description of 3-17
EXCLUSIVE MODE 3-18
READ COMMITTED 3-17
SQL/MX compared to SQL/MP 3-17
Standards conformance 2-15
Statements
DDL (Data Definition Language) 6-1
DML (Data Manipulation
Language) 3-12
DSL (Data Status Language) 2-7
Statistics
SQLSA 4-10
updating 5-9
Stored procedures 2-16
String functions 2-16
String literals 2-16
Subqueries 2-16
SUBSTRING function 2-16
SUBTOTAL command 2-16
SUBTOTAL_LABEL option 2-16
SUM function 2-16
Super ID 2-16
SYSKEY 2-16
System catalog 2-16
SYSTEM command 2-16
System DEFINEs 2-16
SYSTEM_DEFAULTS table 5-7
T
Table references 3-15
TABLECODE file attribute 2-16
Tables
attributes of 6-4
clustering keys 6-4
constraints 6-4
description of 6-4
file types 6-4
TABLES table 2-16
TACL 1-3
TEDIT command 2-16
Temporary tables 2-16
TIME data type 2-17
TIMESTAMP data type 2-17
TIME_FORMAT option 2-16
TMF transactions 2-17
TOTAL command 2-17
Transaction management
auto abort 3-19
AUTOCOMMIT 3-19
cursor operations 3-21
ending a transaction 3-18
example of 3-19
explicit transactions 3-18
implicit transactions 3-18
inherited transactions 3-19
SET TRANSACTION statement 3-19
starting a transaction 3-18
system-defined 3-18
user-defined transactions 3-18
Transaction Management Facility
(TMF) 3-18
TRANSID table 2-17
TRIM function 2-17
U
UNDERLINE_CHAR option 2-17
UNLOCK TABLE statement 2-17
Updatable cursors 4-6
UPDATE statement 3-16
UPDATE STATISTICS statement 2-17
UPGRADE CATALOG command 2-17
UPGRADE SYSTEM CATALOG
command 2-17
UPSHIFT function 2-17
USAGES table 2-17
User-defined transaction 3-18
Utilities 7-1