>When doing the following:
>
>Dsmadmc  id=someid  pa=somepw  select domain_name,description from domains
>    > somefile
>
>You end up with two columns of info each of which is 18 characters in width.
>If your description is wider then 18 characters it takes up multiple rows.
>This makes it rather hard to parse the  somefile  and stick the info from
>each column into variables to then use. Has anyone found a way to do this
>sort of thing and grab this info?

Gerald - Sure, it's simple:  Use the SQL "AS" keyword to assign a column
         title for your output, and make the title long enough to encompass
any data reported in the column.  This keeps the row, column item report
from spanning lines.
    Richard Sims, BU