Skip to content

SQL-093: clsOutputControl delete

Deletes an output control record from OUTPUT_CONTROL.

Classification

Field Value
SQL ID SQL-093
Operation type Delete
Execution method Inline SQL
Database Oracle*
Schema [unqualified]**
Command type Text
Business object clsOutputControl
Criteria property DeleteSQL
Lifecycle method BeforeDelete / AfterDelete

Parameters

Parameter Direction Type Max length Description
:OutputControlSeqNum\ Input Decimal — Binds \MyCriteria.OutputControlSeqNum*

Tables

Table Access Columns used
OUTPUT_CONTROL Write —

Sample SQL

Delete OUTPUT_CONTROL
Where OUTPUT_CONTROL.OUTPUT_CONTROL_SEQ_NUM = :OutputControlSeqNum

Operations and processes

Note: Statements marked with * were inferred from code structure, naming conventions, or contextual evidence where direct confirmation was not available in source artifacts. Statements marked with ** could not be confirmed; treat as unknown until verified.

Sources

  • Business\SAIF.Business.Payment.EFT\clsOutputControl.vb