When the link is a literal value, a relationship forms when CA Dataquery finds the named literal value in the named key or column of table2. CA Dataquery creates one composite record in the active found set for each row in table1 plus the rows in table2 containing the literal.
Query
The following sample RELATED BY clause has a literal value as the link.
FIND ALL TABLE1 RECORDS
RELATED BY 'SMITH' VIA KEY2 TO TABLE2
Literal Value Link Example
Note: If more than one occurrence of the literal appears in table2, every row in table1 will be repeated once in the active found set for each occurrence found in table2. For example, if ten rows are found in table1 and the literal occurs twice in table2, the composite rows in the active found set will number twenty.
|
Copyright © 2014 CA.
All rights reserved.
|
|