QUERY CONNECT command

The QUERY CONNECT command displays a list of applications and tables that are currently defined in the persistent data store. The output of this command shows the application names, table names, total number of rows recorded for each table, the group the table belongs to, and the current data set that the data is being written to.

Important: The content in this section was created for and applies to the original persistent data store, referred to as PDS V1. A new PDS version (referred to as PDS V2) now exists. PDS V1 will eventually be deprecated.

Syntax

QUERY CONNECT <ACTIVE>

where

ACTIVE
Is an optional parameter that displays only those tables that are active. An active table is one that has been defined and assigned to an existing group, and the group has data sets assigned to it.