Display Modes
File-AID for Db2 offers two different methods of browsing and editing object data: Table Mode or Row Mode. Switch between these modes by entering the primary commands: TABLE or ROW. If you are in table mode and would like to see as many columns as possible, enter the ROW command to toggle into row mode. The row that was at the top of the screen displays. You can display a specific row from the table mode screen by typing the ROW command, positioning the cursor on the desired row, and pressing Enter. Conversely, if you are in row mode and would like to switch back to table mode to work with multiple rows of data, enter the TABLE command. The row that was displayed when the TABLE command was entered displays at the top of the screen.
Table Mode
In table mode, each row of data displays in columns listed across the screen. This mode allows you to work with as many rows of data as can be displayed on the screen.
The Edit screen displays in table mode when you either:
- Enter 1, for Table, in the Initial Display Mode field on the Edit Options screen.
- Enter TABLE on the command line on the Edit row mode screen.
- Select TABLE from the VIEWS pull-down menu on the Edit row mode screen.
The table mode screen displays the rows of an object in column format. The TABLE command, when entered on the command line, is cursor sensitive. When going from row mode to table mode, you can position the table mode display at a particular column. Type TABLE, place the cursor on the desired column, and press Enter.
When in Browse, you can only review the data. When in Edit, you can change the data by typing over the body of the screen. Primary commands for table display mode can be entered from the command line or selected from the pull-down menus. Line commands are also available in the line-number area.
Edit screen in Table Mode
-------------------------------------------------------------------------
File-AID for Db2 Edit - USERID.EMP SSID: DSN
COMMAND ===> SCROLL ===> PAGE
LASTNAME FIRSTNAME MIDINIT EMPNO JOB BIRTHDATE
VC(15) VC(12) CHAR(1) CHAR(6) CHAR(8) DATE
--------------- ------------ ------- PRIMARY -------- ----------
****** **************************** TOP OF DATA *****************************
000001 O’CONNELL SEAN 000120 CLERK 1942-10-18
000002 QUINTANA DOLORES M 000130 ANALYST 1925-09-15
000003 NICHOLLS HEATHER A 000140 ANALYST 1946-01-19
000004 ADAMSON BRUCE 000150 DESIGNER 1947-05-17
000005 PIANKA ELIZABETH R 000160 DESIGNER 1955-04-12
000006 YOSHIMURA MASATOSHI J 000170 DESIGNER 1951-01-05
000007 SCOUTTEN MARILYN S 000180 DESIGNER 1949-02-21
000008 WALKER JAMES H 000190 DESIGNER 1952-06-25
000009 BROWN DAVID 000200 DESIGNER 1941-05-29
000010 JONES WILLIAM T 000210 DESIGNER 1953-02-23
000011 LUTZ JENNIFER K 000220 DESIGNER 1948-03-19
000012 JEFFERSON JAMES J 000230 CLERK 1935-05-30
000013 MARINO SALVATORE M 000240 CLERK 1954-03-31
000014 SMITH DANIEL S 000250 CLERK 1939-11-12
000015 JOHNSON SYBIL V 000260 CLERK 1936-10-05
000016 PEREZ MARIA L 000270 CLERK 1953-05-26
Line Number Area
Entry area for line commands. All line commands except M and the SQL Analysis commands EX, XP, BR, and ED are valid for the Edit table mode screen. See Line Commands for details.
Column Headings
- First Line - the column name. The column name is underlined, if it is a Unicode column. An asterisk (*) at the end of the column name indicates the LOB column has been truncated.
- Second Line - column data type:
VC DEC DATE
LVC FLOAT TIME
GRAPH BINARY TMSTMP
VG VARBIN TMESTZ
LVG BIGINT ROWID
SMALLINT DECFL BLOB
CLOB XML
For the data types CHAR, VC, LVC, GRAPH, VG, LVG, DEC, DECFL, BINARY, VARBIN, TMSTMP, and TMESTZ, the length (or precision) is displayed in parentheses.
Third Line - If the column length is less than 19 and the column is not part of an index, dashes are displayed to indicate where the data begins. If the column length is greater than 18 and the column is not part of an index, a ruler displays.
For example: ----+---10----+—2If the column is part of an index, the type of index is shown by the indicators listed below. The index type indicators are available only for local tables.
PRIMARY
Column is part of a primary key.
UNIQUE
Column is part of a unique index. The RETRIEVE UNIQUE KEY INFO option must be set to ON for this heading to display. See PROFILE-PRO for information on setting this option.
FOREIGN
Column is part of a foreign key relationship. The SHOW FOREIGN KEYS option must be set to ON for this heading to display. See PROFILE-PRO, for more information on setting this option.
PRIM+FRGN
Column is part of both a primary key and foreign key relationship.
If the column is an identity column, the type of identity column is shown by the indicators listed below. The identity column type indicators are available only for local tables.
IDENTITY
Column is an identity column.
PR+FR+ID
Column is part of a primary key, a foreign key, and is an identity column.
PRIM+ID
Column is part of a primary key and is an identity column.
UN+IDNT
Column is part of a unique key and is an identity column.
If the column is a Row Change Timestamp column, the indicator ROWCHANGE is displayed.
Column Values
This area displays the data values. Character and graphic fields are left justified. Numeric fields are right justified. Valid values based on data type are listed in the following table.
Valid Values Based on Data Type
Data Type | Valid Value |
|---|---|
CHAR | Fixed-length character strings less than or equal to the field length specified when the column was created. Maximum field length is 255 characters. |
VCHAR | Variable-length character strings less than or equal to the field length specified when the column is created. Maximum allowable field length is 4056 characters. If the column is defined as FOR BIT DATA, the data cannot be successfully edited. |
LVCHAR | Variable-length character strings less than or equal to the field length specified when the column is created. Maximum allowable field length is 4056 characters. If the column is defined as FOR BIT DATA, the data cannot be successfully edited. |
GRAPH | Fixed-length graphic strings less than or equal to the field length specified when the column was created. Maximum field length is 127 DBCS characters. |
VARGRAPHIC | Variable--length graphic strings less than or equal to the field length specified when the column was created. Maximum allowable field length is 4046 bytes (2023 DBCS characters) for 4-KB pages; 8128 bytes (4064 DBCS characters) for 8-KB pages; 16320 bytes (8160 DBCS characters for 16-KB pages; 32704 bytes (16352 DBCS characters) for 32-KB pages. |
LVARG | Variable--length graphic strings less than or equal to the field length specified when the column was created. Maximum allowable field length is 4046 bytes (2023 DBCS characters) for 4-KB pages; 8128 bytes (4064 DBCS characters) for 8-KB pages; 16320 bytes (8160 DBCS characters for 16-KB pages; 32704 bytes (16352 DBCS characters) for 32-KB pages. |
SMALLINT | Fixed-length, binary integers in the range of -32768 to +32767, requiring two bytes of storage. |
INTEGER | Fixed-length, binary integers in the range of -2,147,483,648 to +2,147,483,647, requiring four bytes of storage. |
BIGINT | A binary integer with a precision of 63 bits. The range is -9223372036854775808 to +9223372036854775807. |
BINARY | A fixed-length binary string with a length attribute of 1- 255. |
VARBIN | A varying length binary string with a length attribute of 1 – 32704. |
DEC | Fixed-length, decimal numbers in the range of -10E15 to +10E15. |
FLOAT | Fixed-length, floating-point numbers in the approximate range of -7.2E75 to +7.2E75. |
DECFLOAT(n) | Decimal Floating Point can be either DECFLOAT(8) or DECFLOAT(16) representing either 16 or 34 significant digits. The range of a DECFLOAT(8) number is 10-383 to 10+384 and the range of a DECFLOAT(16) number is 10-6143 to 10+6144. A DECFLOAT(8) field occupies 8 bytes and a DECFLOAT(16) occupies 16 bytes. The abbreviation DECFL(n) is used in Table and Row mode displays and Print reports. |
DATE | A three-part value (year, month, day), whose format is determined by Db2. |
TIME | A three-part value (hour, minute, second), whose format is determined by Db2. |
TMSTMP(n) | TIMESTAMP: A seven-part value (year, month, day, hour, minute, second, and precision) whose format is YYYY-MM-DD-HH.MM.SS.TTTTTTTTTTTT. The precision value (TTTTTTTTTTTT) is variable length and has 0 to 12 digits (up to picosecond) with a default of 6 (microsecond). TMSTMP(n) specifies the scale (length) with n = 0 through 12. For Db2 Versions prior to Version 10, the length is always 6. |
TMESTZ(n) | TIMESTAMP WITH TIME ZONE: An eight-part value (year, month, day, hour, minute, second, precision, time zone) whose format is YYYY-MM-DD-HH.MM.SS.TTTTTTTTTTTT±HH:MM. The precision value (TTTTTTTTTTTT) is variable length and has 0 to 12 digits (up to picosecond) with a default of 6 (microsecond). The time zone is the difference in hours and minutes between local time and UTC. The range of the hour offset is -12 to +14, and the minute offset is 00 to 59. The time zone is specified in the format ±th.tm, with values ranging from -12.59 to +14.00. TMESTZ(n) specifies the scale (length) with n = 0 through 12. |
DISTINCT | Distinct is identified by its name. A Distinct type is based on one of the built-in data types. Use the UDT primary command (see UDT) to view the Distinct type, schema, and the built-in data type. |
ROWID | Uniquely identifies a row in a table. Each value must be unique. Generated by Db2.Length as described in the LENGTH column of the catalog table SYSCOLUMNS is the internal length, 17 bytes. Length as described in the LENGTH2 column of catalog table SYSCOLUMNS is the external length, 40 bytes. |
CLOB | A character large object (CLOB) is a varying-length string with a maximum length of 2 147 483 647 bytes (2 gigabytes minus 1 byte). |
DBCLOB | A double-byte character large object (DBCLOB) is a varying-length string with a maximum length of 1 073 741 823 double-byte characters. |
XML | A data type for storage of well formed XML documents. |
BLOB | A binary large object (BLOB) is a varying-length string with a maximum length of 2 147 483 647 bytes (2 gigabytes minus 1 byte). |
Values in Unicode columns are the data converted from Unicode to terminal CCSID EBCDIC-based data, using IBM z/OS Conversion Services. The converted data may contain non-displayable characters based on your terminal CCSID.
For a Browse session, a non-displayable character is replaced by the non-displayable character value provided in Option 0, Defaults and User Parms. For an Edit session, a non-displayable character is replaced by an ISPF attribute that appears as a blank and cannot be overtyped.
1. If the converted data is truncated in the situation that the converted data exceeds the Unicode data length.
2. If the converted data contains a substitution character which was taken by the conversion, and also if under a DBCS-enabled terminal.
3. If the converted data contains a character which cannot be converted back to Unicode correctly.
Row Mode
In row mode, a single row of data displays on the screen. If there is more data than can fit on a screen, you must scroll down to view the data. Column names are listed down the left side of the screen, and column attributes are listed in the center of the screen. Data displays on the right side of the screen.
The Edit screen displays in row mode when you either:
- Enter 2, for row, in the Initial Display Mode field on the Edit Options screen.
- Enter the ROW command in the command line on the Edit table mode screen.
- Select Row from the VIEWS pull-down menu on the Edit table mode screen.
The row mode screen displays the first row of the object you selected or the first row displayed on the table mode screen. The ROW command is cursor sensitive when entered on the command line. When going from table mode to row mode, you can display a particular row from the table mode screen. Type ROW, place the cursor on the desired row, and press Enter.
If you are in Browse, you can only review the data. In Edit, you can change the data by typing over the column values. You can also add or delete a row using the INSERT, REPEAT, and DELETE primary commands. See Primary Commands for more information. The following figure. shows a sample Edit screen in row mode.
Edit screen in Row Mode
------------------------------------------------------------------------------
File-AID for Db2 Edit - USERID.EMP SSID: DSN
COMMAND ===> SCROLL ===> PAGE
Row 1
COLUMN NAME TYPE(LEN) KEY COLUMN VALUE
*** ------------------ --------- ----- ----+---10----+---20----+---30----+---40
001 EMPNO CHAR(15) PRIM 000290
002 FIRSTNME VC(12) JOHN
003 MIDINIT CHAR(1) R
004 LASTNAME VC(15) PARKER
005 WORKDEPT CHAR(3) FRGN E11
006 PHONENO CHAR(4) 4502
007 HIREDATE DATE 1980-05-30
008 JOB CHAR(8) PROGRAMMER
009 EDLEVEL SMALLINT 12
000 SEX CHAR(1) M
011 BIRTHDTE DATE 1946-07-09
012 SALARY DEC(9,2) 1534.00
013 BONUS DEC(9,2) 300.00
014 COMM DEC(9,2) 1227.00
015 DESC CHAR(120) Responsible for developing and
(POS 41-80) maintaining payroll programs.
016 BIND_TIME TMSTMP(6) RCHG 2007-04-26-08.28.55.919855
F10=PREV F11=NEXT
On the Edit row mode screen, the row number is indicated by the row counter on the third line. An added row (INSERT or REPEAT) is kept in a pending state until you change the data appropriately and save it (SAVE). The message line on the right-hand side of the title line indicates the status of an added or deleted row with messages such as Insert Pending, 2 Rows Saved, or 1 Row Deleted.
Column Name
Displays either the name of the column or the positions of the COLUMN VALUE column when more than one line is required to display the contents of the column. The column name is underlined, if it is a Unicode column.
Type(Length)
Displays the column’s data type and length (if applicable): CHAR, VC, LVCHAR, GRAPH, VG, LVG, SMALLINT, INTEGER, DEC, FLOAT, DECFL, DATE, TIME, TIMESTAMP, DISTINCT, or ROWID. See Valid Values Based on Data Type for more information.
Key
If the column is part of an index, the index type indicators listed below are shown. The index type indicators are available only for local tables.
PRIM
Column is part of a primary key.
RCHG
Column is a Row Change Timestamp column.
UNIQ
Column is part of a unique index. The INDICATE UNIQUE KEY INFORMATION PRIOR TO EDIT option must be set to ON for this heading to display. See User Parms, Browse-Edit-SQL-Analysis-Display-Options, for more information.
FRGN
Column is part of a foreign key relationship. The INDICATE FOREIGN KEY COLUMNS WHILE IN EDIT option must be set to ON for this heading to display. See User Parms, Browse-Edit-SQL-Analysis-Display-Options, for more information.
IDNT
Column is an identity column. The ALLOW UPDATE OF IDENTITY COLUMNS IN EDIT option must be set to ON for this heading to display. If the column is both an identity column and a primary key, then UPDATE PRIMARY KEY must also be ON to edit the column. See User Parms, Browse-Edit-SQL-Analysis-Display-Options, for more information.
PRID
Column is part of a primary key and is an identity column.
PRFI
Column is part of a primary key, a foreign key, and is an identity column.
IDFN
Column is part of a foreign key, and is an identity column.
UNID
Column is part of a unique key, and is an identity column.
Column Values
This area displays the data type values in either character or hexadecimal mode. A character column longer than the width of the area is split across as many consecutive lines as necessary. To change the column value, type over the existing value.
Values in Unicode columns are the data converted from Unicode to terminal CCSID EBCDIC-based data, using IBM z/OS Conversion Services. The converted data may contain non-displayable characters based on your terminal CCSID.
For a Browse session, a non-displayable character is replaced by the non-displayable character value provided in Option 0, Defaults and User Parms. For an Edit session, a non-displayable character is replaced by an ISPF attribute that appears as a blank and cannot be overtyped.
1. If the converted data is truncated in the situation that the converted data exceeds the Unicode data length.
2. If the converted data contains a substitution character which was taken by the conversion, and also if under a DBCS-enabled terminal.
3. If the converted data contains a character which cannot be converted back to Unicode correctly.
You can still edit native Unicode data in hexadecimal format in Row mode with HEX ON, where the E or V commands further assist you in editing the data.
Editing Unicode Data in Row Mode and Hexadecimal Format
You can view or edit Unicode hexadecimal values in row mode with the HEX primary command. See HEX for information about the HEX primary command.
Unicode Data Displayed in Row Mode Hexadecimal Format shows Unicode data displayed in row mode in hexadecimal format.
In hexadecimal format, two additional hexadecimal lines are displayed for each character line in the display. The values in the hexadecimal lines are Unicode hexadecimal values. If you are in an Edit session, you can edit the Unicode hexadecimal values.
Values in the character display line are the converted EBCDIC-based data from the Unicode hexadecimal values. In hexadecimal format, you cannot overtype the values in the character display line. Each data position of the values is adjusted to be matched with the corresponding Unicode hexadecimal value, since Unicode data length may be different than the converted EBCDIC-based data length. For example: In EBCDIC, the data 123 is 3 bytes; in Unicode UTF-16 the same data is 6 bytes (003100320033).
To assist in editing of the Unicode column data, type either the E or V primary command, place the cursor in the desired Unicode column and press ENTER. File-AID for Db2 then displays either the Edit Column Data screen with Character mode using E command or the Edit Column Data screen with Character mode using V command screen.
Unicode Data Displayed in Row Mode Hexadecimal Format
------------------------------------------------------------------------------
File-AID for Db2 Browse TSOID01.UNITEST SSID: DSN
COMMAND ===> SCROLL ===> CSR
Row 1
COLUMN NAME TYPE(LEN) KEY COLUMN VALUE
--- ------------------ ---------- ---- ----+---10----+---20----+---30----+---40
004 UNITEST1_COL4_GRAP GRAPH(20) . 1 2 3 4 5 6 7 8 9 a 0 0 0
HEX UTF-16 0103030303030303030303030303020202020202
0A01020304050607080901000000000000000000
005 UNITEST1_COL5_GRAP GRAPH(20)
HEX UTF-16 0202020202020202020202020202020202020202
0000000000000000000000000000000000000000
008 UNITEST1_COL8_VARG VG(50) B M C
HEX UTF-16 040404
020D03
(POS 41-80)
(POS 81-100)
009 UNITEST1_COL9_VARG VG(50) F i l e - A I D f o r D b 2
HEX UTF-16 04060606020404040206060702040603
06090C050D01090400060F0200040202
(POS 41-80)
(POS 81-100)
******************************* BOTTOM OF DATA ********************************
Edit Column Data screen with Character mode using E command
You can view or edit entire data in a single character type column of a single row using the E command in Row mode. See E for information about the E command.
The E command displays the “Edit Column Data” screen (Edit Column Data screen with Character mode using E command) with the entire column data in Character mode. The data value wraps to multiple lines. This screen allows characters to be inserted and deleted within the multiple lines, just like a "Text Editor".
The E command is valid only for fixed or variable length Character or Graphic type columns with a length of up to 1198 byte (584 for Graphic column).
Edit Column Data screen with Character mode using E command
Command ===>
Table Name : TSOID01.UNITESTD_LONG >
Column Name : UNITESTD_COL2_CHAR100 >
Column Type : CHAR(100) >
Unicode data conversion : Unicode CCSID = 1208 EBCDIC CCSID = 1047
-------------------------------------------------------------------------------
File-AID for Db2 Test Data 0___5___0___5___0___5___0___5___0___5___0___5___0__
_5___0___5___0
When exiting this screen with PF3(END), File-AID for Db2 checks the data length. If the data does not fit in the column, File-AID for Db2 displays an error message.
For Graphic column data, DBCS attribute will be used for the data field in this screen, so you can type only DBCS data if you are using a DBCS enabling terminal.
The E command does not support the following cases:
- Field data to be displayed contains data less than hex '40'.
- Trailing blanks at the end of data in variable length field, .
For Unicode column data, UTF-8 or UTF-16 Unicode data will be automatically converted to EBCDIC data and the converted data will be displayed. You can update the converted data. The updated data will be converted back to Unicode when exiting with PF3 (END) from this screen.
The following conditions force the V command and display the “Edit Column Data” screen with Vertical Hex mode:
- Conversion result data exceeds 1198 byte maximum supported in this screen.
- Conversion result data contains substitution character.
- Conversion result data other than substitution character, contains character which cannot be converted back correctly.
- Conversion result data contains trailing blank at the end of variable length column data.
- No data value in the variable length column.
Edit Column Data screen with Vertical Hex mode using V command
You can view or edit entire data in a single character type Unicode column of a single row using the V command in Row mode. The V command is valid only for Unicode columns. See V for information about the V command.
The V command displays the “Edit Column Data” screen (Edit Column Data screen with Character mode using V command) with the entire column data in Vertical Hex mode. This screen displays Unicode column data with Unicode original hexadecimal value and the converted EBCDIC data in a table format.
Edit Column Data screen with Character mode using V command
Command ===> Scroll ===> CSR
Table Name TSOID01.UNITESTD_LONG
Column Name UNITESTD_COL2_CHAR100
Column Type CHAR(100)
Unicode data conversion : Unicode CCSID = 1208 EBCDIC CCSID = 1047
Char Offset Inv Value Hex UTF-8 Description >
- ----- ----- - ---- ------------ ------------------------------------
_ 1 0 C 43 LATIN CAPITAL LETTER C
_ 2 1 o 6F LATIN SMALL LETTER O
_ 3 2 m 6D LATIN SMALL LETTER M
_ 4 3 p 70 LATIN SMALL LETTER P
_ 5 4 u 75 LATIN SMALL LETTER U
_ 6 5 w 77 LATIN SMALL LETTER W
_ 7 6 a 61 LATIN SMALL LETTER A
_ 8 7 r 72 LATIN SMALL LETTER R
_ 9 8 e 65 LATIN SMALL LETTER E
_ 10 9 20 SPACE
_ 11 10 F 46 LATIN CAPITAL LETTER F
_ 12 11 i 69 LATIN SMALL LETTER I
_ 13 12 l 6C LATIN SMALL LETTER L
_ 14 13 e 65 LATIN SMALL LETTER E
Each row in this display list represents one character and has the following columns:
Line Command
I or D line command (Insert/Delete)
Char
Character sequence number in the current column
Offset
Offset in the current column (Starting from 0)
Inv
Invalid indicator for Unicode conversion (indicates non-displayable character)
Value
Value in EBCDIC character, if displayable
Hex
Hex value in Unicode
Description
Description of Unicode code character
The V command converts Unicode column data in UTF-8 or UTF-16 format to EBCDIC data before this screen is displayed. You can update data in Value or Hex column of the table in this screen.
Use the I (Insert) and D (Delete) line commands to handle data lines.
Pressing the ENTER key, converts any changed EBCDIC or Unicode data to Unicode or EBCDIC data and refreshes all other information in the line as well as Character number and Offset of the rest of lines.
When exiting this screen with PF3(END), the File-AID for Db2 combines the Hex values of all lines to check that the total length will fit in the current Unicode column.