Skip to main content

Where conditions

By default the whole table will be processed. If it is necessary to process only parts of the table, you can reduce the amount of processed data by specifying a "where condition".

Click on a table in the list and enter a "where condition" in the input field below. The small "i" button right from the table offers a list of the table fields. A doubleclick on a line transfers the field name and a value pattern to the input field for the where condition. Afterwards click on "Replace" to add the where condition to the list above.

Example:
"OBJECT" = 'SO_OBJ_USR'

Do not place the word "where" in front of the where condition, this will be done implicitely in case the where condition is not empty.

Notice that there is no syntax check. If the syntax is wrong, the R3trans operation will end with RC 12.

####