Please enable JavaScript to view this site.

The TERMINATE function instructs the Integration Engine to close/disconnect all datastores and stop processing with a user specified return code. For transaction based datastores, a commit is issued if zero is specified for the return code. If anything else is specified, a rollback is issued.

This function is most useful for debuging a script. It is possible to stop the engine on a specific record or after a certain condition is met.

Category

Specialized

Syntax

TERMINATE(*number)*

 

Parameters Descriptions

number Numeric return code to terminate the engine with. If the parameter is not numeric, the engine will end with return code 8.

Example

TERMINATE with return code zero on a specific record.

IF (SOURCE.KEY = '123456789')

{

   TERMINATE(0)

}

 

TERMINATE with return code zero on the first record with a certain field value

IF (SOURCE.FIELD = 'X')

{

   TERMINATE(0)

}

 

TERMINATE with return code 8 after 5 records

IF (V_COUNT = 5)

{

   TERMINATE(8)

}