Accessing DB2 from REXX EXECs with RxD2/LINK

If RxD2/LINK is installed in the BBI-SS PAS, MainView AutoOPERATOR REXX EXECs can issue dynamic SQLs to access and manipulate DB2 data.

The REXX EXEC can ADDRESS DB2 as it can ADDRESS MVS.

With this facility, you can

  • access the DB2 catalog for information about DB2 objects (such as tables and plans)
  • access other DB2 tables to read external data that can govern MainView AutoOPERATOR procedures
  • store data collected by the EXECs for later queries and reporting using the full function of SQL

Refer to the RxD2/LINK User Guide and Reference for more information about customization and usage.

Note

The BBI-SS PAS requires authorization for the DB2 functions to be performed.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*