SQL/MX 3.2.1 Reference Manual (H06.26+, J06.15+)

SQL/MX Functions and Expressions
HP NonStop SQL/MX Release 3.2.1 Reference Manual—691117-004
8-144
RELATEDNESS Function
RELATEDNESS Function
RELATEDNESS is a built-in table-valued function that returns relatedness information
for a single entity.
Table 8-3 shows the input and output parameters for RELATEDNESS.
ANSI names in the input value parameter must be fully qualified in external format.
Expand node names are case-insensitive. Both input parameters must be
character-valued expressions.
Example of RELATEDNESS
select * from table (relatedness ('SCHEMA', 'CAT.SCH'));
E_TYPE E_VALUE NAME
------- --------- ----------------------
SCHEMA CAT.SCH CAT.SCH
SCHEMA CAT.SCH OTHERCAT.OTHERSCH
SCHEMA CAT.SCH YET_ANOTHER_CAT.SCHEMAX
relatedness ('
E_TYPE', 'E_VALUE')
Table 8-3. Input and Output Parameters for RELATEDNESS
Input/Output
Type Parameter Specification Description
Input
parameter
E_TYPE CHAR (32) NOT
NULL
The type of version information that
is requested.
Input
parameter
E_VALUE VARCHAR(517)
NOT NULL
The name of the entity for which
version information is requested.
The type of that entity is implied by
E_TYPE.
Output
column
E_TYPE CHAR (32) NOT
NULL
A copy of the actual value for the
E_TYPE input parameter.
Output
column
E_VALUE VARCHAR(517)
NOT NULL
A copy of the actual value for the
E_VALUE input parameter.
Output
column
NAME VARCHAR(517)
NOT NULL
The name of a related entity.