PASSRECS Setting for Adapter for Adabas

PASSRECS returns the number of rows affected by a successfully executed SQL Passthru INSERT, UPDATE, or DELETE command.

Syntax: How to Obtain the Number of Rows Inserted, Updated, or Deleted

ENGINE ADBSINX SET PASSRECS {ON|OFF}

where:

INT: Indicates that the PASSRECS setting in this command will be applied to the Adapter for Adabas.
ON: Provides the number of rows affected after the successful execution of an SQL Passthru INSERT, UPDATE, or DELETE command. ON is the default value.
OFF: Provides no information after the successful execution of an SQL Passthru INSERT, UPDATE, or DELETE command.

In addition, the adapter updates the &RECORDS system variable with the number of rows affected. You can access this variable using Dialogue Manager.