ODBC Server Reference Manual

Index
HP NonStop ODBC Server Reference Manual—429151-002
Index-7
G
data type conversion (continued)
string 3-21
CONCAT 3-21
LENGTH 3-21
LOCATE 3-21
LTRIM 3-22
RTRIM 3-22
SUSBSTRING 3-22
UCASE 3-22
UPPER 4-23
support of 1-7, 3-14, 4-17, A-3, B-5
system 3-22, 4-23
DATABASE 3-22
DB_NAME 4-23
SUSER_NAME 4-24
USER 3-23
USER_ID 4-24
USER_NAME 4-24
G
Gateway, function of 2-4
GETDATE function 4-19
Global variables
See Variables, global
GOVERNING statements 7-75
Governing, resource 2-20
GROUP BY clause 3-58, 4-34, 4-87
Group names
See Names, owner
Guardian username 2-19
H
Hardware requirements
DOS workstation 1-6
HP NonStop server 1-5
UNIX workstation 1-7
HAVING clause 3-58, 4-88
HELP command, NOSCOM 7-15
HISTORY command, NOSCOM 7-15
Hour datepart 4-20
HOUR function 3-16
I
Identifiers
See also Names
Transact-SQL 4-3
IN EXCLUSIVE MODE clause 3-60, 4-91
IN operator 3-26
INDEX statement 7-50
Indexes
creating in pass-through mode 6-19
dependent, dropping 3-48, 3-50, 4-69,
4-72
descending 6-19
multiple, dropping 4-67
names 3-8, 4-11
See also Objects
INFO command, NOSCOM 7-15
Initializing
server trace 6-20
Initializing NSODBC servers 2-33
INSERT statement
in pass-through mode 6-11
syntax 3-51, 4-76
INTERVAL data type
selecting in pass-through mode 6-14
INTO clause 4-86, 4-90
IS NULL operator 3-26
J
Joins, support of B-9
L
LENGTH function 3-21
Levels of ODBC SQL syntax 1-7
LIKE operator 3-26, 3-28, 4-31, 4-33
Listing customized catalogs 7-5
Listing Mapped Object Names 7-8