NonStop SQL/MP Reference Manual

Index
NonStop SQL/MP Reference Manual—142115
Index-13
D
D
Damaged objects, deleting C-19
Data
clearing from file or table P-36
compression of index blocks I-1
copying C-109
deleting D-37
fetching F-3
inserting I-14
loading into database L-17
modifying U-3
removing C-24
retrieval
cursor declaration D-22
SELECT statement S-17
selecting S-17
size limits L-7
updating U-3
Data Control Language (DCL)
authorization S-16
description of D-16
Data declaration
BEGIN DECLARE SECTION
directive B-2
END DECLARE SECTION
directive E-2
tables and views I-24
Data Definition Language (DDL) D-19
Data dictionary D-1
Data Manipulation Language (DML) D-55
Data selection
See Selecting data
Data Status Language (DSL) D-65
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-10
converting C-4
converting Enscribe file to SQL
table L-36
converting SQL table to Enscribe
file L-36
DATE D-7
DATETIME D-14
date-time D-8
DDL L-35
decimal C-100
description of D-1
dynamic SQL parameters and P-13
for parameters C-4, P-14, S-37
FORTRAN C-100
INTERVAL I-19
numeric N-12
of Julian timestamp C-57
TIME T-4
TIMESTAMP T-5
unsupported
COMPLEX L-36
LOGICAL L-36
view columns C-159
Database
authorization for access S-11
integrity C-64, C-131
sample S-1
updating statistics U-7
DATATYPE in COLUMNS table C-41