SQL/MP Reference Manual

Index
HP NonStop SQL/MP Reference Manual—523352-013
Index-13
D
Data declaration
BEGIN DECLARE SECTION
directive B-2
END DECLARE SECTION
directive E-3
tables and views I-25
Data Definition Language (DDL)
alternate keys C-100
and database concurrency C-65, D-21
clauses, CONVERT statement C-101
groups, converting C-107
performance considerations C-134
primary key C-100
record definitions, Enscribe file C-100
security requirements S-15
Data Definition Language (DDL) statements
ALTER CATALOG A-8
ALTER COLLATION A-10
ALTER INDEX A-13
ALTER PROGRAM A-27
ALTER TABLE A-29
ALTER VIEW A-50
COMMENT C-48
CREATE CATALOG C-132
CREATE COLLATION C-137
CREATE CONSTRAINT C-139
CREATE TABLE C-154
CREATE VIEW C-166
description of D-20
DROP D-63
HELP TEXT H-4
processing rules T-7
UPDATE STATISTICS U-7
Data dictionary D-1
Data Management Language (DML)
statements C-65
Data Manipulation Language (DML)
statements D-58
Data Manipulation Language (DML)
statements
and database concurrency C-65
authorization requirements S-16
processing rules T-7
Data retrieval
cursor declaration D-23
SELECT statement S-17
Data selection
See Selecting data
Data Status Language (DSL)
statements D-67
Data Status Language (DSL) statements
GET CATALOG OF SYSTEM G-1
GET VERSION G-2
GET VERSION OF PROGRAM G-4
Data syntax
CHARACTER D-2
DATETIME D-6
DECIMAL D-5
DOUBLE PRECISION D-5
FLOAT D-5
INTEGER D-5
INTERVAL D-7
LARGEINT D-5
NUMERIC D-4
PICTURE 9 D-6
PICTURE X D-4
REAL D-5
SMALLINT D-5
Data types
character C-13
converting C-4, L-36
DATE D-8
DATETIME D-15
date-time D-9
DDL L-36
decimal C-104
description of D-1
dynamic SQL parameters and P-13