total mb of data on tapepool

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: DUKETSM1select sum(num_files),sum(physical_mb) from occupancy where stgpool_name='TAPEPOOLH' ANR2963W This SQL query may produce a

Re: total mb of data on tapepool

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

total mb of data on tapepool

:total mb of data on tapepool 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: DUKETSM1select sum(num_files),sum(physical_mb) from occupancy where stgpool_name='TAPEPOOLH