Check out:
set sqldisplaymode wide|narrow

All the sql output from 5.5 scripts need to be checked and corrected
in version 6.

Good luck,
Maurice van 't Loo

2010/11/7 Robert Ouzen <rouzen AT univ.haifa.ac DOT il>:
> Hi to all
>
> I am testing a TSM version 6.2.1 in a Windows test environment and a little 
> question about a lot of scripts I wrote in the Tsm server Production .
>
> Running as this one for example got it in three lines instead one in the 
> previous version, did is a way to get it in one line ?
>
> Run ip digiprod     (select node_name , tcp_address, contact from nodes where 
>  node_name = upper('$1') order by 2)
>
> Output: Version 6
>  NODE_NAME: DIGIPROD
> TCP_ADDRESS: 132.74.59.177
>    CONTACT: Library
>
> Output: Version 5
> NODE_NAME              TCP_ADDRESS            CONTACT
> ------------------     ------------------     ------------------
> DIGIPROD               132.74.59.177          Library
>
> Regards
>
> Robert
>