SQL/MP Programming Manual for C

Index
HP NonStop SQL/MP Programming Manual for C—429847-008
Index-4
D
CREATE CONSTRAINT statement 4-3
CREATE INDEX statement
NO INVALIDATE option 8-3
program invalidation 8-5
Creation timestamp, similarity check
rules 8-12
C-series Guardian operating system 7-5
CURRENTDEFINES, SQL compiler
option 6-15
Cursor operations
CLOSE statement (dynamic) 10-27
CLOSE statement (static) 4-24
DECLARE CURSOR statement 4-18
DELETE statement 4-23
dynamic SQL cursors
declaration 10-27
description of 10-20
opening 10-27
FETCH statement 4-15, 4-20
foreign cursors 4-24
guidelines 4-22, 10-20
host variables 4-19
initializing 4-19
lost open error 4-4
OPEN statement 4-15, 4-19
process access ID (PAID) requirements
DECLARE CURSOR
statement 4-18
DELETE statement 4-23
description 4-22
FETCH statement 4-20
OPEN statement 4-19
SELECT statement 4-21
SQL objects 4-16
UPDATE statement 4-22
SELECT statement 4-21
stability of cursor 4-17
Virtual sequential block buffering
(VSBB) 4-17
WHERE clause 4-21
D
Data conversion between C and SQL data
types 2-5
Data declarations
BEGIN DECLARE SECTION
directive 2-1
END DECLARE SECTION
directive 2-1
statements 1-3
tables and views 2-19
Data Definition Language (DDL)
SQL statements 1-3
Tandem statements 10-37
Data Manipulation Language (DML)
statements 1-3
Data status language (DSL) statements 1-3
Data structures, SQL
description B-1
placing in memory B-2
Data types
C 2-3, 2-4
conversion between SQL and C 2-5
SQL 2-3, 2-4
Database, sample A-1
Data, SQL
DELETE statement 4-12, 4-23
FETCH statement 4-20
INSERT statement 4-8
SELECT statement 4-4
type correspondence (SQL and C) 2-3,
2-4
UPDATE statement 4-10
DATEFORMAT clause
example 2-14
INVOKE directive 2-14
Date-time data type with INVOKE
directive 2-14
DDL operations, invalidating 8-4