Database Operations & Modes

INZ (initialise)

VLDA (validate for add)

ADD (validate & add)

This is performed to render the screen.  Set initial values based on the template defaults. All values are returned except system generated values which is obtained at the end of update.

Accepts the input parameters and validates the whole record for add. Mandatory values must be passed except fields that can be defaulted. As this a stateless operation, any field values not passed will be retrieved again from the template, similar to INZ.

Validates the whole record and if okay then adds. Similar to VLDA except the database is now updated. Values generated by the system after record is added will be available for output.

RTV (retrieve with lock)

VLDU (validate for update)

UPD (update & release)

Lock ID must be passed with “*” to signify the intention to lock for update. The system will assign a lock ID, and create a lock entry in the generic lock entry file (with database key value together with the whole record value, and last logged time).  The lock ID is required for all other subsequent update operations. Lock will expire if there is no activity in the specified time frame as defined in control file ********/RTN-LCK.

This is similar to VLDA, except Lock ID is required as well. This will ensure the record remain locked by updating the last logged time

This is similar to VLDA, except Lock ID is required as well.  The database is now updated and lock released. 

RTV (retrieve without lock) 

VLDU (validate for update)

UPD (update)

Retrieves/loads values based on the input parameters. Lock ID must be blank to specify no lock. 

Accepts the input parameters ( without Lock ID) and validates the whole record for update. 

Validates the whole record and if okay then updates the record. No Lock ID is required.

RTV (retrieve with lock)

DLT (delete & release)

Lock ID must be passed with “*” to signify the intention to lock for update. The system will assign a lock ID, and create a lock entry in the generic lock entry file (with database key value together with the whole record value, and last logged time).  Lock ID is required for all other delete operations. Lock will expire if there is no activity in the specified time frame as defined in control file ********/RTN-LCK.

Lock ID is required. The database is now updated and lock released.

RTV (retrieve without lock)

DLT (delete)

Loads values based on the input parameters. Lock ID must be blank to specify no lock. 

No lock ID ID required. The database is updated.

Note: There are exceptions on deletion for customer & item master records.