TSM 6.1 SQL Behavior

[chad_small]

With TSM 6.1 I currently am not getting scripts to return in column format, it keeps outputting in list format (one field per line). Do I missing something? I set sqldisplaymode wide. ???

 

[nkovacs]

You can force the output in list or table mode on the command line when you start dsmadmc using -displaymode=list or -displaymode=table. I believe the admin client switches from table to list mode by default once the column width reaches some threshold width. Some of the column widths changed from 5.5 to 6.1 which will cause some of the formatting to be different on SQL queries.

Try starting your admin client like this:
dsmadmc -tcps=xx.xx.xx.xx -tcpport=1500 -displaymode=table