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
- To add pluggable SQL support, send a transaction request
that includes the elements
generateQuery=Y
andBusinessTxType=<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. - To persist the pluggable SQL statements, use the granular addInqLevelQuery or updateInqLevelQuery transactions.