Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Ian Thurbon — — source: Informix-list mailing list archive (1991-1998)
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
↪ replying to Ian Thurbon
smooth1 — — source: Informix-list mailing list archive (1991-1998)
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
>
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.