ODBC Server Reference Manual

Index
HP NonStop ODBC Server Reference Manual—429151-002
Index-6
E
DROP TABLE statement (continued)
in user-defined transactions 4-3
syntax 3-48, 4-69
DROP TRA_LOG statement 7-108
DROP VIEW statement
dropping dependent objects 3-50, 4-72
in user-defined transactions 4-3
syntax 3-49, 4-71
Dropping
dependent indexes 3-48, 3-50, 4-69,
4-72
dependent views 3-48, 3-50, 4-69, 4-72
multiple tables 4-69
partitioned tables 3-49, 4-70
views 3-49, 4-71
Dynamic link library (DLL) 1-3
Dynamic SQL statements, in pass-through
mode 6-12
E
Embedded SQL 2-3
EMS interface 2-34
Escape clauses
for date and time data 3-12
for outer joins 3-13
for scalar functions 3-13
for stored procedure execution 3-14
syntax 3-11
Exclusive locks 3-60, 4-64, 4-91
Exclusive mode (NonStop SQL/MP) 3-60,
4-91
EXECUTE statement, in pass-through
mode 6-12, 6-15, 6-20
Execution of stored procedures 5-4
EXISTS operator 3-26
EXIT command, NOSCOM 7-14
EXP function 3-20, 4-22
Expressions, CASE 3-29
Expressions, support of 1-7, 3-25, 4-29,
A-3, B-4
F
Fault-tolerant programming 5-57
FC command, NOSCOM 7-14
FOR BROWSE clause 4-89
FREE RESOURCES statement, in pass-
through mode 6-11
FROM clause 3-57, 4-86, 4-97
Functions
aggregate
AVG 3-27, 4-31
COUNT 3-27, 4-32
MAX 3-27, 4-32
MIN 3-28, 4-33
SUM 3-28, 4-33
data type conversion
CONVERT 3-23, 4-24
date and time 3-15, 4-19
CURDATE 3-16
CURTIME 3-16
DATEADD 4-19
DATEDIFF 4-19
DATEPART 4-19
DAYOFMONTH 3-16
DAYOFWEEK 3-16
GETDATE 4-19
HOUR 3-16
MINUTE 3-17
MONTH 3-17
NOW 3-17
QUARTER 3-17
SECOND 3-17
TIMESTAMPADD 3-17
TIMESTAMPDIFF 3-18
YEAR 3-19
mathematical 3-20, 4-22
EXP 3-20, 4-22
MOD 3-20
PI 3-20, 4-22
POWER 4-22