Hi,

I'm trying to select some data from syscat system tables of my db.
db - server AIX 5.1
dbms - ibm db2 v8.2
using db2 runtime client command line tool, putty through ssh

I noticed some strange behaviour - if system table column is of type varchar - then after each this column data new line symbol is printed out. For example if I select 3 columns of type varchar - my select statement single data row output occupies 3 lines. Select outputs look really bad.

This is by design, or I can fix this ?? I just need one data row per line.

thanks
Vilius

I guess this is due to your environment because DB2 doesn't do something like that. Maybe your shell tries to be too smart and wrap the lines for you. You may want to pipe the query output through "less -S" to see how lines are wrapper; or you redirect the output to a file and look at it there.

Hi,
This was my mistake, I never thought that single varchar field could occupy all my screen width(and more). As soon as I gave enough(a lot!) screen width everything looks fine. Thanks everyone.

Vilius

Dude, you got to be more specific. When I read your post the first ime I had no clue what youa re reffering too.

Yes, if the column is wider then a screen it will spill on a new line. try using substring. There is no new line simbol.