Change the character used for arrayed fields and groups
|
WTSupported in traditional Synergy on Windows
|
WNSupported in Synergy .NET on Windows
|
USupported on UNIX
|
VSupported on OpenVMS
|
The SODBC_TOKEN environment variable enables you to change the character that the dbcreate utility (or DBA) uses when it generates column names for an arrayed field or group.
Value
Any character that is valid as an SQL identifier character for your ODBC applications.
Discussion
When you generate a system catalog for a repository that has an arrayed field, each element in the arrayed field is mapped as a separate column with a name that consists of the array name, the element’s position in the array, and pound signs (#), by default, to delineate position values. (For example, a [2,2] arrayed field with the name myarray will be mapped to the following: myarray#1#1, myarray#1#2, myarray#2#1, and myarray#2#2.) The same is true of groups that are arrays. See Arrays for more information.
You can change the character used to delineate position values by setting SODBC_TOKEN to the character you want to use. For example, you can instruct dbcreate to use underscore (_) rather than #:
set SODBC_TOKEN=_
For the myarray field described above, this would result in the following columns: myarray_1_1, myarray_1_2, myarray_2_1, and myarray_2_2.
Setting location
The environment where you run dbcreate.
Used by
xfODBC
See also
Changing the position delimiter used for arrays (SODBC_TOKEN)
