SQL/MP Programming Manual for COBOL85

Index
HP NonStop SQL/MP Programming Manual for COBOL85—429326-004
Index-5
E
Dynamic SQL
declaring host variables 10-10
declaring SQLCA and SQLSA data
structures 10-10
defining storage for parameters 10-10
description 1-6
handling parameters 10-20
indicator parameters 10-8
input parameters 10-6
interface with Pathway 10-35
output parameters 10-6
parameter list 10-6
parameters in a loop 10-7
PREPARE statement 10-18
processing database requests 10-4
processing nonSELECT
statements 10-29
processing SELECT statements 10-30
programming techniques 10-4
prompting user for input 10-24
sample program 10-37
SQLSA statistics 9-20
SQL/MP system procedures 5-1
statements, description 3-6, 10-1
steps for developing an
application 10-9
steps for use 10-2
uses 10-3
D-series node, running a program at low
PIN 7-4
E
Embedded NonStop SQL/MP
conformance to ISO/ANSI
standards 1-8
Embedded sign, decimal data type 2-17
Embedded SQL statements
advantages 1-1
compiling a program containing 1-4,
6-1
Embedded SQL statements (continued)
description 3-3
guidelines 3-1
syntax for COBOL source file 3-1
END DECLARE SECTION
description 3-3
host variables 1-2
specifying 2-1
END-EXEC 2-1, 3-1
ENTER TAL statement 5-2, 11-2
Environment variables, OSS 6-17
ERRCODE, SQLCA structure field 9-13
Error codes, CPRL 11-2
Error processing
constraints 9-14
error table 9-16
recommendations, summary 9-19
without WHENEVER 9-5
Errors and warnings
anticipated, examples 9-18
checking SQLCODE directly 9-5
determining disk process, file system,
or operating system errors 5-17
displaying and storing 9-15
errors file 9-16
SQL errors table 9-16
SQLCA_DISPLAY2_ 5-4
SQLCA_TOBUFFER2_ 5-11
system procedures 9-11
terminal 9-16
Lost Open error 4-2
obtaining error information 5-11
retrieving with SQLCI 9-16
selective reporting 9-18
sending to HOMETERM 5-8, 5-11
SQL compiler 6-34
SQL compiler options 6-27
SQL procedures 5-1
SQLCA structure 5-4
SQLCADISPLAY procedure 5-30