The SYS_MGR global object provides functions and variables
that control the environment for your WebFOCUS Maintain
application. It can help developers ensure the most efficient interaction
between Maintain and DBMS servers, as well as manage WebFOCUS 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
- Issue system
settings for WebFOCUS servers on the fly (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,
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.