Introduction - assure_mimix

This document provides an overview of the SQL interfaces available in Assure MIMIX, intended at tool developers and detailing internal interfaces designed for use by the Assure MIMIX Core. To ensure upward compatibility, it is highly recommended to use named parameters when invoking these functions, also referred as routines. For example, MYFUNCTION(inMyParm=>value1, InOtherParm=>value2).

Assure MIMIX supports SQL interfaces, similar to IBM i SQL Services, which allow you to retrieve information and perform operations through SQL commands. This implementation allows modern tools and programs to interact with MIMIX. Although the initial service pack offers a limited set of functions, additional services will be introduced based on user feedback.

Users of MIMIX SQL Services must have Product Level Security (PLS) access, with specific access levels documented for each routine.

Functions that begin with MX_STATUS require the MIMIX policy for extraction status to be enabled on the system you are connecting to. For more information on the extraction process, see the Enabling Assure HA HealthLink Extraction process using SETMMXPCY.

Note: The MIMIX instance referenced by the APIs is retrieved from the library containing the invoked MIMIX SQL Service.

Introduction - assure_mimix - Latest

Assure MIMIX SQL Services Reference