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.