DBRELATION()

Purpose

Function to return table-linking expression

Syntax

DBRELATION(<expN>)

See Also

CREATE VIEW, DBRSELECT(), RELATION(), SET RELATION, TARGET(), USE

Description

The DBRELATION() function is synonymous with the RELATION() function. The DBRELATION() function returns the linking expression of a specified relation in the current workarea. The <expN> specifies the position of the desired linking expression from the list of previously defined relations. The DBRELATION() function always returns a character string in lower case. If there is no linking expression defined for the <expN> selected a null string will be returned.

Example

use shows in 2 index pcode
use patrons in 1
set relation to patron_code into shows
? dbrelation(1)
patron_code
? target(1)
         2