Finding domain owners with SQL for DB2 Geodatabase

612
1
03-01-2017 12:42 PM
Highlighted
New Contributor

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!

0 Kudos
1 Reply
Highlighted
Esri Frequent Contributor

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;

--- George T.