ttSetUserColumnID
The system assigns an ID to each column during a CREATE TABLE
or ALTER TABLE
operation. Setting a user-assigned value for the column ID enables you to have a unique set of column numbers across the entire database or a specific column numbering system for a given table.
Required Privilege
This procedure requires the XLA
privilege.
Usage in TimesTen Scaleout and TimesTen Classic
This procedure is supported in TimesTen Classic but not supported in TimesTen Scaleout.Related Views
This procedure has no related views.
Syntax
ttSetUserColumnID('tblName', 'colName', repID)
Parameters
ttSetUserColumnID
has these parameters:
Parameter | Type | Description |
---|---|---|
|
|
Table name. Using a synonym to specify a table name is not supported. |
|
|
Column name. |
|
|
Integer identifier. |
Result Set
ttSetUserColumnID
returns no results.
Examples
CALL ttSetUserColumnID('APP.SESSION', 'SESSIONID', 15);
See Also