Re: Data archiving

From: Keith D Gregory <keith_at_inconcert.com>
Date: Fri, 15 May 1998 12:36:32 -0400
Message-ID: <355C6F10.41B25251@inconcert.com>

In 1998050802105300.WAA17819_at_ladder01.news.aol.com, Jgitomer wrote:
> >
> > Using a simple select statement and spooling out means that the
> > spool file will contain column headers, which makes the process
> > of loading back the data staright from the spool file difficult,
> > since you'll have to strip off the headers. If there a way of
> > spolling without the headers??
>
> SET HEAD OFF
> SET PAGESIZE 0
This is only part of the story. You may also have to specify column widths, space between columns, conversion formats (you wouldn't want to have all your Date/Time fields come out as MM/DD/YY, would you?), and suchlike.

And then you'll find, as I did, that embedded carriage returns completely screw up the column lengths (at least with 7.3.2, an embedded CR would cause it to space-pad the output beyond either the defined or specified length).

-kdg Received on Fri May 15 1998 - 11:36:32 CDT