Understanding Application Engine Meta-SQL

Application Engine meta-SQL is divided into the following categories:

  • Construct

    A construct is a direct substitution of a value that helps to build or modify a SQL statement.

  • Function

    A function performs an action on its own or causes another function to be called.

  • Meta-variable

    A meta-variable allows substitution of text within SQL statements.

Note: Some meta-SQL elements can be used only in Application Engine programs, some can be used both in Application Engine programs and in other environments, and some cannot be used in Application Engine programs at all. This PeopleBook discusses only meta-SQL elements that can be used in Application Engine. You can find a complete reference to all PeopleSoft meta-SQL elements in PeopleCode Language Reference.