Maintaining C-ISAM Data Sources Using SQL Commands

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.


Top of page

x
Syntax: How to Obtain the Number of Records Updated, Inserted or Deleted
x
ENGINE INT SET PASSRECS {ON|OFF}

where:

INT

Indicates that the PASSRECS setting in this command will be applied globally to all adapters that support SQL INSERT, UPDATE, and DELETE commands.

ON

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.

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.


WebFOCUS