Just in case any of you are wondering how to do this while connecting to Sybase ASE via Linked Server, here is how:

SELECT * FROM OPENQUERY (<linkedserver>,...