CommitSQLTransaction()

The CommitSQLTransaction(); rule commits a transaction in a specified database.

Syntax

The CommitSQLTransaction(); statement uses following syntax.

CommitSQLTransaction( database identifier );

Arguments

The following table lists the properties of the arguments of this stitcher rule.

Table 1. Arguments of CommitSQLTransaction()
Argument	Description	Accepts constants	Accepts variables	Accepts eval clauses
`database identifier`	Specifies the database on which the commit transaction is to be performed; for example, DNCIM, NCIM, NCMONITOR.	No	No	No

Example

The following example shows how the rule is used.

StartSQLTransaction( "DNCIM" );
        text entityName = NULL;
        foreach(entityNames)
        {
            entityName = eval(text,'&m_Name');
            ExecuteStitcher('PopulateDNCIMObject', entityName, domainId, dynamicDiscoNode);
        }
        delete(entityNames);
CommitSQLTransaction( "DNCIM" );