SYS_MGR

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 the 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).