Rules for regular identifiers

Data Model > Accessing the UNICOM Intelligence Data Model > Working with the Case Data Model > General information > Rules for regular identifiers

The first character must be one of the following:

▪A letter as defined by the Unicode Standard 3.0. The Unicode definition of letters includes Latin characters a-z and A-Z, in addition to letter characters from other languages.

▪The _ (underscore) symbol.

Subsequent characters can be:

▪Letters as defined in the Unicode Standard 3.0.

▪Decimal numbers from either Basic Latin or other national scripts.

▪The @, $, #, or _ symbols.

General rules are:

▪The identifier can be an SQL reserved word. The Provider reserves both the uppercase and lowercase versions of reserved words. For more information, see Reserved keywords.

▪Embedded spaces or special characters are not allowed.

Any identifier that does not comply with all of these rules must always be delimited by double quotation marks or brackets when used in Provider SQL statements.

Note The Unicode Standard 3.0 definition of a letter is "An informative property that applies to characters that are used to write words. This group includes characters such as capital letters, small letters, ideographs, hangul, and spacing modifier letters." Refer to the Unicode Standard 3.0 CD-ROM for the letter property mappings.