SQL Programming Manual for Pascal

Index
HP NonStop SQL Programming Manual for Pascal—528614-001
Index-3
E
DESCRIBE INPUT statement 2-13, 3-14,
7-7
DESCRIBE statement 3-14, 7-7
Directives, Pascal compiler 5-4
SQL 7-1
XMEM 7-8
Disk process (DP2) 4-2, 4-9, 4-14
Distributed database, maximizing local
autonomy 5-28
DML statements
See Data manipulation language (DML)
DUPLICATE command, FUP 5-22
Duplicating SQL files, effect of 5-10
Dynamic memory allocation 7-14
Dynamic SQL operations
and static SQL 7-1
applications for 7-1
compilation 5-14
declaring the names buffer 7-5
declaring the SQLDA 7-5
description 1-4
getting information about 6-13
immediate execution 3-16
program overview 7-8
programming techniques 7-7
sample programs C-7
single-code thread design D-14
specifying input parameters 7-4
specifying output variables 7-4
SQLDA release version format D-14
version issues D-7
writing a PATHWAY server 7-2
E
ELSE keyword in SQL statements 3-1
Embedded SQL statements
in Pascal source file 3-1
END DECLARE SECTION directive 2-2,
3-3, 3-6
END keyword in SQL statements 3-1
End of the line, in SQL statement 3-2
Enscribe data file
and data type correspondence 2-7
Enscribe I/O 4-6, 4-23
Error codes
for DELETE statement 3-11
Error messages, SQL compiler 5-11
Error processing
SQLCADISPLAY procedure 4-2
SQLCAFSCODE procedure 4-7
SQLCAGETINFOLIST procedure 4-8
SQLCATOBUFFER procedure 4-14
techniques in sample program B-6
using SQLCODE 6-1
using WHENEVER directive 6-3
Examples
date-time program B-6
detailed dynamic SQL program C-7
insertion program B-1
simple dynamic SQL program C-1
EXEC SQL keyword 3-1
EXECUTE IMMEDIATE statement 1-4,
3-16
EXECUTE statement 1-4, 3-14
Executing a Pascal program 5-2
Execution plan
EXPLAIN report 5-18
optimized by SQL compiler 5-6
EXPLAIN report
execution plan 5-18
Explicit SQL compilation 5-5
EYE_CATCHER field
initializing 7-20
F
FASTSORT program 4-2, 4-8, 4-14
FETCH statement 3-13, 3-17, 3-40, 7-5
File attributes, SQL
effect of altering 5-23