Metastrings

Metastrings are special SQL expressions. The metastrings, also called meta-SQL, are preceded with a percent (%) symbol, and can be included directly in string literals. They expand at runtime into an appropriate substring for the current database platform. Metastrings are used in or with:

• SQLExec.

• Scroll buffer functions (ScrollSelect and its relatives).

• PeopleSoft Application Designer to construct dynamic views.

• Some rowset object methods (Select, SelectNew, Fill, and so on).

• SQL objects.

• Application Engine.

• Some record class methods (Insert, Update, and so on).

• COBOL.