Database Mass Update
It is possible to create, using the system transactions management, a transaction code that is used to carry out a mass update (modification, deletion of information in the database), after an optional phase of associated parameter entry. Described below is the function for carrying out the execution of these transactions.
Indeed, the parameterization function of system transactions enables a mass update of the data of any table. The coherence rules linked to the application are not controlled ; it is a maintenance tool.
It is therefore advisable to :
- be extremely prudent when creating such transactions
- only give access to this function to certain users.
- use access codes to protect each system transaction to correctly filter those that could be accessible to certain users.
Prerequisite
Refer to documentation Implementation
Screen management
Entry screen
Presentation
The opening screen is used to enter the code of the system transaction, along with the linked parameters. Once the code has been entered, the function is launched, either in test or in real mode.
A trace is displayed when the function execution is completed : it gives the list of the modified lines.
Close
Fields
The following fields are present on this tab :
Block number 1
| This code identifies the system transaction to be launched. |
| Title associated to the previous code. |
Block number 2
| If this box is checked, the transaction is carried out without any table being updated, and the trace mentions which data would be updated if the process were launched in real mode. It is possible to set a maximum number of transactions to be processed. |
| In test mode, this field limits the number of processed table lines. |
| Name of each variable which can be entered as system transaction parameter. |
| It defines the values associated with the transaction parameters when said transaction is being carried out. |
Close