The cdc_closesess() function

Closes a capture session that is associated with the specified session ID.

Any resources used by the capture session are released. The rows in the syscdctabs and syscdcsess tables containing the specified session ID are deleted.

Syntax


1  cdc_closesess ( session_ID )

Function argument

Table 1. The cdc_closesess() argument
Argument Data Type Description
session_ID INTEGER The session ID of the capture session that you want to close.

Usage

Use the cdc_closesess() function to close a capture session that you no longer need. If the capture session was active, all data capture is immediately stopped when the session is closed.

You must call this function from a client application. You cannot call this function from a user-defined routine that runs within the database server.

Return values

If successful, returns 0.

If unsuccessful, returns an integer corresponding to an error code and updates the syscdcsess table with the error information.