Increasing Screen width in db2

Question

SET LINES 200

The above statement in oracle increases the screen width from its default size to 200. I want to achieve the same in DB2, ie. its default width is set to 50, how can i increase it?

Even if I spool the output to a file, the rows are terminating at 50th character and continuing in next line. I want all to be in the same line.

SQL> select ' this is the column i dont want to be displayed in multiple lines ' from dual;

this is the column i dont want to be displayed in
multiple lines

Thanks in advance.

Answer 1

The default column length in cli plus is 50. You can adjust this by setting a column format (see the cli plus manual).

e.g. COLUMN 1 FORMAT A500