ttXlaUnsubscribe

This procedure stops persistent XLA tracking of a table. This procedure cannot be run when the specified bookmark is in use.

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

ttXlaUnsubscribe('tblName', 'bookmark')

Parameters

ttXlaUnsubscribe has the parameters:

Parameter	Type	Description
tblName	TT_CHAR (61) NOT NULL	The name of the table on which XLA tracking should be stopped. Using a synonym to specify a table name is not supported.
bookmark	TT_CHAR (31) NOT NULL	The name of the bookmark that the application uses to track this table.

Result Set

ttXlaSubscribe returns no results.

Examples

Command > call ttXlaUnsubscribe ('SALLY.ACCTS', 'mybookmark');

Note:

Before dropping a table that is subscribed to by an XLA bookmark, you must first drop all XLA bookmarks or unsubscribe from XLA tracking.

See Also

• ttXlaBookmarkCreate
• ttXlaBookmarkDelete
• ttXlaSubscribe