Basically, you should not be trapping the output of any QUERY commands. These are designed to be human-readable, not machine-readable. Instead you should be doing SQL-style SELECT commands to retrieve exactly the information you want, in a format that is much less likely to change with new releases. It's often faster too!
Roger Deschner University of Illinois at Chicago [email protected] There are only 10 types of people in the world: Those who understand binary, and those who don't ... On Mon, 1 Jun 2009, Keith Arbogast wrote: >The 'query volume' output from a Linux TSM 5.4.0.3 server is >formatted with expanded numbers in the 'Estimated Capacity' field. >The 'query volume' output from a linux TSM 5.5.2.1 server is formatted >with 'G' or 'T' in the 'Estimated Capacity' field, as needed. I need >the expanded number style output of release 5.4 since, in comma- >delimited form, it can be imported to an Excel spreadsheet for monthly >reporting. > >Is there a setting in TSM 5.5 to obtain the 5.4 style output? A >sample of the two types of output follows. > ><Linux TSM 5.4.0.3 comma-delimited output> >B00001,TS35BLDB,TS3500BL,"3,157,777.0",0.1,Full >B00002,TS35BLDB,TS3500BL,"3,575,771.8",98.5,Full > ><Linux TSM 5.5.2.1 comma-delimited output> >I10000,3584BKUP,3584-01CLASS,2.3 T,100.0,Full >I10005,3584BKUP,3584-01CLASS,1.2 T,52.0,Full > >Thank you, >Keith Arbogast >Indiana University >
