I'm working on DB2 UDB 8.2.5, on AIX 5.3 - I know MySQL has a cool feature where it allows you to display the output of a query in a vertical format instead of columnar, if the size of the data row exceeds the number of columns defined in your shell environment, and that could be done by appending "\G"; to the SQL statement. In DB2, however, I'm not able to find a way to display the returned data in a similar way. If I run a query on a table and I redirect stdout to a file, the results are not displayed as neatly as they are in MySQL, Oracle or Informix.
Does anybody know of a way to accomplish this?
here's an example:
select * from my_table
11/01/1949 02/17/2006 - Y 2006-10-12-184.108.40.2061413 2006-10-12-220.127.116.111413
Instead, I want the data to appear like this:
... you get the idea.