Skip to main content

IdTrxFrom

The “From” list of characters for Identifier Translation.

Synopsis

[SQL]    IdTrxFrom=n

Description

The value n is a string of characters that provides the “From” list for Identifier Translation mappings. The maximum length of the string is 256 characters. The default string is:

~ `@#$%^&*()_+-=[]\{}|;':"",./<>?".

These mappings filter/modify valid SQL identifier characters when translating SQL identifiers into Objects identifiers. When converting an SQL identifier to an Objects identifier at runtime, the characters in the “From” string are converted to the characters in the “To” string. Also see IdTrxTo.

Examples

IdTrxFrom=~ `@#$%^&*()_+-=[]\{}|;':",./<>?

Range of Values

As described above.

Management Portal

On the page System Administration > Configuration > SQL and Object Settings > General SQL Settings, in the Identifier translation - From field, enter a string of characters.

FeedbackOpens in a new tab