How to check the Universe database version

[tathoong]

How to check the Universe database version on DataStage ver 7.5.

Thank you.

[ray.wurlod]

Are you referring to a UniVerse database to which you're connecting, or to the database in which DataStage Repository resides?

If the latter, it is exactly the same as the DataStage version. There is an item in the VOC file called RELLEVEL that you can view. For example

Code: Select all

SELECT EVAL "@RECORD<5>" FROM VOC WHERE @ID = 'RELLEVEL';

but it's just as easy to choose About from the Help menu, which gives both the client and server release levels.

If it's a connected UniVerse database you're referring to, then the same query will work, but you'll need to use a UV stage, with user-defined SQL. Capture RELLEVEL into a VarChar(32) column.