Reporting → Report Search Criteria → Using Advanced SQL Conditions in SBM Reports → 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.
Copyright © 2013–2019 Micro Focus or one of its affiliates. All rights reserved.