About Pass-Through SQL

The SBM pass-through SQL capability is very powerful, enabling you to go beyond the functionality provided by the SBM reports that use basic conditions.

When you use the pass-through method, SBM passes the WHERE clause through directly to the DBMS (after adding on some clauses to enforce privileges). Use the @ modifier as a prefix to your statement. The statement is passed straight through to the query engine, unmodified.

Pass-through SQL enables you to implement sub-queries to system tables or to other user tables. The full power of SQL (functions, aggregates, etc.) is available in your WHERE clause.

Note: When you use the @ modifier, the only operators allowed for Multi-Selection, Multi-Group, and Multi-User fields are LIKE and NOT LIKE. The actual ID value that represents the selection value must be used. For example, the Accounting selection value may have an ID value of 145. This record is #145 in the Selections table. To write the above examples using the pass-through method, type @WHERE TS_FUNCTIONAL_AREA LIKE '%,145,%' Since the Multi Selection, Multi-Group, and Multi-User fields are stored as strings of ID values, the wildcard characters can find any string that contains the value specified. Commas are necessary to select the appropriate value from the string.

About Pass-Through SQL

Related Topics