SQL/MP Programming Manual for COBOL85

Contents
HP NonStop SQL/MP Programming Manual for COBOL85—429326-004
vi
10. Dynamic SQL Operations (continued)
10. Dynamic SQL Operations (continued)
Using Parameters 10-5
Developing a Dynamic SQL Application 10-8
Declaring a Host Variable 10-10
Declaring the SQLCA and SQLSA Data Structures 10-10
Defining Storage for Input and Output Parameters 10-10
Preparing the SQL Statement 10-18
Checking for Parameters 10-18
Handling Parameters 10-20
Prompting the User for Input Values 10-24
Performing the Database Request 10-29
Displaying Output 10-32
Constructing a Server that Interfaces With Pathway 10-35
Constructing an SQL Statement from User Input 10-35
Constructing a Reply Message 10-36
Sample Dynamic SQL Program 10-37
11. Character Processing Rules (CPRL) Procedures
COBOLEXT File 11-2
CPRL Error Codes 11-2
CPRL_ARE_ 11-3
CPRL_AREALPHAS_ 11-4
CPRL_ARENUMERICS_ 11-5
CPRL_COMPARE1ENCODED_ 11-6
CPRL_COMPARE_ 11-7
CPRL_COMPAREOBJECTS_ 11-8
CPRL_DECODE_ 11-9
CPRL_DOWNSHIFT_ 11-10
CPRL_ENCODE_ 11-11
CPRL_GETALPHATABLE_ 11-12
CPRL_GETCHARCLASSTABLE_ 11-13
CPRL_GETDOWNSHIFTTABLE_ 11-14
CPRL_GETFIRST_ 11-14
CPRL_GETLAST_ 11-15
CPRL_GETNEXTINSEQUENCE_ 11-16
CPRL_GETNUMTABLE_ 11-17
CPRL_GETSPECIALTABLE_ 11-18
CPRL_GETUPSHIFTTABLE_ 11-19
CPRL_INFO_ 11-19