SQL/MP Programming Manual for COBOL

Contents
HP NonStop SQL/MP Programming Manual for COBOL—529758-003
vi
10. Dynamic SQL Operations
10. Dynamic SQL Operations
Using Dynamic SQL 10-2
Uses for Dynamic SQL 10-4
Determining When to Use Dynamic SQL 10-5
Features of Dynamic SQL 10-5
Processing Database Requests 10-5
Using Parameters 10-6
Developing a Dynamic SQL Application 10-9
Declaring a Host Variable 10-10
Declaring the SQLCA and SQLSA Data Structures 10-10
Defining Storage for Input and Output Parameters 10-11
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