Anybody knows how to format queries result in db2 using clp for instance? as in oracle?

Rosario

..for example in oracle sqlplus was the column command allowing the formatting of columns in result queries

ex: col table_name format a10

does exists something similar in db2 or in some of its tools?
It is possible so to have a more readble and ordered result queries?

Thanks again
Rosario

The answer is no. You can't format query output using CLP, as you would in Oracle's SQLplus. However, you could use string functions to accomplish what you need. E.g. instead of

COL TABLE_NAME FORMAT A10

you could use

SUBSTR(TABLE_NAME, 1, 10)

which will result in a string right-padded with blanks to the length of 10 characters.

thanx much n_i