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.

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);