DB2 Server for VSE & VM: Application Programming

Appendix E. Using SQL in PL/I

Partial Table-of-Contents

Using PL/I Sample Programs

Rules for Using SQL in PL/I

Placing and Continuing SQL Statements

Delimiting SQL Statements

Using the INCLUDE Statement

Declaring Static External Variables

Identifying Rules for Case

Declaring Host Variables

Using Host Variables in SQL Statements

Using PL/I Variables in SQL: Data Conversion Considerations

Using DBCS Characters in PL/I

Using SQL Statements in PL/I Subroutines

Coding the SIZE Parameter in VSE JCL (DB2 Server for VSE)

Handling SQL Errors

Handling Program Interrupts

Using Dynamic SQL Statements in PL/I

Defining DB2 Server for VSE & VM Data Types for PL/I

Using Stored Procedures

Contents

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]