ttSetUserTableID

This procedure explicitly sets 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.

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

ttSetUserTableID('tblName', repID)

Parameters

ttSetUserTableID 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.
`repID`	`BINARY(8) NOT NULL`	Integer identifier.

tblName

TT_CHAR (61) NOT NULL

Table name.

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

repID

BINARY(8) NOT NULL

Integer identifier.

Result Set

ttSetUserTableID returns no results.

Examples

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