IDMSRADM › Input Parameter Statements › SET COMMIT Statement

SET COMMIT Statement

Purpose

The SET COMMIT statement specifies the frequency at which IDMSRADM issues COMMIT commands when a table is imported or deleted.

Syntax

►►─┬─────────────────────────────┬─────────────── . ───────────────────────────►◄
   └─ SET COMmit ─┬────────────┬─┘
                  ├─ interval ─┤
                  └─ 0 ◄───────┘

Parameters

interval

The number of STORE (for IMPORT) or ERASE (for DELETE) operations IDMSRADM is to perform before issuing a COMMIT.

By default, if you do not specify an interval, IDMSRADM will not issue a COMMIT until the IMPORT or DELETE operation is complete.

0

Directs IDMSRADM not to issue a COMMIT until the IMPORT or DELETE operation is complete.