Objects in Tables

Hey, everyone. I’m looking for a way to get the table(s?) that an object references from the repository. I know I can view the SELECT statement from the repository, but isnt’ there a table somewhere with the IDs linked from UNV_OBJECT and UNV_TABLE?


smokybfgs (BOB member since 2004-06-18)

Are you looking for UNV_OBJ_TAB, you should be able to query this stuff though Managero. Here is some code below that might help get you started, its just count of objects and associated table name (alias) or as an alternative although I am not entirely sure what you are trying to do maybe using the “full description” for Objects in the Print option tab in Designer will give you the table.column name of every object in a particuliar Universe.

SELECT
  object_tables.TAB_NAME,
  UNV_OBJECT.OBJ_NAME,
  count(distinct UNV_OBJECT.OBJECT_ID)
FROM
  UNV_TABLE  object_tables,
  UNV_OBJECT,
  UNV_OBJ_TAB
WHERE
  ( UNV_OBJ_TAB.UNIVERSE_ID(+)=UNV_OBJECT.UNIVERSE_ID  )
  AND  ( UNV_OBJ_TAB.OBJECT_ID(+)=UNV_OBJECT.OBJECT_ID  )
  AND  ( object_tables.UNIVERSE_ID(+)=UNV_OBJ_TAB.UNIVERSE_ID  )
  AND  ( object_tables.TABLE_ID(+)=UNV_OBJ_TAB.TABLE_ID  )
GROUP BY
  object_tables.TAB_NAME, 
  UNV_OBJECT.OBJ_NAME

jswoboda :us: (BOB member since 2002-06-20)

Will this yield me the references of all objects to their respective tables?


smokybfgs (BOB member since 2004-06-18)

Not the query above, you will probably want to pull in the name here is an example for a particuliar table:

SELECT
  UNV_OBJECT.OBJ_NAME,
  object_tables.TAB_NAME
FROM
  UNV_OBJECT,
  UNV_TABLE  object_tables,
  UNV_OBJ_TAB
WHERE
  ( UNV_OBJ_TAB.UNIVERSE_ID(+)=UNV_OBJECT.UNIVERSE_ID  )
  AND  ( UNV_OBJ_TAB.OBJECT_ID(+)=UNV_OBJECT.OBJECT_ID  )
  AND  ( object_tables.UNIVERSE_ID(+)=UNV_OBJ_TAB.UNIVERSE_ID  )
  AND  ( object_tables.TABLE_ID(+)=UNV_OBJ_TAB.TABLE_ID  )
  AND  (
  object_tables.TAB_NAME  =  'AGREEMENT'
  )

jswoboda :us: (BOB member since 2002-06-20)