ttSetUserTableID

Description

This procedure can be used to explicitly set the value of the user table ID. The table that each row is associated with is expressed with two codes: an application-supplied code called the user table ID and a system-provided code called the system table ID. Updates are presented to the application by the Transaction Log API in the form of complete rows. The user table ID has the value zero until explicitly set with the ttSetUserTableID procedure.

Required privilege

This procedure requires the XLA privilege.

Syntax

ttSetUserTableID('tblName', repID)

Parameters

ttSetUserTableID has these parameters:

Parameter	Type	Description
`tblName`	TT_CHAR (61) NOT NULL	Table name.
`repID`	BINARY(8) NOT NULL	Integer identifier.

Result set

ttSetUserTableID returns no results.

Example

CALL ttSetUserTableID('APP.SESSION', 0x123456);