The Unnamed columns are the output columns you chose in your SELECT
statement, in the order you chose them. Since there is no corresponding
column in the table that corresponds to a "sum" operation, you get
"Unnamed".

You can get more readable column names by adding "AS colname" to your
SELECT statement for each column that does not correspond to an existing
column in table, i.e.:

   select sum(num_files) as "TOTAL FILES", sum(physical_mb) as "TOTAL
PHYSICAL MB" from ....

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 07/16/2004
12:54:03:

> I have ran a select command and I not sure of the meaning of the out put
> listed below could someone
> inlighten me ? What is the Unamed[1] and Unamed[2] ?
> Thanks
>
> tsm: DUKETSM1>select sum(num_files),sum(physical_mb) from occupancy
where
> stgpool_name='TAPEPOOLH'
> ANR2963W This SQL query may produce a very large result table, or may
> require a significant amount
> of time to compute.
>
> Do you wish to proceed? (Yes (Y)/No (N)) y
>
>  Unnamed[1]                            Unnamed[2]
> -----------     ---------------------------------
>   112866529                           39587397.10
>
> Justin