ttSetUserColumnID

Description

This procedure can be used to explicitly set 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.

Required privilege

This procedure requires the XLA privilege.

Syntax

ttSetUserColumnID('tblName', 'colName', repID)

Parameters

ttSetUserColumnID has these parameters:

Parameter	Type	Description
`tblName`	TT_CHAR(61) NOT NULL	Table name.
`colName`	TT_CHAR(30) NOT NULL	Column name.
`repID`	TT_INTEGER NOT NULL	Integer identifier.

Result set

ttSetUserColumnID returns no results.

Example

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