Skip to Content
Information

This site will undergo a brief period of maintenance on Thursday, 23 April at 2:30 AM Central/1:00 PM IST. During a 30 minute window, site availability may be intermittent.

MAXCOL

The MAXCOL command sets the maximum width of the columns in the Db2 table being browsed or edited to the value specified. This command only affects the following column data types: CHAR, VARCHAR, LONG VARCHAR, GRAPHIC, VARGRAPHIC, LONG VARGRAPHIC, BLOB, CLOB, and XML. MAXCOL for a Db2 table defaults to OFF.

When you set MAXCOL in a browse or edit session (or related browse/edit), that setting is retained across sessions. So, if you exit a session and then later start a new session, the setting remains the same. You can change the setting from the browse/edit screen, or from Option 0, Defaults and User Parms, at the Primary Option Menu.

image2021-3-9_16-42-9.png

n

Is the number of bytes to display for each column in the Db2 table. Specify an even number between 1 and 32704.

Warning

Note

If MAXCOL is set when a FIND, RFIND, CHANGE or RCHANGE command is executed, File-AID for Db2 turns MAXCOL to OFF.

OFF

Sets the width of the column currently being displayed in File-AID for Db2 to the width of the column in the Db2 table.

Row and Table Mode Display

The MAXCOL command is valid in both row and table modes.

In table mode, MAXCOL limits the display of the columns to the value that you specify. For example: If you enter MAXCOL 20, the first 20 bytes of data in a column affected by MAXCOL is displayed.

In row mode, MAXCOL limits the display of the columns to the next highest value of 40 (from the value that you specify). For example: If you enter MAXCOL 20, the first 40 bytes of data in columns affected by MAXCOL is displayed. Or, if you enter MAXCOL 41, the first 80 bytes of data in a column affected by MAXCOL is displayed.

When you are in row mode, and you change the MAXCOL value to one that is not divisible by 40, the message “MAXCOL Value Changed” is displayed in the upper right-hand corner. The new MAXCOL value is also displayed.

When you are in row mode, and then switch to table mode, then the current value of MAXCOL in row mode will be used. For example: You are in row mode and enter MAXCOL 31, so the MAXCOL value displayed is 40. If you then enter the TABLE command, the MAXCOL value displayed will be 31.

When you are in table mode, and then switch to row mode, then the current value of MAXCOL is increased to the next highest value of 40. The message “MAXCOL Value Changed” is displayed in the upper right-hand corner. The long form of this message is displayed when you press PF1: “MAXCOL changed to next highest multiple of 40 for row mode. It will revert to the last entered value upon return to table mode.”

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC AMI DevX File-AID for Db2 23.01