The syntax of Apply Engine commands and functions are patterned after SQL and adhere to the following guidelines:
Required Keywords
Items in capitalized lettering represent commands or functions and their required keyword(s) and must be entered exactly as shown. A bar (‘|’) indicates one or more mutually exclusive Keywords that must be entered in the command.
SELECT * FROM <source_datastore> KEYWORD1 | KEYWORD2 | KEYWORD3;
Required Parameters
Required parameters of command or function keywords are lowercase and usually enclosed by <..>.
SELECT <column1> FROM <source_datastore>;
Optional Keywords and Parameters
Optional keywords and parameters appear within brackets.
SELECT <column1> FROM <source_datastore> [UNION];
Multiple Occurring Parameters
Parameters (required or optional) that can occur more than once for a given command appear in brackets with a comma before the parameter. The [, column] signifies that multiple columns/fields can be specified within the SELECT sub-command. A bar (‘|’) indicates one or more mutually exclusive parameters that can be entered in the command.
SELECT * | <column> [,<column>][,function] FROM <source_datastore>;
Command Termination
Some Apply Engine commands must be terminated with a semi-colon (;) because they indicate the end of a parameter list as indicated in the Command Syntax and Examples .
Internal Functions do not require a terminating semi-colon.
Procedures as known as PROCs and Function Procedures sometimes referred to as "User Functions" will end with a semi-colon.
Comments
Comments within a script can be either line comments or block comments. Line comments are the most common and are denoted by two (2) or more dashes (--) usually in the first two (2) columns of the script.
-- This is a comment line