select low/16777216 "vdevno", name, phyname from master..sysdevices where status&=2 order by 1
Warning! For vdevno>127 it could generate incorrect results.
select low/16777216 "vdevno", name, phyname from master..sysdevices where status&=2 order by 1 Warning! For vdevno>127 it could generate incorrect results. Only the short info about Sybase database devices. Parameters: min_space – minimum of required space (i.e. 40 will display the devices with >=40M free space) the_name – the template for the device name (i.e. %mast% will display only master device) Warning! It was not tested for all possible configurations, so the result could be incorrect […] |