Finding domain owners with SQL for DB2 Geodatabase

NatalieLepsky — Wed, 01 Mar 2017 20:42:24 GMT

I need to find domain owners and other things using SQL. I found few examples with geodatabase system tables for SQL Server and Oracle but nothing for DB2. I'd appreciate it if anybody provides an example on how to use SQL with the DB2 system tables.

Thank you!

Re: Finding domain owners with SQL for DB2 Geodatabase

George_Thompson — Wed, 01 Mar 2017 21:20:30 GMT

This may point you in the correct direction: Domains in a geodatabase in DB2—Help | ArcGIS Desktop

System tables of a geodatabase in DB2—Help | ArcGIS Desktop

You are probably going to have to join some of the GDB_ tables to get the desired output.

Here is a SQL sample for Oracle, you will want to verify the table names, etc.

select i.name “Domain Name”, t.name “Domain Type” from gdb_items i, gdb_itemtypes t where i.type = t.uuid and t.name like '%Domain%' order by t.name,i.name asc;

topic Finding domain owners with SQL for DB2 Geodatabase in Geodatabase Questions

Finding domain owners with SQL for DB2 Geodatabase

Re: Finding domain owners with SQL for DB2 Geodatabase