Rational Developer for System z

Identifiers and keywords in ESQL

This topic briefly describes identifiers and keywords in ESQL.
Important: To fully understand a feature described in this topic, you should read the complete description of the feature in the documentation for WebSphere® Message Broker (see Reference works describing ESQL).

Identifiers

Identifiers are used to specify field references, variables, and keywords.

To be valid:
  • An identifier must contain at least one character
  • An identifier can contain only alphanumeric characters and underscore.
  • The first character must not be numeric.
You can avoid these limitations by enclosing names not conforming to these rules in double quotation marks. For example:

"Customer Data"

If you need to refer to a field that contain quotation marks, use two pairs of quotation marks around the reference. For example:

Greeting_"""Hello"""

Reserved keywords and non-reserved keywords

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.

The table below summarizes some information about reserved keywords and non-reserved keywords in the subset of ESQL supported by the service flow project tools.
Note: Note that a keyword can be spelled with any combination of upper case and lower case characters.
Table 1. Reserved keywords and non-reserved keywords
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.


Terms of use | Feedback

This information center is powered by Eclipse technology. (http://www.eclipse.org)