Question & Answer
Question
How do I find which database an object resides in?
Answer
You can use the nz_find_object utility to help find and identify an object based on its name or its object id value. nz_find_object is part of the Support Contributed Toolkit and it is located in /nz/support/contrib/release/bin.The input is a string which represents one of the following:
- the object name to be searched
- an OID (object ID)
Note: If you specify a numeric value, the utility searches for an object id; it will not use it to search part of an object name.
In the following example, the search is based on an object name:
nz_find_object TESTTAB2
Object Name Is | It Is Of Type | Its 'objid' Is | In The Database
----------------+------------------+----------------+----------------
TESTTAB2 | TABLE | 11921334 | NZWIDE
TESTTAB2 | TABLE | 11920936 | TEST
(2 rows)
In the following example, the search is based on an object ID:
nz_find_object 11921334
Object Name Is | It Is Of Type | Its 'objid' Is | In The Database
----------------+------------------+----------------+----------------
TESTTAB | TABLE | 11921334 | NZWIDE
[{"Product":{"code":"SSULQD","label":"IBM PureData System"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":null,"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"1.0.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Historical Number
NZ972153
Was this topic helpful?
Document Information
Modified date:
17 October 2019
UID
swg21571244