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.
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 |