[Info-ingres] Is my Ingres server running on Windows?

chris.cla...@gmail.com chris.clark.actian at gmail.com
Tue Sep 5 03:03:14 UTC 2023


On Monday, September 4, 2023 at 6:48:09 AM UTC-7, Roy Hann wrote:
> Short of querying ima_version, or parsing the _version() string, or 
> similar antics, is there a convenient way to tell if my application is 
> connected to Ingres running on Windows? 
> 
> Clearly I am hoping for something like dbmsinfo('platform')... 

I can't think of anything off the top of my head. If it were me, I'd use dbmsinfo('_version'). If you want to avoid that then you could look at port numbers in IMA for (say) the GCN. Windows uses pipes, most installations on Unix are tcp/ip sockets (rather than domain/file sockets), so if you can't successfully cast to an integer its **probably** Windows (or VMS).

The other option might be to poke around locations paths, but again for me version string would be my goto solution.

Out of curiosity, what sort of decisions to you want to make once you have this determined in the application?


Chris


More information about the Info-ingres mailing list