Environmental Commands

Topics: Issuing Data Adapter Commands Querying Data Adapter Parameter Settings Parameters That Apply to Multiple Data Adapters Parameters That Apply to DB2 Only Parameters That Apply to Teradata Only Parameters That Apply to IDMS/SQL Only Parameters That Apply to Oracle Only Parameters That Apply to MODIFY Only Data Adapter Dialogue Manager Variables

Data adapter environmental commands can change certain parameters that govern your FOCUS session. These parameters control or identify the Change Verify Protocol, DB2 Call Attachment Facility defaults, DBSPACE defaults, the Fastload option, the DB2 CURRENT SQLID, Oracle blocked insert and fetch sizes, data adapter logon parameters, optimization, and isolation levels. Environmental commands that control connection to the RDBMS, such as SET AUTODISCONNECT, are discussed in Controlling Connection Scope. You can display all the current parameter settings with the data adapter SQL ? query described in Querying Data Adapter Parameter Settings.