Skip to main content
Previous section   Next section

IdTrxFrom

Define the “From” list of characters for Identifier Translation.

Synopsis

[SQL]    IdTrxFrom=n

n is a string with a maximum length of 256 characters. The default string is ~ `@#$%^&*()_+-=[]\{}|;':"",./<>?"..

Description

IdTrxFrom is a string of characters that provides the “From” list for DDL Identifier Translation mappings. 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 DDL runtime, the characters in the “From” string are converted to the characters in the “To” string.

For further details, see the “Identifiers” chapter in Using InterSystems SQL. Also see the parameter IdTrxTo.

Changing This Parameter

To set the desired value for IdTrxFrom from the Terminal, use the SetDDLIdentifierTranslations() method of the %SYSTEM.SQL class. See the class reference for details.

You can also change IdTrxFrom with the Config.SQL class (as described in the class reference) or by editing the CPF in a text editor (as described in the Editing the Active CPF section of the “Introduction to the Configuration Parameter File” chapter in this book).