With the data maintenance system activitiy you can manipulate data in the database. Basically you can select from all tables and views. JobRouter tables, process tables and subtables are excluded from the selection.
You can perform different kinds of manipulations:
Functions |
Description |
|---|---|
Add |
This function inserts the values you defined into the table columns you selected. |
Edit |
This function changes database values. |
Read |
This function reads database data and makes the available for the process. |
Delete |
This function deletes data from the database. |
You can make the following settings:
Setting |
Description |
|---|---|
Select connection |
Here you can access all database connections defined for the process. |
Select table |
As soon as you have selected a connection, this drop-down list is updated and you can select a table or view as a destination. |
Fixed subtable |
If you select a subtable from the process, it will be processed row by row - the chosen function will be executed for each row using the data from this row for the mapped input and output parameters. The subtable will be permanently connected to all parameters with subtable source type.
If you don't select a fixed subtable, you can link the desired input and output parameters manually with a subtable. In this case only the values of the first row will be used for input parameters. Please note: If the chosen fixed subtable is empty, the selected function won't be executed. |
Please note: Database fields with space in name are not supported as parameters in the system activity.
You can assign the following input parameters:
Input parameter |
Description |
|---|---|
New values |
If you selected the functions Add or Edit you can define here any number of new values. Here you can use the function [jr_increment]. |
Search filter |
With the search filter you can define the criteria for the database search. Please ensure that the search filters are linked with AND. |
Maximum number of hits |
For the functions Edit, Read and Delete you can define the maximum number of data records, which can be manipulated. If you can't limit the number of hits, insert the value -1 here. |
You can set the following output parameters:
Output parameter |
Description |
|---|---|
Return value |
If the performance was successful, this field stays empty. Otherwise -1 is displayed. You determine the place, where this feedback will be shown. |
Error message |
Determine the place, where the error messages, occurred during the performance of the function, shall be stored. |
Output values |
For the function Read you can determine in which ressource (process table or subtable) the delivered data from the database shall be written.
Please note: If you fill an empty subtable with the function Read the fix subtable in the tab General Settings may not be set. |
[jr_increment] |
When you insert in the functions Add and Edit the function [jr_increment] the generated IDs will be rewritten here. |
Please note: If you use new values in this system activity, you can access only variables available in this system activity. With [jr_increment] the highest value will be identified for Integer columns in the database. This new value will be increased by 1 and the current data record will be inserted with this new number in the database.
