Configuring inquiry levels for pluggable SQL

For any transaction that supports pluggable SQL, you can use pluggable SQL to configure inquiry levels.

About this task

The Administration services can be used to add or update an inquiry level to support pluggable SQL. For more information, see New inquiry levels.

Any transaction that supports configurable Inquiry Levels can leverage pluggable SQL.

Procedure

  1. To add pluggable SQL support, send a transaction request that includes the elements generateQuery=Y and BusinessTxType=<business transaction type>.
    The generateQuery flag must be set to Y. BusinessTxType must point to the business transaction type to which the associated transaction pertains. The SQL statements will be generated.
  2. To persist the pluggable SQL statements, use the granular addInqLevelQuery or updateInqLevelQuery transactions.