Home / Configuration Parameter File Reference / [SQL] / IdTrxFrom

Configuration Parameter File Reference
Previous section           Next section
InterSystems: The power behind what matters   

The “From” list of characters for Identifier Translation.
[SQL]    IdTrxFrom=n
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.
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.

Previous section           Next section
Send us comments on this page
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-06-26 06:27:05