Default Option Descriptions
BMC Software, Inc., Confidential and Proprietary Information
Chapter 6 Installing CATALOG MANAGER 6-15
DPT=('.') The decimal point character for CATALOG MANAGER must be a comma or
a period.
DRO=O The Drop Recovery option:
M mandatory
O optional
N not used
EDSN=&&ZUSER..BMCCAT.SQLE
The name of the SQL Explorer product’s errors listing.
EPLAN=ACTvrmDE
The name of the plan that enables access to the data editing and browsing
functions.
ESC='''' The SQL string delimiter. This must be an apostrophe (') or a quotation mark
("). You must select the one that matches the way your DB2 system was
generated. The character that you do not select becomes the SQL escape
character.
FIELDS=STATIC Specifies whether CATALOG MANAGER uses static SQL or dynamic SQL
to access the SYSIBM.SYSFIELDS DB2 catalog table. The default STATIC
uses the privileges of the package owner. DYNAMIC uses the privileges of
the person who is listing the table.
FOREIGN=STATIC Specifies whether CATALOG MANAGER uses static SQL or dynamic SQL
to access the SYSIBM.SYSFOREIGNKEYS DB2 catalog table. The default
STATIC uses the privileges of the package owner. DYNAMIC uses the
privileges of the person who is listing the table.
GRPAT The group attach name for data sharing in a Sysplex. This name is used as
the SSID when JCL for utilities is generated.
HDAL=N Indicates whether to include aliases in the hierarchical describe (Y or N).
HDIX=Y Indicates whether to include indexes in the hierarchical describe (Y or N).
HDSY=N Indicates whether to include synonyms in the hierarchical describe (Y or N).
HDTB=Y Indicates whether to include tables in the hierarchical describe (Y or N).
HDTS=Y Indicates whether to include table spaces in the hierarchical describe
(
Y or N).
HDVW=Y Indicates whether to include views in the hierarchical describe (Y or N).
HDPL=N Indicates whether to include plans in the hierarchical describe (Y or N).
