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/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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
