Rational Developer for System z
Enterprise PL/I for z/OS, Version 4.2, Programming Guide

SQL preprocessor

Programming and compilation considerations
SQL preprocessor options
APOSTSQL
ATTACH
CCSID0
CONNECT
DATE
DEC
FLOAT
GRAPHIC
INCONLY
LEVEL
NOFOR
SQL
SQLFLAG
STDSQL
TIME
VERSION
XREF
Coding SQL statements in PL/I applications
Defining the SQL communications area
Defining SQL descriptor areas
Embedding SQL statements
Using host variables
Using host structures
Using indicator variables
Host structure example
General information on LOBs
Suppressing SQL preprocessor messages

In general, the coding for your PL/I program will be the same whether or not you want it to access a DB2 database. However, to retrieve, update, insert, and delete DB2 data and use other DB2 services, you must use SQL statements. You can use dynamic and static EXEC SQL statements in PL/I applications.

To communicate with DB2, you need to do the following:

Before you can take advantage of EXEC SQL support, you must have authority to access a DB2 system. Contact your local DB2 Database Administrator for your authorization.


Terms of use | Feedback

This information center is powered by Eclipse technology. (http://www.eclipse.org)