IdTrxFrom

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()Opens in a new tab method of the %SYSTEM.SQL.UtilOpens in a new tab class. See the class reference for details.

You can also change IdTrxFrom with the Config.SQLOpens in a new tab 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).