Meta-SQL Element Types

There are three types of meta-SQL elements:

• Constructs

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

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

• Functions

  Functions perform actions or cause another function to be called.

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

• Meta-SQL variables

  Meta-SQL variables enable substitution of text within SQL statements.

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