Skip to Main Content
Return to Navigation

Understanding Meta-SQL

This section discusses:

Meta-SQL Use

Meta-SQL expands to platform-specific SQL substrings, causes another function to be called, or substitutes a value. Meta-SQL constructs are used in functions that pass SQL strings, such as the following:

  • SQLExec.

  • Scroll buffer functions (ScrollSelect and its relatives).

  • Application Designer dynamic views and SQL views.

  • Some Rowset class methods (Select, SelectNew, Fill, and so on.).

  • The SQL class.

  • Application Engine programs.

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

  • COBOL functions.

Meta-SQL Element Types

There are three types of meta-SQL elements:

  • Construct.

    Constructs are a direct substitution of a value, and help to build or modify a SQL statement.

    Examples include %Bind, %InsertSelect, and %List.

  • Function.

    Functions perform actions or cause another function to be called.

    Examples include %ClearCursor, %Execute, and %ExecuteEdits.

  • Meta-variable.

    Meta-variables enable substitution of text within SQL statements.

    Examples include %AsOfDate, %Comma, and %JobInstance.