How to: |
The Adapters for Micro Focus C-ISAM and Informix C-ISAM support SQL INSERT, UPDATE, and DELETE operations against C-ISAM data sources. This facilitates development and implementation of new applications based on C-ISAM data sources.
While processing SQL transactions, you can issue the PASSRECS command to obtain counts of rows affected by each successfully executed SQL Passthru INSERT, UPDATE, or DELETE command.
ENGINE INT SET PASSRECS {ON|OFF}
where:
Indicates that the PASSRECS setting in this command will be applied globally to all adapters that support SQL INSERT, UPDATE, and DELETE commands.
Provides the number of rows affected in the application program SCB count member after the successful execution of an SQL Passthru INSERT, UPDATE, or DELETE command. ON is the default value.
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.
WebFOCUS |