DB2 Edit Composite Column (5.5.6)

Related Tpoics

The DB2 Edit Composite Column screen (5.5.6) lets you edit data in a column of the Db2 result table. Composite columns are defined in Code Debug CICS as DATE, TIME, TIMESTAMP, CHARACTER, or GRAPHIC columns that are redefined by a user in an application program.

The USING command can be used on this screen to specify an 01 level COBOL or PL/I dataname for mapping new attributes for the column using the COBOL attributes of the dataname.

Access this screen by using C (Composite Column) line command to select a column on the DB2-Edit-Result-Table-Row-5-5-5 screen.

DB2 Edit Composite Column Screen (5.5.6)

---------------------- DB2 EDIT COMPOSITE COLUMN (5.5.6) -----------------C024
COMMAND ===>                                                   SCROLL ===> CSR
MODULE:          CSECT:
VALID COMMANDS: CANCEL   FIND   LOCATE   END

CREATOR: CWX0030 TABLE: COMPOSITE_TABLE    COLUMN NAME:   VARCHAR_FIELD

DEC-OFFSET: 000000 ADD-OFFSET: 000000       COLUMN LENGTH: 00088

----+---10----+---20----+---30----+---40----+---50----+---60----+---70----+-->
GEORGE    PDOS EQUUS           ...>059JUST AN ORDINARY GIRL
----+---10----+---20----+---30----+---40----+---50----+---60----+---70----+-->

Data Display Modes

You can display the actual column data in one of four modes which lets you view and modify data easily. Each mode supports different scrolling commands to ease positioning within the column. File Utility Scrolling Commands table shows the modes and corresponding scrolling commands.

Input Fields

Two offset fields let you position to data within the column being edited.

HEX/DEC-OFFSET

Displays the current offset within the column’s data. This value is always relative to 0. The data display begins at this offset. This field may be modified. The value entered must be in the range of 0 to the decimal value displayed in the COLUMN LENGTH field. When HEX-OFFSET is displayed, the value will be between 0 and the hexadecimal equivalent of the decimal value displayed in the COLUMN LENGTH field. In addition, when DEC-OFFSET is displayed, a hexadecimal value with a leading positive (+) sign may be entered instead, e.g. 80 or +50 are equivalent.

Important

The HEX/DEC-OFFSET field is protected (non-modifiable) when the USING command is in effect.

ADD-OFFSET

Used in conjunction with the HEX/DEC-OFFSET field to provide a new starting offset into the columns data. The value entered into this field is added, or subtracted if a leading negative (-) sign is present, to the value in the HEX/DEC-OFFSET field to yield a new starting offset value.

If the display mode is dump (HEX DUMP), only hexadecimal values may be entered. If the display mode is character (HEX OFF) or vertical hex (HEX ON), the value may be entered either in decimal or hexadecimal. This can be done by preceding the value with a positive (+) sign. To add a negative offset, simply precede the value by a negative (-) sign.

Important

The ADD-OFFSET field is protected (non-modifiable) when the USING command is in effect.

Output Fields

CREATOR

Displays the creator of the Db2 result table.

TABLE

Displays the name of the Db2 result table.

COLUMN NAME

Displays the column name.

COLUMN LENGTH

Displays the maximum length of data within the column.