Default Formats

This section summarizes the formats available in the GenFormat parameter file as it is shipped.

Format

Description

KEYFORMAT

KEYFORMAT lists the data items (by name and value) for a primary key.

COMMAFORMAT

COMMAFORMAT includes prefix, data, and postfix and is similar to FIXEDFORMAT except that it puts double quotes around alpha items and a comma between all items. This format is suitable for many PC and UNIX import programs.

SNAPSHOTCOMMA

SNAPSHOTCOMMA includes data only, no prefix or postfix. Like COMMAFORMAT, each item is delimited by commas and alpha items have double quotes.

COMMAFORMATQUOTEALL

COMMAFORMATQUOTEALL includes prefix, data, and postfix. Like COMMAFORMAT, each item is delimited by commas. Unlike COMMAFORMAT, all items (alpha or not) are placed in double quotes.

Note: COMMAFORMATQUOTEALL is commented out by default. If you want to use it, you must uncomment it.

FIXEDFORMAT

FIXEDFORMAT includes prefix, data, and postfix. FIXEDFORMAT converts each data item to an EBCDIC representation of a fixed width. This would be similar to a COBOL program moving each field to a PIC ... DISPLAY.

SNAPSHOTFIXED

SNAPSHOTFIXED is the same as FIXEDFORMAT except that only data is included. There is no prefix or postfix.

RAWFORMAT

RAWFORMAT copies the DMSII record as a binary image without any formatting or data item filtering. It provides a datastream that is exactly the same as the data stored on the host. RAWFORMAT is an alias for the default DBFORMAT, which formats records as a binary image of the record as it would appear to a COBOL program.

BINARYFORMAT

BINARYFORMAT copies the binary image of each data item in the record, except for the following:

  • Data items that are not in the filter
  • Text items that have the TRANSLATE option specified for BINARYFORMAT in the GenFormat parameter file

NAMEFORMAT

NAMEFORMAT inserts the name of the data item in front of the value of each data item.

AUDITLOC

AUDITLOC inserts a prefix consisting of the time-of-day, the audit location (AFN, ABSN, Inx), and a change code in front of the record values.

COBOLFORMAT

COBOLFORMAT provides a hook for calling a formatting routine that you write in COBOL. Refer to the DATABridge Programmer’s Reference for more information about COBOLFORMAT.

RSNCOMMA

RSNCOMMA is similar to COMMAFORMAT but uses BIGUID and BIGPUID, the 15-digit versions of UID and PUID, which can accommodate RSN values.

The sample GenFormat parameter file defines additional formats that are commented out with “%*” at the beginning of each line. You can quickly uncomment those formats by replacing the “%*” character sequence with spaces.