SQL/MP Programming Manual for C

Index
HP NonStop SQL/MP Programming Manual for C—429847-008
Index-6
E
E
Embedded SQL statements
advantages 1-1
description 1-3
in C source file 1-3, 3-1
overview 1-1
Empty section in SQL program 6-21
EMS collector process B-5
END DECLARE SECTION directive 1-2,
2-1
Enscribe database
memory use by program B-2
utilities protection for SQL objects 8-1
Enscribe I/O 5-6, 5-21
Error and status reporting
description 1-5, 9-1
display format control 5-5, 5-15
SQL procedures 5-1
SQLCADISPLAY procedure 5-3
SQLCAFSCODE procedure 5-8
SQLCATOBUFFER procedure 5-14
sqlcode 9-4
SQLMSG file 5-2
SQLSA structure 9-13
WHENEVER directive 9-6
Errors and warnings
SQL/MP, SQL compiler 6-23
Errors and warnings, SQL/MP
DELETE statement 4-13, 4-23
disk-process errors 5-8
FETCH statement 4-20
file-system errors 5-8
INSERT statement 4-8
operating system errors 5-8
run-time SQL recompilation 8-9
UPDATE statement 4-11
EXEC SQL keywords 3-1
EXECUTE IMMEDIATE statement
description 1-6
EXECUTE IMMEDIATE statement, SQL
compilation errors 6-23
EXECUTE statement 1-6
Executing a C program 1-5, 7-1
Execution plan
EXPLAIN report 6-27
optimized by SQL compiler 6-13
optimized by statistics 6-23
SQL compiler function 6-13
EXPLAIN utility
EXPLAIN DEFINES report 6-27
EXPLAIN PLAN report 6-27
SQL compiler option 6-16
SQLCOMP DEFINES option 7-2
-Wverbose flag 6-33
Explicit SQL compilation
description 1-5
Explicit SQL compilation, SQLCOMP
command 6-14
EXT option, SQLMEM pragma B-2
Extended data segment, specifying
default B-2
EXTENT attribute, similarity check
rules 8-12
eye_catcher field in SQLDA,
initializing 10-5, 10-29
F
FastSort program 5-3, 5-14
FETCH statement 4-15, 4-22, 10-12
File attributes, SQL
effect of altering 8-3
similarity check rules 8-12
File label, SQL program
inconsistency with catalog 8-4
SQL validation 8-1
File number of SQLMSG file 5-4, 5-15
File Utility Program (FUP)
DUPLICATE command 8-2
FILEINFO command 8-1