We can execute the following query just as like any other queries and get the result.
SELECT service_level FROM TABLE(ENV_GET_INST_INFO()) AS TEMP;
Once you execute this query you will get a result set like this,
Hope this is useful!
Showing posts with label query. Show all posts
Showing posts with label query. Show all posts
Monday, May 16, 2011
How to get the version of DB2 database using query?
Its very easy to get the version of DB2 database using a query. It works in most of the DB2 version.
We can execute the following query just as like any other queries and get the result.
SELECT service_level FROM TABLE(ENV_GET_INST_INFO()) AS TEMP;
Once you execute this query you will get a result set like this,
Hope this is useful!
We can execute the following query just as like any other queries and get the result.
SELECT service_level FROM TABLE(ENV_GET_INST_INFO()) AS TEMP;
Once you execute this query you will get a result set like this,
Hope this is useful!
Subscribe to:
Posts (Atom)