ttSetUserColumnID

This procedure explicitly sets the value for the user-specified column ID. Updates presented to the application by the Transaction Log API may contain information about the columns of a table. This column information contains a system-specified column number and a user-specified column identifier. The user-specified column ID has the value 0 until set explicitly by this call.

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

Parameter	Type	Description
`tblName`	`TT_CHAR(61) NOT NULL`	Table name. Using a synonym to specify a table name is not supported.
`colName`	`TT_CHAR(30) NOT NULL`	Column name.
`repID`	`TT_INTEGER NOT NULL`	Integer identifier.

tblName

TT_CHAR(61) NOT NULL

Table name.

Using a synonym to specify a table name is not supported.

colName

TT_CHAR(30) NOT NULL

Column name.

repID

TT_INTEGER NOT NULL

Integer identifier.

Result Set

ttSetUserColumnID returns no results.

Examples

CALL ttSetUserColumnID('APP.SESSION', 'SESSIONID', 15);