You can specify an insertion condition for every selected source table. This way you instruct the Merger Utility to insert every selected source row of the selected source table, which complies with the table’s insertion condition. Note that the insertion condition affects only the source tables that you have selected to be merged.
The insertion condition can contain any combination of the following:
-
Source columns
-
Operators or functions
-
Alphanumeric values
The insertion condition affects only the source tables which you have selected to be merged.
-
On the Advanced Selection dialog, select the check box under the Insert Only column for the selected table.
-
Use the horizontal scroll bar to display the pertinent section of the dialog.
-
Selecting the check box under the Insert Only column causes the Merger Utility to insert any source rows (of the selected source table) which comply with the condition specified in the adjacent Condition column.
-
-
Under the Condition column, type the appropriate insertion condition.
Make sure you type the appropriate condition, as this will affect the merge process results.
The Merger Utility provides you with the following inherent operators and functions.
Operator / Function |
Descriptions |
Example |
---|---|---|
= |
Equal to |
cpmnt_mfr = 'Shell' |
> |
Greater than |
cmpnt_name > '101' |
< |
Less than |
item_price < 100 |
>= |
Greater or equal to |
num >= 10 |
=< |
Less than or equal to |
item_price =< 30 |
<> |
Not equal to |
prefix <> 'AA' |
AND |
Include the following expression in the filter combination |
name AND num <> 0 |
OR |
Accept either the previous or the following expression in the filter combination |
Loop OR line = '' |
NOT |
Select the value opposite to the following expression |
NOT (item_price = 0) |
LIKE |
Select a value that is similar to the one in the ‘%[value]%’ field |
cmpnt_name LIKE '%AA%' |
IN |
Select a value that is equal to one of those specified in the parentheses |
cpmnt_name = IN ('101','103' |
BETWEEN |
Select a value which is within the following interval |
item_price BETWEEN 100 AND 500 |
IS NULL |
Equal to NULL |
Loop IS NULL |
IS NOT NULL |
Not equal to NULL |
line IS NOT NULL |
The above operators and functions are those used in the WHERE string of the SQL statement.
When a table is defined on a specified level, it contains data which is unique on that specified level. For example, the CABLE Table is defined per area. Therefore, the CABLE Table contains data that is unique only on the area level of the domain.