ODBC Server Reference Manual

Index
HP NonStop ODBC Server Reference Manual—429151-002
Index-15
U
Transactions (continued)
in pass-through mode 6-7
names 4-11
Transact-SQL statements
ALTER TABLE 4-42
BEGIN TRANSACTION 4-45
BEGIN...END 4-44
COMMIT TRANSACTION 4-46
CREATE DATABASE 4-48
CREATE INDEX 4-51
CREATE TABLE 4-54
CREATE VIEW 4-58
DECLARE 4-61
DELETE 4-63
DROP DATABASE 4-65
DROP INDEX 4-67
DROP TABLE 4-69
DROP VIEW 4-71
EXECUTE 4-74
INSERT 4-76
PRINT 4-79
ROLLBACK TRANSACTION 4-79
SAVE TRANSACTION 4-81
See also individual statements
SELECT 4-82
SET 4-92
summary B-11
support of B-11
translated to NonStop SQL/MP 1-4, 4-1
TRUNCATE TABLE 4-95
UPDATE 4-96
UPDATE STATISTICS 4-98
USE 4-99
Transact-SQL
catalog views 8-60
data types 4-12
identifiers 4-3, 4-7
names 4-5
statements 4-40
Transact-SQL (continued)
statements (summary) 4-35
statements (table) 4-36
TRA_LOG statement 7-107
TRUNCATE TABLE statement
in user-defined transactions 4-3
syntax 4-95
TSQL statements
See Transact-SQL statements
Types of clients 2-6
Types of users 2-2
U
UCASE function 3-22
UMAP statement 7-112
UNION clause 3-58
UNIX
DB-LIBRARY syntax for 9-1
UNLOCK statement 6-4
UNLOCK TABLE statement, in pass-
through mode 6-11, 6-20
UPDATE statement
FROM clause 4-97
in pass-through mode 6-11
positioned 3-61
searched 3-62
syntax 4-96
UPDATE STATISTICS statement 4-98
UPPER function 4-23
Uppercase comparisons 4-31
USE statement 4-99
USER function 3-23
USER statement 7-115
USERCAT DEINSTALL statement 7-24
USERCAT INSTALL statement 7-20
USERCAT REFRESH statement 7-29
USERCAT UPGRADES statement 7-37
USERCAT VALIDATE statement 7-33
Usernames
alias 2-19