The SYS_MGR global object provides functions and variables
that control the environment for your Maintain application. It can
help developers ensure the most efficient interaction between Maintain
and DBMS servers, as well as manage App Studio environment and run-time
variables.
For use with relational data sources, SYS_MGR can be used from
within Maintain procedures to:
- Deactivate preliminary
database operation checking by Maintain before an update and rely
on the DBMS to perform its own internal checking, thus reducing processing
time and resources (SYS_MGR.PRE_MATCH).
- Retrieve DBMS
error codes, allowing developers to code applications to efficiently recover
from error conditions (SYS_MGR.DBMS_ERRORCODE).
- Issue native
SQL commands directly from a Maintain procedure (SYS_MGR.ENGINE).
The SYS_MGR syntax can also be used from within a Maintain procedure
to:
- Issue system
settings for Reporting Servers dynamically (SYS_MGR.FOCSET).
- Set values for
Userid and Password for target servers before issuing an EXEC AT
or CALL AT.
- Retrieve input
parameter values passed at invocation time (SYS_MGR.GET_INPUTPARAMS_COUNT,
SYS_MGR.GET_NAMEPARM, SYS_MGR.GET_POSITIONPARM).
Note: All sys_mgr function and variable names are case-insensitive.
You can use SYS_MGR.DBMS_ERRORCODE, sys_mgr.dbms_errorcode, sys_mgr.DBMS_ErrorCode, and
so on, interchangeably.