Use database commands to get information about data definitions and tables.
CAPTURE TABLEDEFS
returns information for SQL tables and for Enscribe files when you provide a DICTIONARY
name and RECORD
definition name.
Syntax
CAPTURE TABLEDEFS file_name [, DICTIONARY volume.subvol] [, RECORD record_name] [, OPTIONS command_line_options]
file_name
The fully qualified name of the file or table.
DICTIONARY
volume
.subvol
The volume and subvolume of the Enscribe dictionary. Required for Enscribe files.
RECORD
record_name
The name of the record definition within the Enscribe dictionary. Required for Enscribe files.
OPTIONS
command_line_options
Valid DEFGEN
command-line options. See the chapter on DEFGEN
arguments for more information.
Note:
If the OPTIONS
argument contains EXPANDDDL
parameters, then it overrides the default EXPANDDDL
parameters. Currently the default EXPANDDDL
parameters are:
EXPANDDDL EXPANDGROUPARRAYS NOFIXLONGNAMES MAXCOLNAMELEN 130
Example
CAPTURE TABLEDEFS \PROD.$DATA1.ACCTS.KEYSEQ
The result of the example command is the following display:
Definition for table \PROD.$DATA1.ACCTS.KEYSEQ Record length: 198 Syskey: 0 Columns: 13 TS LARGEINT PK RECNUM INT PK SYSNAME CHAR (8) TEXT CHAR (64) VAL1 LARGEINT VAL2 LARGEINT COL_COMPUTE LARGEINT I16 SMALLINT I32 INT I64 LARGEINT I32_TOTAL INT JTS LARGEINT JTS_TEXT CHAR (64)
Use ENCRYPT PASSWORD
to encrypt a login password for an Oracle GoldenGate database user and, optionally, supply an encryption key for password lookup. To specify the encrypted password in a parameter file, use the LOGON
parameter (see "LOGON").
For more information about Oracle GoldenGate security, see Encrypting a Database Password.
Syntax
ENCRYPT PASSWORD password [ENCRYPTKEY {DEFAULT | keyname}]
password
The login password. The encrypted password is output to the screen. You can copy the encrypted password and paste it into the LOGON
parameter in a parameter file.
ENCRYPTKEY
{DEFAULT
| keyname
}Optional, specifies one of the following:
DEFAULT
Specifies a default encryption key that is randomly generated by Oracle GoldenGate and automatically decrypted on the target system.
keyname
Specifies an encryption key contained in the ENCKEYS
lookup file. Oracle GoldenGate uses the key name to look up the actual password in the file. To use the keyname
option, you must create the ENCKEYS
file on each system (if it does not exist) and create entries in the file for the keys.
Example
ENCRYPT PASSWORD ny14072 ENCRYPTKEY superkey2
Use INFO DDLDEFS
to retrieve information for Enscribe data dictionary definitions.
Syntax
INFO DDLDEFS def_name [, DDLDEFS def_name,...,] DICT subvolume [, DEFSONLY | RECSONLY]
def_name
The name of a DDL definition or record. You can specify def_name
multiple times to display multiple definitions or records. Wildcards are accepted.
DICT
subvolume
The subvolume in which the dictionary is located.
DEFSONLY
Specifies that GGSCI should return only definitions, not records.
RECSONLY
Specifies that GGSCI should return only records, not definitions.
Example
This example lists each DDL record or definition which begins with ACC
, or which ends in REC
from the dictionary located in $DATA3.MYDICT
.
INFO DDLDEFS ACC*, DDLDEFS *REC, DICT $DATA3.MYDICT
Use INFO FILES
to retrieve information about files or tables on the system; then filter the resulting list according to different criteria.
Syntax
INFO FILES file_name, [FILES file_name,...] [,TMF | NONTMF | ENSCRIBE | SQL | EXCLUDELASTDIGIT | CODE file_code | TANDEMFILES | UNSTRUCT]
file_name
A file name or wildcard specification. Multiple entries of file_name
are allowed.
TMF
Returns TMF audited files.
NONTMF
Returns files not audited by TMF.
ENSCRIBE
Returns Enscribe files.
SQL
Returns NonStop SQL tables.
EXCLUDELASTDIGIT
Excludes file names which end in a digit. Use EXCLUDELASTDIGIT
to filter out alternate key files that end in a digit.
CODE
file_code
Returns files with file_code
only. Multiple entries of CODE
are allowed.
TANDEMFILES
Returns NonStop files (file codes between 1 and 1000) only.
UNSTRUCT
Restricts the list to unstructured files.