Re: script parsing
2000-12-09 07:32:53
Subject: |
Re: script parsing |
From: |
Richard Sims <rbs AT BU DOT EDU> |
Date: |
Sat, 9 Dec 2000 07:33:23 -0500 |
>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
|
|
|