query to determine the Instance Name?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PaulR - 21 Dec 2005 17:22 GMT

Hi,
(V8.2 LUW)

I'd like a Stored Procedure to self discover the Instance Name in which
it is executing?

any ideas?
e.g Catalog view? snapshot table function ? etc ....

Thanks.

PaulR

Reply to this Message

m0002a@yahoo.com - 21 Dec 2005 20:09 GMT

SELECT * FROM TABLE(SYSPROC.ENV_GET_INST_INFO()) AS SYSTEMINFO;

You can select just the INST_NAME column if that is all you want.

Other usefull information is are in these UDF's:

SYSPROC.ENV_GET_SYS_INFO
SYSPROC.ENV_GET_PROD_INFO

The above funcitons require V8.2 FP9+

Reply to this Message

PaulR - 22 Dec 2005 13:19 GMT

Thanks,

Unfortunately, we are only on fp8, for now I am using the definer in
SYSCAT.PACKAGES, but this is not ideal going forward.

So, when we go to 9+ I'll take up your suggestion.

Many thanks.

Reply to this Message