Hello

I am using db2 command to query my database and when it outputs results it automaticaly consumes space from the screen according to max length of each column.
Is there a way to suppress the output to use only space for the usefull data as it happens with mysql command line client.

Thank you!
Gaganis

Hi,

There are very few options but i can give some suggestions:

1.Say your query is:
Select lastname from emp;

If you have length of column lastname as varchar(120), but lastname can be at the most of 30 bytes length, so you can modify the query as:

Select char(lastname,30) from emp;

This will truncate your additional space. Similarly for a double column you can use integer.

2. You can also save the data in form of csv and view it in excel.

Select * from emp > emp.csv

Cheers,