DB2 Edit Result Table Row (5.5.5)

The DB2 Edit Result Table Row screen (5.5.5) lets you edit data in a single row of a Db2 result table. Data in all columns of the row may be updated. If you are unauthorized to update a column per Db2 security, the contents of the column are protected to prevent you from modifying it.

Access this screen by using the S (Select) line command to select a Db2 result table row from the DB2-Browse-Result-Table-5-5-4 screen.

DB2 Edit Result Table Row Screen (5.5.5)

Input Field

Line command field

A line command field is left of each COLUMN NAME entry. If the field is protected, you cannot use line commands when any of the following conditions apply:

• You have not been granted UPDATE authority for the column.
• The column has NOT been defined as being set to the NULL value AND it is numeric, i.e. INTEGER, FLOAT, or DECIMAL.

If the field is unprotected, you may enter the following line commands.

• N (Null): Sets the column to the NULL value, if allowed by predefinition.
• C (Composite Column): Provides edit support for DATE, TIME, TIMESTAMP, CHARACTER, or GRAPHIC columns. Use this support when the 300-column limit is too restrictive or if you have a column containing kanji data. For further information, see Update DB2-Edit-Composite-Column-5-5-6 screen.

VALUE

For information on modifying data in this area, see VALUE.

Output Fields

CREATOR

Name of the creator of the Db2 result table being displayed.

TABLE

Name of the Db2 result table being displayed.

ROW xxxxx OF yyyyy

Displays the current top row (xxxxx) within the total rows (yyyyy) of columns from the table that are available for display on this screen. The yyyyy value is the number of columns contained in each row of the result table.

POSITION xxxxx OF yyyyy

Displays the current leftmost position of data being displayed.

COLUMN NAME

Name of a column within the Db2 table being accessed.

ATTRIBUTES

Display only field that provides the attributes associated with the column named in the COLUMN NAME field.

• SMALLINT: Whole numbers in the range -32768 to +32767.
• INTEGER: Whole numbers in the range -2147483648 to +2147483647.
• DECIMAL(xx,yy): Value having up to 31 significant digits. Subfield xx specifies the total number of significant digits, and subfield yy specifies the number of digits to the right of the decimal point.
• FLOAT: Single precision floating point value in the range 5.4E-79 to 7.2E+75.
• LONGFLT: Double precision floating point value in the range 5.4E-79 to 7.2E+75.
• CHAR(xxx): Fixed length string of xxx characters, where xxx has a maximum value of 254.
• VARCHAR(xxx): Variable length string of up to xxx characters, where xxx has a maximum value of 254.
• LONGVAR(xxxxx): Variable length string of up to xxxxx characters. Value xxxxx is calculated by Db2 and may be as high as 32K.
• GRAPHIC(xxx): Fixed length string of xxx two-byte characters, where xxx has a maximum value of 127. This is used for data such as kanji.
• VARG(xxx): Variable length string of xxx two-byte characters, where xxx has a maximum value of 127. This is used for data such as kanji.
• LONGVARG(xxxxx): Variable length string of up xxxxx two-byte characters. Value xxxxx is calculated by Db2 and may be as high as 16K. This is used for data such as kanji.
• DATE: Ten position date format value. The actual format is user-defined.
• TIME: Fifteen position time format value. The actual format is user-defined.
• TIMESTMP: Data in time-stamp format, yyyy-mm-dd-hh.mm.ss.nnnnnn where:
  • yyyy: year
  • mm: month
  • dd: day
  • hh: hour
  • mm: minute
  • ss: second
  • nnnnnn: nano-second.

VARLEN OR NULL

Applies to variable length columns such as VARCHAR or VARGRAPHIC or to any column that may be set to the NULL value.

For any column that may be set to the NULL value, this field displays NULL if it is null, and the modifiable data portion of this column displays the NULL display character (default is @) set on the DB2-Setup-5-5-0 screen.

For variable length columns, this field contains the current length of the data shown in the VALUE field. This may range from 0 to the maximum length of the defined column. If the value of the column displayed is NULL, the VARLEN OR NULL field contains the literal NULL.

VALUE

Contains the current data for the columns in the row selected on the DB2-Browse-Result-Table-5-5-4 screen.

Data in the column must be entered in the correct format for the column. Numeric columns (INTEGER, DECIMAL, or FLOAT) may be entered in any valid numeric format. A FLOAT value may be entered in an INTEGER column, however, data conversions will be performed and truncation may take place according to Db2 numeric conversion rules. If a numeric value contains invalid data or data that does not allow proper conversion, an error is issued and the field highlighted.

For CHARACTER or GRAPHIC columns, leading and trailing end-of-string delimiters must not be entered. Variable length fields require the use of the variable length column, end-of-string, and truncate trailing blank parameters specified on the DB2-Setup-5-5-0 screen.

If the column contains unprintable characters, you may use the HEX ON command to go into vertical hex mode where data may be modified in vertical hex format. If you use composite columns, such as redefining the attributes of a column within a COBOL program, or you have a column containing kanji data, you may wish to use the C (Composite Column) line command to transfer control to the DB2-Edit-Composite-Column-5-5-6 screen for editing of data within the column.