Please enable JavaScript to view this site.

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 aka 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