- When you do a transfer, the first thing the system checks is whether all the key field values for the target component are provided.
- If all the keys aren't provided, the search page is displayed. In this scenario, TransferExact and Transfer are the same.
-
If all the keys are provided, a Select
is done against the search record for that component using those keys.
- If you use the Transfer function, a LIKE operator is used in the Where clause of that Select for each key.
-
If you use the TransferExact fuction,
the equals operator is used in the Where clause for each key. Using equals
allows the database to take full advantage of key indexes for maximum
performance.
