Customizing the Interplex Environment

Obtaining the Number of Rows Updated or Deleted

How to:

Obtain the Number of Rows Updated or Deleted

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

Tip: You can change this setting manually or from the Web Console by clicking Data Adapters on the menu bar, clicking a configured adapter, and choosing Change Settings from the menu. The Change Settings pane opens.

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

ENGINE SQLIPX SET PASSRECS {ON|OFF}

where:

SQLIPX: Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
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.

	WebFOCUS