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.

Related Views

This procedure has no related views.

Syntax

ttXlaUnsubscribe('tblName', 'bookmark')

Parameters

ttXlaUnsubscribe has the parameters:

Parameter Type Description

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.

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.