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:
Types There are three types of meta-SQL elements:
Constructs are a direct substitution of a value, and help to build or modify a SQL statement. Examples include %Bind, %InsertSelect, and %List.
Functions perform actions or cause another function to be called. Examples include %ClearCursor, %Execute, and %ExecuteEdits.
Meta-variables enable substitution of text within SQL statements. Examples incldue %AsOfDate, %Comma, and %JobInstance.
If a meta-SQL construct, function, or meta-variable is supported in PeopleCode, it is supported in all types of PeopleCode programs; that is, in Application Engine PeopleCode programs (actions), component interface PeopleCode programs, and so on.
Note. Even if a meta-SQL element is used in PeopelCode, you cannot use meta-SQL like a built-in function. You can use meta-SQL in the SQLExec function, the Select method, the Fill method, and so on. Note. Meta-SQL is not available in SQR