I was wondering if you can retrieve the keys for a vara, using SQL to query the database directly. I know the the vara name is stored in OH table, but I can not located where the fields are to fetch them.
I am using v11.2.
Any pointers would be great
just found the db schema page and that has pointed me in the rigth direction.
would be great if you could post the outcome of your research - otherwise this Thread only hows that you know how to fetch fields from a VARA object in the DB.
select OH_NAME, OVW_VVALUE, ovw_value1, ovw_value2,ovw_value3,ovw_value4,ovw_value5 from ovw,ohwhere OH_otype = 'VARA'and OH_CLIENT = 0and oh_name = 'UC_CLIENT_SETTINGS'and oh_deleteflag = 0and oh_idnr = ovw_oh_idnr