SODBC_TOKEN

Change the character used for arrayed fields and groups

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