DSXchange

Posted: **Wed Mar 15, 2006 8:53 pm**

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

Thank you.

Posted: **Wed Mar 15, 2006 9:19 pm**

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.