TSM 6.1 and new SQL display format

[Rigido]

Hi,
I have some server scripts that I use for everyday checks on my customers site. I just did a migration to TSM 6.1 and some scripts stopped working, there are many complains about integer to varchar cast, but this is not the "real" problem.
I wrote most of the scripts with "width" in mind and did a lot of CAST to size output to window size, but now the SQL output is always like SQLDISPLAYMODE is set to narrow.
I read that SET SQLDISPLAYMODE is a deleted command and that now "The commands are replaced by options in the DB2 SELECT command syntax.":
Does someone know these DB2 SELECT options?!

 

[BBB]

Why not use dsmadmc -dataonly=yes -comma

This way the formatting is irrelevant and all your casts are not required.

 

[Rigido]

Hi BBB,
thank you for your reply but I'm talking about scripts that I don't use once a day but something like a "Q SESS F=D" just for client sessions and other scripts like that, that's way the output format IS relevant.

 

[yager]

Agreed.....

Any more input on setting query results to display like before. As said SET SQLDISPLAYMODE does nothing..

As stated I also run many commands/scripts and macros but I'm unfamiliar with how to rework the output for a 'wide' format...

anyone?

 

[yquirion]

Dear all,

I have the same problem. Is somebody found a solution?

Regards,
Yanick

 

[Magneto]

Another month.. same request

Has anyboby found anything to solve this issue?

Thanks so far

 

[TonyB]

From what I'm seeing the wide mode works. The issue may be in the length of the output fields in your select statements (possibly also the column widths of the v6 tables are different, haven't looked).

For example, on my current window (150 columns) the first statement displays in "narrow" mode, and the second in "wide" mode:

select -
    n.node_name as "Node", -
    contact as "Team", -
    filespace_name as "Filespace Name", -
    filespace_type as "Type", -
    date(backup_end) as "Last Backup" -
from -
    filespaces f -
right outer join nodes n on f.node_name=n.node_name -
where -
    (backup_end<current_timestamp-0 days  or backup_end is null) -
order by -
    2,1,5

select -
    cast(n.node_name as varchar(16)) as "Node", -
    cast(contact as varchar(32)) as "Team", -
    cast(filespace_name as varchar(16)) as "Filespace Name", -
    cast(filespace_type as varchar(12)) as "Type", -
    date(backup_end) as "Last Backup" -
from -
    filespaces f -
right outer join nodes n on f.node_name=n.node_name -
where -
    (backup_end<current_timestamp-0 days  or backup_end is null) -
order by -
    2,1,5

HTH,

T