Read automic database to vara details

[johnlewis604562]

Hi

 

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

 

Regards

John

[johnlewis604562]

Hi All

 

just found the db schema page and that has pointed me in the rigth direction.

 

Thanks

John

[FrankMuffke]

Hi

 

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,oh
where OH_otype = 'VARA'
and OH_CLIENT = 0
and oh_name = 'UC_CLIENT_SETTINGS'
and oh_deleteflag = 0
and oh_idnr = ovw_oh_idnr