How can I select the Database-Version ? 
Author Message
 How can I select the Database-Version ?
Hello,

is it possible to retrieve the database-version via SELECT-statement ?

Thanks
Bernd



Wed, 18 Jun 1902 08:00:00 GMT
 How can I select the Database-Version ?

select owner
from systables
where tabname = " VERSION"

                            ^ note space

Bizarre, I know ...

Brett Randall

Quote:

> Hello,

> is it possible to retrieve the database-version via SELECT-statement ?

> Thanks
> Bernd



Wed, 18 Jun 1902 08:00:00 GMT
 How can I select the Database-Version ?

Quote:

> select owner
> from systables
> where tabname = " VERSION"

>                             ^ note space

> Bizarre, I know ...

> Brett Randall


> > Hello,

> > is it possible to retrieve the database-version via SELECT-statement ?

> > Thanks
> > Bernd

The problem doing this select is, that You get the version, which was
used
when the database was created. This may differ from the actual version,
if
You did an update in between.

A far better seems to me to use an "dbaccess -V" instead

--
*******************************************************************************
* Any opinions written in this e-mail are my own. They may not
correspond to  *
* those of my
company.                                                        *
*******************************************************************************
* Wolfgang Zager                      Berghauser Str.
104                     *
* BAB Data-Systems GmbH               D-42349
Wuppertal                       *
* Abt. Programmierung                 Tel.  : +49 202
479870                  *
*                                     Fax   : +49 202
470035                  *
*                                     E-Mail:

*******************************************************************************



Wed, 18 Jun 1902 08:00:00 GMT
 How can I select the Database-Version ?


Quote:
> select owner
> from systables
> where tabname = " VERSION"

>                             ^ note space

> Bizarre, I know ...

Unfortunately this is a shortened version (without the F,U or T)
and more the version number of the sysmaster database when it was
*installed*. This is not necessarily the version you are running
now after some db upgrades...

Since 7.31 the dbinfo function can do the trick:

SELECT DBINFO('version', 'full') FROM systables WHERE tabid = 1;

For more options see the SQL syntax guide.

Quote:

> Brett Randall


> > Hello,

> > is it possible to retrieve the database-version via SELECT-statement
?

> > Thanks
> > Bernd

HTH
Christian
--

The opinions stated above are my own
and not necessarily those of my employer.



Wed, 18 Jun 1902 08:00:00 GMT
 How can I select the Database-Version ?

select owner from systables where tabname = ' VERSION'

cheers
j.

Quote:
-----Original Message-----

Sent: Wednesday, November 08, 2000 5:10 AM

Subject: How can I select the Database-Version ?

Hello,

is it possible to retrieve the database-version via SELECT-statement ?

Thanks
Bernd



Wed, 18 Jun 1902 08:00:00 GMT
 How can I select the Database-Version ?
Another one for the FAQ!
Quote:


>> select owner
>> from systables
>> where tabname = " VERSION"

>>                             ^ note space

>> Bizarre, I know ...

>Unfortunately this is a shortened version (without the F,U or T)
>and more the version number of the sysmaster database when it was
>*installed*. This is not necessarily the version you are running
>now after some db upgrades...

>Since 7.31 the dbinfo function can do the trick:

>SELECT DBINFO('version', 'full') FROM systables WHERE tabid = 1;

>For more options see the SQL syntax guide.

>> Brett Randall


>> > Hello,

>> > is it possible to retrieve the database-version via SELECT-statement
>?

>> > Thanks
>> > Bernd

>HTH
>Christian
>--

>The opinions stated above are my own
>and not necessarily those of my employer.



Wed, 18 Jun 1902 08:00:00 GMT
 How can I select the Database-Version ?

Quote:

> is it possible to retrieve the database-version via SELECT-statement ?

According to the 9.20 Informix Guide to SQL: Syntax (6527.pdf from
http://www.informix.com/answers), you can use:

        DBINFO('version', 'specifier')

Where specifier can be one of:

'full'
'server-type'
'major'
'minor'
'os'
'level'

On my 9.21.UC1 Foundation.2000 server, I get:

select
    dbinfo('version', 'server-type'),
    dbinfo('version', 'major'),
    dbinfo('version', 'minor'),
    dbinfo('version', 'os'),
    dbinfo('version', 'level'),
    dbinfo('version', 'full')
from systables where tabid = 1;

Informix Dynamic Server 2000|9|21|U|C1|Informix Dynamic Server 2000
Version 9.21.UC1

Kinda useful, those manual thingies!  :-)

--
Yours,

Guardian of DBD::Informix v1.00.PC1 -- http://www.perl.com/CPAN
     "I don't suffer from insanity; I enjoy every minute of it!"



Wed, 18 Jun 1902 08:00:00 GMT
 
 [ 7 post ] 

 Relevant Pages 

1. MDX : Canned Report or OLAP

2. Anyone know of some canned (cheap or free) DB performance testing software

3. canned code to get db on web quickly via perl or

4. Cans access2.0 engine access btrieve files?

5. bcp canned app

6. if you will promise Allahdad's swamp against cans, it will angrily depart the unit

7. Switching from inhouse to canned package.

8. Canned PARADOX scripts?

9. Master, msdb and model (old version and new version) i need old version

10. select into vs select = in database procedures

11. SELECT "newest Version". Please help :)

12. Select @@version


 
Powered by phpBB® Forum Software