Start of change

CHANGE MAXCOLUMNWIDTH (Db2 command line processor)

The CHANGE MAXCOLUMNWIDTH command changes the number of bytes in a table column that the Db2 command line processor returns.

Read syntax diagramSkip visual syntax diagram CHANGE MAXCOLUMNWIDTH TO integer
integer
The maximum number of bytes in any column that is displayed after execution of:
  • An SQL SELECT statement
  • An SQL CALL statement that returns a result set
  • A Db2 command line processor LIST TABLES, DESCRIBE TABLE, or DESCRIBE CALL command

This value overrides the value of the MaxColumnWidth Db2 command line processor property during the Db2 command line processor session.

End of change