Platform

On Nov 10, 6:45 pm, " "
wrote:
> Hello,
>
> how can I get by SQL the OS platform on which ASE is running?
> It should be possible to get it because if I select the database on
> Sybase Central and then File - Properties under platform I see "NT
> (IX86) (32-bit)"
>
> Thanks

select @@version

will give you the version string, and the OS for which it was built.

This will not necessarily the actual OS that it is running on (i.e. OS
might be Sun_svr4/OS 5.8, but you might be running on Solaris 10 aka
OS 5.10).

Michael
 >> Stay informed about: Platform 

On Nov 11, 1:35 am, "mpepp...@peppler.org"
wrote:
> On Nov 10, 6:45 pm, " "
>
> wrote:
> > Hello,
>
> > how can I get by SQL the OS platform on which ASE is running?
> > It should be possible to get it because if I select the database on
> > Sybase Central and then File - Properties under platform I see "NT
> > (IX86) (32-bit)"
>
> > Thanks
>
> select @@version
>
> will give you the version string, and the OS for which it was built.
>
> This will not necessarily the actual OS that it is running on (i.e. OS
> might be Sun_svr4/OS 5.8, but you might be running on Solaris 10 aka
> OS 5.10).
>
> Michael

If your ASE is configured to allow you to execute xp_cmdshell,

xp_cmdshell "uname <uname parameters>"

may give you more detailed information, assuming also that uname
is executable.
 >> Stay informed about: Platform