ttXlaUnsubscribe

Description

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

Required privilege

This procedure requires the XLA privilege.

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.
`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.

Example

Command > call ttXlaSubscribe ('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.