Returns the alias of a table that is the target for a relation as specified in the INTO clause of SET RELATION.
Syntax
TARGET(nRelationshipNumber [, nWorkArea | cTableAlias])
Returns
Character
Arguments
nRelationshipNumber
Specifies the number of a relationship. Include a number from 1 to the number of relationships out of the specified work area. The aliases of the target databases are returned (in no specific order) until nRelationshipNumber is greater than the number of relationships. When nRelationshipNumber is greater than the number of relationships, the empty string is returned.
nWorkArea | cTableAlias
Returns the alias of the target table in another work area. nWorkArea specifies a work area number and cTableAlias specifies a table alias. By default, the alias of the target table from the current work area is returned if you don't specify the work area or alias.