Reviewing SQL Updates to VSAM Data Sources

How to:

Reference:

The Adapter for VSAM supports SQL INSERT, UPDATE, and DELETE operations against VSAM data sources for use in accessing and maintaining legacy systems. This facilitates development and implementation of new applications based on VSAM data sources.


Top of page

x
Reference: Obtain Counts of Rows Updated or Deleted

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 Count Records Updated, Inserted or Deleted
*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.


iWay Software