SQL options for DRDA access
Certain SQL statement processing options are relevant when you prepare a package to be run with DRDA access.
The following SQL statement processing options are relevant
for DRDA access:
- CONNECT
- Use CONNECT(2), explicitly or by default.
CONNECT(1) causes your CONNECT statements to allow only the restricted function known as "remote unit of work". Be particularly careful to avoid CONNECT(1) if your application updates more than one DBMS in a single unit of work.
- SQL
- Use SQL(ALL) explicitly for a package that runs on a server
that is not DB2® for z/OS®.
The precompiler then accepts any statement that obeys DRDA rules.
Use SQL(DB2), explicitly or by default, if the server is DB2 for z/OS only. The precompiler then rejects any statement that does not obey the rules of DB2 for z/OS.