Yes, my query of the database shows 72MB free.  So, at least Rui and I think
there is a bug.
While were at fixing the SQL Select statement, can we also get a DATA ONLY
option, so that we can pipe results directly to a process that does not have
to strip off headers, etc.
And, can we make the SET SQLDISPLAYMODE WIDE persistent and/or make it
available in the OPTIONS files.

Thank you.

Mark Mapes
PG&E

> ----------
> From:         Rui Malheiro[SMTP:rmalheiro AT MAIL.TELEPAC DOT PT]
> Reply To:     ADSM: Dist Stor Manager
> Sent:         Friday, May 15, 1998 10:42AM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: Bad results from a SELECT ...
>
> Replying to: Michael Kaczmarski <kacz AT US.IBM DOT COM> (Fri, 15 May 1998
> 11:33:58
> -0400)
>
> >Please take a look at APAR IX76147.  If you do not have at least 4 MB of
> free
> >DB space for
> >use bythe SQL engine temporyary tables, then the ORDER BY clause will
> give you
> >invalid
> >results and no error will be reported.
> >
> >This has been corrected in the referenced APAR
>
> I checked for APAR IX76147 and found this:
>
> =========
> APAR NUMBER: <IX76147>            RESOLVED AS: PROGRAM ERROR
>
> ABSTRACT:
> <IX76147>: WEB ADMIN DOES NOT SEE DEFINED DRIVES, AND IN CUSTOMER'S CASE,
> HIS 3494 LIB.
>
> ORIGINATING DETAILS:
> Using the Web Admin, under Libraries and Drives, the defined
> drives do not show up, but using the command option,
> Query Drive will show the drives. In some instances the defined
> libraries do not show either.
> =========
>
> Anyway, QUERY DB reports 52 MB free. Further Testing shows that the
> problem
> occurs whenever we ORDER BY a non-string column.
>
> --
> Rui Malheiro,
> 6 Mil - Tecnologias de Informacao
> URL: <http://www.6mil.pt/>
>