Problem:

The warning "xi2.c(2839)Max Width exceeded 32767 pixels at column 211" may be encountered when accessing a table via the XDB Wizard.

Resolution:

In order to overcome this problem go to the xdb.ini file which should be in the mfuser\\config directory and, there, in the client section change NarrowColumnWidth=yes

This will only solve the problem when the defined width of the column is much less than the width of the name of the colum.  For example, in the following record:

CREATE TABLE T1

        FLAG_FIELD_1 char (1),

        FLAG_FIELD_2 char (1),

        FLAG_FIELD_3 char (1),

        FLAG_FIELD_4 char (1),

        FLAG_FIELD_5 char (1),

        FLAG_FIELD_6 char (1),

        FLAG_FIELD_7 char (1),

        FLAG_FIELD_8 char (1),

        FLAG_FIELD_9 char (1),

        FLAG_FIELD_10 char (1),

        FLAG_FIELD_11 char (1),

        FLAG_FIELD_12 char (1),

        etc.

the SQL Wizard will try to build up a grid of results with the columns sufficiently wide enough to be able to accommodate the entire names of the columns and data therein.  Obviously, the names of the columns are much wider than the data held in the columns.

The NarrowColumnWidth setting will attempt to reduce the width of the column through an algorithm truncating a portion of the name of the column but still displaying a column wider than the data.  All this helps the user of SQL Wizard to identify and display the columns under investigation and at the same time reduce the amount of data displayed on the screen.  Unfortunately, there is no guarantee that reducing the NarrowColumnWidth setting will always solve this grid problem.

If it does not work, then you may want to implement Form View.  To do this go to Options > SQL for DB2 > Client > tab Query Run > here change the default setting of Result View to Form View and click OK.  Now the table will be displayed in Form View format.