IBM Support

column title length displayed in db2 command line is not correct

Troubleshooting


Problem

Customer usually uses SUBSTR() to control the column length of a query, but in some environment the column title length displayed in db2 command line is not as expected.

Symptom

Bad case:
$ db2 "select substr(subname,1,15),state from asnq.ibmqrep_subs where subname='SIVIEW-FRLOT' with ur"

1 STATE
------------------------------------------------------------------------------------------------------------------------------------ -----
SIVIEW-FRLOT A

1 record(s) selected.


Good case
$ db2 "select substr(subname,1,15),state from asnq5.ibmqrep_targets where subname='SIVIEW-FBWKARE' with ur"

1 STATE
--------------- -----
SIVIEW-FBWKARE A

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Programming Interface - CLP","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.1;10.5;9.7;9.8","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

swg21981089

Page Feedback