Restricting the Use of Direct SQL Passthru Commands

By default, users can issue SQL commands directly to Db2.

Use of Direct SQL Passthru enables users to directly report from or modify tables in the RDBMS, without the need for FOCUS Master and Access Files. You may want to restrict the use of Direct SQL Passthru if your Master Files have FOCUS DBA security restrictions that limit user access to tables and views.

To disable Direct SQL Passthru, issue the following command in any supported profile, at the command line, or in a procedure.

SET DPT = OFF

Note: When Direct SQL Passthru is disabled:

• It cannot be enabled in the same FOCUS session.
• The AUTODB2 tool will not work.

For complete information about Direct SQL Passthru, see the Relational Data Adapter User's Manual.