Re: Retrieving product name

This is the information that I require. Is it possible to retrieve this information from a client application using SQL? Ian Thurbon. Don Ignacio wrote: > onstat -V> > -----Original Message----- > From: Ian Thurbon [mailto:ian_thurbon@omnis.net] > Sent: Friday, October 06, 2000 4:37 AM > To: informix-list@iiug.org > Subject: Retrieving product name > > Hi all, > Is their a system table somewhere on an informix server that stores the > product name. For example 'Select owner from systables where tabname = ' > VERSION' will return the version of the server. I would like to be able > to tell if a server is a Universal server or a Dynamic server. Is this > possible? > > regards > Ian

Look at the tables/schema of sysmaster... Different sysmaster database versions have different schemas.. Ian Thurbon wrote in message <8rs0ie$pmj$1@news.xmission.com>... > >This is the information that I require. Is it possible to retrieve this >information from a client application using SQL? >Ian Thurbon. > >Don Ignacio wrote: > >> onstat -V>> >> -----Original Message----- >> From: Ian Thurbon [mailto:ian_thurbon@omnis.net] >> Sent: Friday, October 06, 2000 4:37 AM >> To: informix-list@iiug.org >> Subject: Retrieving product name >> >> Hi all, >> Is their a system table somewhere on an informix server that stores the >> product name. For example 'Select owner from systables where tabname = ' >> VERSION' will return the version of the server. I would like to be able >> to tell if a server is a Universal server or a Dynamic server. Is this >> possible? >> >> regards >> Ian >