Find actual device numbers in Sybase

select low/16777216 "vdevno", name, phyname
from master..sysdevices
where status&=2
order by 1

Warning! For vdevno>127 it could generate incorrect results.

Leave a Reply

  

  

  

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>