Database commands

Use database commands to get information about data definitions and tables.

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)

ENCRYPT PASSWORD

Use ENCRYPT PASSWORD to encrypt a login password for an Oracle GoldenGatedatabase 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> KEYNAME <key>

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 **

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 encrypted passwords, 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

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

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.