ODBC Programmer Reference › Retrieving Network Set Information

Retrieving Network Set Information

You can use the SQLExecuteDirect function with the following syntax to return information about network sets used to join network records accessed as SQL tables.

$SETS owner  table  table

The parameters are as follows:

owner

Specifies the name of the SQL schema containing the names of the dictionary and network schema where the records are defined. This value applies to all tables and appears to the ODBC application as the TABLE_OWNER returned by SQLTables.

table

Specifies the name of a record in the network schema. Enter from zero to two table arguments. Each table argument must be unique and must be defined in the same network schema. This value appears to the ODBC application as the TABLE_NAME returned by SQLTables.

The owner and table name arguments are case-sensitive. The following list identifies the contents of the result set, which depends on what you specify for the table arguments:

• If you specify no table arguments, the result set contains a list of all sets in the network schema referenced by owner
• If you specify one table argument, the result set contains a list of all sets in the network schema referenced by owner in which table is either the owner or a member
• If you specify two table arguments, the result set contains a list of all sets in the network schema referenced by owner between the two tables, where either is the owner or member

The result columns are described in the following table. All columns are defined as VARCHAR(18):

SET_NAME

Network set name

SCHEMA_NAME

SQL schema name (ODBC owner)

OWNER_NAME

Network owner record name (ODBC table)

MEMBER_NAME

Network owner record name (ODBC table)