Scalable Database Server, HiRDB Version 8 Command Reference

[Contents][Index][Back][Next]

pdlistls (Display list definition information)

Function

The pdlistls command displays the list definition information.

Executor

HiRDB administrator

Format

pdlistls [-d {1|2}]
       [-u list-owner's-name]
       [-t list-base-table-owner's-name,list-base-table-name]

Options

Specifies the list definition information to be displayed.

-d option Information to be displayed
Values of system definitions* List owner's name Name of list Number of lists Base table's owner's name Name of base table
1 D D [Figure] D [Figure] [Figure]
2 D D D [Figure] D D

D: Displayed

[Figure]: Not displayed

* Indicates the values of the pd_max_list_users and pd_max_list_count operands.

To display only the specified list owner's list definition information, specify the name of the list owner with this option. If this option is omitted, the system assumes all list owners.

The specified list owner's name is treated as all uppercase letters unless it is enclosed in \".

To display only the specified list base table's list definition information, specify the list base table's owner's name and list base table's name with this option.

A list base table's owner's name can be expressed as 1-8 characters and a list base table's name can be expressed as an identifier consisting of 1-30 characters. The specified list base table's owner's name and list base table's name are treated as all uppercase letters unless they are enclosed in \". If the name contains a space, enclose it in \".

Rules

  1. You can execute the pdlistls command only when HiRDB is active.
  2. Execute the pdlistls command on the server machine containing the single server or the server machine where the system manager is located.

Notes

  1. Return code 0 for the pdlistls command indicates normal termination, and return code 8 indicates abnormal termination.

Output format

Explanation

aa...a
Sequence number displayed

bb...b
List owner's name

cc...c
Number of segments in the list

dd...d
Information that was not found
-t option specified: TABLE
-u option specified: USER

ee...e
Value of the pd_max_list_users operand in the system definitions (for the single server or dictionary server)

ff...f
Value of the pd_max_list_count operand in the system definitions (for the single server or dictionary server)

Explanation

aa...a
Sequence number displayed

bb...b
List owner's name

cc...c
Name of the list

dd...d
List base table's owner's name

ee...e
List base table's name

ff...f
information that was not found
-t option specified: TABLE
-u option specified: USER

gg...g
Value of the pd_max_list_users operand in the system definitions (for the single server or dictionary server)

hh...h
Value of the pd_max_list_count operand in the system definitions (for the single server or dictionary server)