INFO PARAM
Use INFO PARAM
to retrieve the parameter definition
information. If a name matches multiple records, they are all displayed. If the
query parameter has child options, they are not displayed in the output though their
names are listed in the Options tab. To display the full record of an option, the
full name in the form of parameter.option
should be queried
separately.
This parameter infrastructure allows unlimited levels of options. So, the full name of a parameter or option might have numbers of segments, such as A.B.C.D.
Syntax
INFO PARAM name
Example 1
The following example uses GETINSERTS
with INFO
PARAM
along with the output.
INFO PARAM GETINSERTS
param name : getinserts
opposite : ignoreinserts
description : Include insert records.
argument : boolean
default : true
component(s): EXTRACT - All
: REPLICAT - All
platform(s) : All
database(s) : All
status : current
mandatory : false
dynamic : false
relations : none
Example 2
The following example uses the DBOPTIONS.DEFERREFCONST
with
INFO PARAM
to show how to get specific details about a
parameter option.
INFO PARAM DBOPTIONS.DEFERREFCONST
param name : dboptions.deferrefconst
description : Sets constraints to DEFERRABLE to delay the checking and enforcement of cascade delete and cascade update referential integrity constraints by the Oracle target database until the Replicat transaction is committed.
component(s): REPLICAT - All
platform(s) : All
database(s) : Oracle 11g
: Oracle 12c
: Oracle 18c
: Oracle 19c
: Oracle 21c
status : current
mandatory : false
dynamic : false
relations : none