ODBC Server Reference Manual

Index
HP NonStop ODBC Server Reference Manual—429151-002
Index-4
D
CONTROL QUERY statement, in pass-
through mode 6-11
CONTROL TABLE statement, in pass-
through mode 6-11
Control-of-flow statements 4-38
CONVERT function 3-23, 4-24
CORE SQL data types 3-8
CORE SQL statements
ALTER TABLE 3-33
CALL 3-35
CREATE INDEX 3-37
CREATE TABLE 3-39
CREATE VIEW 3-43
DELETE 3-45
DROP INDEX 3-47
DROP TABLE 3-48
DROP VIEW 3-49
INSERT 3-51
REVOKE 3-53
See also individual statements
SELECT 3-54
summary 3-31, A-7
support of 3-31, A-7
translated to NonStop SQL 3-1
UPDATE 3-61
Correlation names 3-8, 4-11
COUNT function 3-27, 4-32
CREATE ACC_LOG statement 7-40
CREATE CATALOG statement
in pass-through mode 6-9
, 6-15
See also CREATE DATABASE
statement
CREATE CONSTRAINT statement, in pass-
through mode 6-9, 6-17
CREATE DATABASE statement
in user-defined transactions 4-3
syntax 4-48
CREATE INDEX statement
in pass-through mode 6-19
in user-defined transactions 4-3
specifying the index location in 4-54
CREATE INDEX statement (continued)
syntax 3-37, 4-51
CREATE QST_LOG statement 7-74
CREATE TABLE statement
file attributes 3-41, 4-56
in pass-through mode 6-7, 6-16, 6-17
in user-defined transactions 4-3
partitioned tables F-3
security considerations 3-41, 4-56
syntax 3-39, 4-54
CREATE TRA_LOG statement 7-107
CREATE VIEW statement
in pass-through mode 6-18
in user-defined transactions 4-3
shorthand and protection views 3-44,
4-60
syntax 3-43, 4-58
Creation 3-42
CURDATE function 3-16
Current system 3-6, 4-9
Current volume 3-6, 4-9
CURTIME function 3-16
Customized catalog
definition of 7-1
listing of 7-5
privileged users 7-17
syntax for 7-18
D
Data types
mapping of 3-8, 4-12
NonStop SQL/MP
CHAR 3-10
INTERVAL 6-14
specifying 3-8, 4-12
support of 1-7, 1-9, 3-8, 4-12, A-2, B-3
Database
device 4-4
mapping 8-2
names 3-6, 4-8, A-6, B-9