Hi,
using db2 v9.5 Linux. When executing "db2 list application show detail" command I get really ugly output - multiple lines and columns data are all mess up.

I was talking to my friend, he is using mysql database, and he said this can be done in mysql using some -g switch.

How to make display of output in one sigle long line? Instead of multiple columns mess up in one display.

P.S. On DB2/Windows this settings is set by specifying settings in Properties | Layout | Width parameter.-
Regards

That depends on the terminal width and has nothing to do with DB2 per se. CLP just wraps lines to the terminal width. Properties of the text terminal are set with the stty command.

@n_i, can you please write some sample to set for example 10000 characters per row width?

I have tried using "stty columns 500" and I see "stty -a" that columns has 500 width columns settings, but "list application all show detail" still has no effect, still multiple columns brake.

What I am doing with long lines is this:

Hi,
I have found out excellent program Terminator. It can be downloaded from web page: Terminator

Terminator is using horizontal bar so no wrapping is set. See how terminal window looks like:
http://software.jessies.org/terminator/win32-tabs.png
Regards

The easiest was is to redirect the output to a file

Then open the app.out file in your editor [any editor will do, I guess it is gedit in Linux].... the file will be in the path from where you have issued the command.... the '>' operator will basically redirect the output to a file....

Pls note - this will not work when you're under db2 prompt as > is an OS level operator

@nick.ncs, I know I can output to file, but this is way too time consuming and files have to be deleted.

I think this has to be some kind of terminal settings, because Terminator can handle this problem without the need of "output" to file...

Why don't you just pipe the output into a pager like "less" as I mentioned above?

stolze, your solution is great I love it thanks a lot. But Windows way or Terminator way is better it removes additional typing. There is one think I dislike about Terminator, it is written in Java so it takes more time to start up, so it is also time consuming if starting terminal multiple times per day.