StartSQLTransaction()

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

Syntax

The StartSQLTransaction(); statement uses following syntax.

StartSQLTransaction( database identifier );

Arguments

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

Table 1. Arguments of StartSQLTransaction()
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" );