Skip to content

SQL-002: Banking network code sequence

Generates the next CODE_NEXTVAL for clsBankingNetworkCode. This sequence value is generated before the corresponding INSERT operation to obtain the primary key.

Classification

Field Value
SQL ID SQL-002
Operation type Sequence
Execution method Inline SQL
Database Oracle*
Schema [unqualified]**
Command type Text
Business object clsBankingNetworkCode
Criteria property CreateSQL
Lifecycle method ``

Parameters

This statement has no input parameters.

Tables

Table Access Columns used
DUAL SELECT NEXTVAL N/A

Sample SQL

SELECT CODE_NEXTVAL FROM DUAL

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\clsBankingNetworkCode.vb