Output to CSV

[Patrick]

I'm trying to export the result of several commands (q vol f=d, q filespace) to text-files which i then want to import into excel to do some data-sorting on. (Un)fortunately TSM makes these text-files very easy to read for humans, however getting excel to import them the right way takes a lot of work. Is there a way to make the output a CSV? I'm using dsmadmc for windows version 5.3.

 

[stanleyb]

Try:



dsmadmc -id=<yourid> -pass=<yourpassword> -comma "q vol f=d" > /your/file.csv



This is in the manual..

 

[mateinone]

HI



Why not use ODBC??



Will output the data as you want it to Excel and is extremely easy to use.