SQL-011: Update US Bank user

Update an existing row in US_BANK_USER.

Classification

Field	Value
SQL ID	SQL-011
Operation type	Update
Execution method	Inline SQL
Database	Oracle
Schema	Unqualified in library SQL
Command type	Text
Business object	clsUSBankUser
Criteria property	UpdateSQL
Lifecycle method	BeforeUpdate

Parameters

Parameter	Direction	Type	Max length	Description
:FirstName	Input	clsSmartString / String	30	Updated first name.
:LastName	Input	clsSmartString / String	30	Updated last name.
:TransferBankAccountsFlag	Input	String	1	Updated Y/N transfer flag.
:USBankUserSeqNum	Input	Decimal	N/A	Primary key used in the WHERE clause.

Tables

Table	Access	Columns used
US_BANK_USER	UPDATE	FIRST_NAME, LAST_NAME, TRANSFER_BANK_ACCOUNTS_FLAG, US_BANK_USER_SEQ_NUM

Sample SQL

UPDATE US_BANK_USER
SET
    FIRST_NAME = :FirstName,
    LAST_NAME = :LastName,
    TRANSFER_BANK_ACCOUNTS_FLAG = :TransferBankAccountsFlag
WHERE US_BANK_USER.US_BANK_USER_SEQ_NUM = :USBankUserSeqNum

Operations and processes

• Register or update a US Bank user
• Persist and retrieve SAIF-side integration records

Business rules

• BR-004: User updates must affect exactly one row

Sources

• Business\SAIF.Business.EPay.USBank\clsUSBankUser.vb