SQL Programming Manual for TAL

Index
HP NonStop SQL Programming Manual for TAL—527887-001
Index-2
C
Catalog, SQL
access for program file execution 5-7
handling mixed versions D-12
version 1 D-2
version 2 D-2, D-8
with
SQLGETCATALOGVERSION 4-19
Circumflex (^)
in host variable names 2-2
CLOSE statement, SQL 3-7, 3-8, 3-34
CLOSE system procedure 1-3
COBOL85 programming language 1-1
Colon (:) with host variable 1-3
Colon(:) with host variable 2-6
COLUMNS catalog tables
version 2 features D-8
Column, SQL
definition for versions D-4
for C10 program migration D-4
Comments, in SQL statements 3-2
COMMIT WORK statement, SQL 7-14
Compatibility of SQL components D-9
Compiler directives
for TAL compiler 5-4
Compiling
automatic SQL recompilation 5-24
dynamic SQL statements 5-14
explicit SQL 5-10
TAL program 1-7, 5-2
Components, SQL
version compatibility of D-9
Compound TAL statement 3-2
Constraints
changes and program file validity 5-22
creating E-1
using for data integrity E-1
CONTROL directives 3-8
CONTROL EXECUTOR directive, SQL 3-9
CONTROL QUERY directive, SQL 3-10
CONTROL TABLE directive, SQL 3-10
Conversational interface, NonStop SQL 1-1
CONVERTTIMESTAMP SQL function 3-22
CONVERTTIMESTAMP system
procedure 3-22
Copying SQL files, effect on SQL
validity 5-22
CREATE INDEX statement, SQL 5-23
CREATE TABLE statement, SQL 2-20, 7-2
version compatibility D-4
CURRENTDEFINES option, SQL
compiler 5-7
Cursor
CLOSE statement 3-7
closing for dynamic SQL 7-13
declaration 3-11
DECLARE CURSOR statement,
SQL 3-11
declaring for dynamic SQL 7-12
deleting 3-15
dynamic 3-16
dynamic CLOSE 3-16
dynamic OPEN 3-29
dynamic operation 3-30
FETCH statement 3-18, 3-29
guidelines for using 3-45
in SELECT statement 3-34
initializing WHERE variable 3-33
opening for dynamic SQL 7-13
static 3-7
static CLOSE 3-7
static OPEN 3-29
UPDATE WHERE CURRENT
statement, SQL 3-45
using with dynamic SQL 7-31
when to close 3-35
when to initialize 3-35
with OPEN statement 3-29