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

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.