Database commands

1.7.1 CAPTURE TABLEDEFS

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)

1.7.2 ENCRYPT PASSWORD

Use ENCRYPT PASSWORD to encrypt a login password for an Oracle GoldenGatedatabase user and, optionally, supply an encryption key for password lookup. This encryption method defaults to BLOWFISH and cannot be changed at this time. 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> [KEYNAME {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.

KEYNAME {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 KEYNAME superkey2

1.7.3 INFO DDLDEFS

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

1.7.4 INFO FILES

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.