The pdrdrefls command displays information about related RDAREAs.
The pdrdrefls command has the following two functions:
HiRDB administrator
pdrdrefls [-k dsp] -e org |
pdrdrefls -k chk -e org {-r RDAREA-name[,RDAREA-name]...|-r ALL} |
Specifies the function of the pdrdrefls command that is to be executed.
This option is fixed.
Specifies the names of the RDAREAs to be processed. Note that only user RDAREAs (excluding temporary table RDAREAs) and user LOB RDAREAs can be specified.
For the rules for specifying RDAREAs, see 1.5.2 Specification of RDAREAs in operation commands and utilities.
Specifies that all user RDAREAs (excluding temporary table RDAREAs) and user LOB RDAREAs are to be processed.
Specifies the name of a table to be processed.
When the authorization identifier is omitted, the command assumes the authorization identifier of the PDUSER environment variable at the time of command execution. If the PDUSER environment variable has not been set, the command assumes the user name in the logon window.
If the authorization identifier and table identifier are enclosed between \"" and "\", they are treated as being case sensitive; otherwise, they are treated as being in all uppercase letters.
Specifies the names of servers to be processed. You can specify a maximum of 128 server names.
When -k dsp is specified, the command displays only information that has been defined in the specified servers.
When -k chk is specified, the command checks to see whether all the RDAREAs specified in the -r option have been defined in the specified servers. If any of the RDAREAs specified in the -r option does not satisfy this condition, the command displays the applicable RDAREA name in a message and then terminates with an error.
You can check the server names to be specified using pddbst's condition analysis in units of RDAREAs (logical analysis) or in units of tables.
Specifies that the output information is to be displayed without linefeeds.
Specifies a single-byte character as the delimiter for the information that is output when the -l option is specified.
When this option is omitted, the command assumes a space.
To specify a special character as the delimiter, such as a single quotation mark (') or double quotation mark ("), specify \' or \". To specify the escape character as the delimiter, specify \\.
Specifies that all related information (server names, RDAREA names, RDAREA types, and resource information) is to be displayed. When this option is omitted, the command display only the RDAREA names.
Specifies that referential RDAREA information associated with referential constraints is to be displayed or checked.
This example displays information about related RDAREAs. The example omits the -d option. In the execution result, indicates a single-byte space.
SERVER NAME : BES1
RDAREA NAME : "RD01"
AREA TYPE : USER
RESOURCE : TBL : "user1"."TBL1"
"user2"."TBL2"
"user1"."TBL3"
IDX : "user1"."IDX1"
("user1"."TBL1")
"user1"."IDX3"
("user1"."TBL3")
RDAREA NAME : "RD02"
AREA TYPE : USER
RESOURCE : TBL : "user2"."TBL2"
"user1"."TBL3"
IDX : "user2"."IDX2"
("user2"."TBL2")
"user1"."IDX3"
("user1"."TBL3")
RDAREA NAME : "RD04" -
AREA TYPE : USER |
RESOURCE : TBL : "user1"."TBL4" |-#
-><"user1"."TBL1"> |
IDX : "user1"."IDX4" |
("user1"."TBL4") -
RDAREA NAME : "LOB01"
AREA TYPE : USER_LOB
RESOURCE : LOB : "COL1"
("user1"."TBL1")
RDAREA NAME : "RD01"
RDAREA NAME : "RD02"
RDAREA NAME : "RD04" #
RDAREA NAME : "LOB01"
BES1"RD01"
USER
TBL
"user1"."TBL1"
BES1"RD01"
USER
TBL
"user2"."TBL2"
BES1"RD01"
USER
TBL
"user1"."TBL3"
BES1"RD01"
USER
IDX
"user1"."IDX1"
"user1"."TBL1"
BES1"RD01"
USER
IDX
"user1"."IDX3"
"user1"."TBL3"
BES1"LOB01"
USER_LOB
LOB
"COL1"
"user1"."TBL1"
BES1"RD02"
USER
TBL
"user2"."TBL2"
BES1"RD02"
USER
TBL
"user1"."TBL3"
BES1"RD02"
USER
IDX
"user2"."IDX2"
"user2"."TBL2"
BES1"RD02"
USER
IDX
"user1"."IDX3"
"user1"."TBL3"
BES1"RD04"
USER
TBL
"user1"."TBL4"
"user1"."TBL1" #
BES1"RD04"
USER
IDX
"user1"."IDX4"
"user1"."TBL4" #
"RD01""RD02"
"LOB01"
"RD04" #
SERVER NAME : BES1
RDAREA NAME : "RD02"
AREA TYPE : USER
RESOURCE : TBL : "user2"."TBL2"
"user1"."TBL3"
IDX : "user2"."IDX2"
("user2"."TBL2")
"user1"."IDX3"
("user1"."TBL3")
RDAREA NAME : "RD01"
AREA TYPE : USER
RESOURCE : TBL : "user1"."TBL1"
"user2"."TBL2"
"user1"."TBL3"
IDX : "user1"."IDX1"
("user1"."TBL1")
"user1"."IDX3"
("user1"."TBL3")
RDAREA NAME : "RD04" -
AREA TYPE : USER |
RESOURCE : TBL : "user1"."TBL4" |-#
-><"user1"."TBL1"> |
IDX : "user1"."IDX4" |
("user1"."TBL4") -
RDAREA NAME : "LOB01"
AREA TYPE : USER_LOB
RESOURCE : LOB : "COL1"
("user1"."TBL1")
SERVER NAME : BES2
RDAREA NAME : "RD03"
AREA TYPE : USER
RESOURCE : TBL : "user1"."TBL3
IDX : "user1"."IDX3"
("user1"."TBL3")
SERVER NAME : BES1
RDAREA NAME : "RD04"
AREA TYPE : USER
RESOURCE : TBL : "user1"."TBL4"
-><"user1"."TBL1"> #
IDX : "user1"."IDX4"
("user1"."TBL4")
RDAREA NAME : "RD01" -
AREA TYPE : USER |
RESOURCE : TBL : "user1"."TBL1" |
"user2"."TBL2" |
"user1"."TBL3" |
IDX : "user1"."IDX1" |
("user1"."TBL1") |
"user1"."IDX3" |
("user1"."TBL3") |
RDAREA NAME : "RD02" |-#
AREA TYPE : USER |
RESOURCE : TBL : "user2"."TBL2" |
"user1"."TBL3" |
IDX : "user2"."IDX2" |
("user2"."TBL2") |
"user1"."IDX3" |
("user1"."TBL3") |
RDAREA NAME : "LOB01" |
AREA TYPE : USER_LOB |
RESOURCE : LOB : "COL1" |
("user1"."TBL1") -