By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,558 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,558 IT Pros & Developers. It's quick & easy.

DB2 - Select ... Output Option....

P: n/a
I am using AIX DB2 v8

we have tables so huge...when I do query...like the following:

db2 "select * from table fetch the first 10 rows with ur"

all the outputs are wrapped around the screens, and u are hardly to
follow which value to which columns...

Is there a way to have the output in the following formats...column in
one side, and value on the other side?

Column Value
Column Value
Column Value
......

Please advise...
Thanks
Nov 16 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Nov 16, 7:36 pm, "d.k.chung" <dkhch...@gmail.comwrote:
I am using AIX DB2 v8

we have tables so huge...when I do query...like the following:

db2 "select * from table fetch the first 10 rows with ur"

all the outputs are wrapped around the screens, and u are hardly to
follow which value to which columns...

Is there a way to have the output in the following formats...column in
one side, and value on the other side?

Column Value
Column Value
Column Value
.....

Please advise...
Thanks
Here's what I normally do (I'm on linux, so it might not apply on
aix):

db2 "select * from table fetch first 10 rows only with ur" | less -S

/Lennart

Nov 16 '07 #2

P: n/a
d.k.chung wrote:
I am using AIX DB2 v8

we have tables so huge...when I do query...like the following:

db2 "select * from table fetch the first 10 rows with ur"

all the outputs are wrapped around the screens, and u are hardly to
follow which value to which columns...

Is there a way to have the output in the following formats...column in
one side, and value on the other side?

Column Value
Column Value
Column Value
.....

Please advise...
Thanks
The simple way to look at output that exceeds the width of the screen is to
use the DB2 GUI (the command editor)

Colin
Nov 18 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.