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: DUKETSM1>select sum(num_files),sum(physical_mb) from occupancy where stgpool_name='T

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 sta

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