Identifiers are used to specify field references, variables, and keywords.
"Customer Data"
Greeting_"""Hello"""
The restrictions on using reserved keywords, and the cautions about using non-reserved keywords, affect features that are not supported in the version of ESQL supported by the service flow project tools (such as procedure names, function names, and the names of variables in procedures).
Therefore in general you need not be concerned with these restrictions and cautions.
You can use a reserved keyword as a name or as a part of a name in a field reference (for example, intCaseID). This is true in the subset of ESQL supported by the service flow project tools and is also true in full ESQL.
| Item: | Reserved keywords: | Non-reserved keywords: |
|---|---|---|
| Members: | CASE, FROM, NOT, WHEN | AND, BOOLEAN, CHAR, CHARACTER, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, DATE, DECIMAL, FALSE, FLOAT, INT, INTEGER, IS, NULL, OR, PLACING, TIME, TRUE, UNKNOWN |
| Affects: | The names of variables in procedures. (This feature is not supported in the service flow project tools.) | The names of variables, procedures, and user functions. (These features are not supported in the service flow project tools.) |
| Restriction or caution: | Not allowed. ESQL flags the use of a reserved keyword with an error. | Deprecated. Use can make ESQL code difficult to understand. |