Automic Workload Automation

Expand all | Collapse all

Read automic database to vara details

Jump to Best Answer
  • 1.  Read automic database to vara details

    Posted 05-21-2018 09:48 AM

    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



  • 2.  Re: Read automic database to vara details
    Best Answer

    Posted 05-21-2018 09:54 AM

    Hi All

     

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

     

    Thanks

    John



  • 3.  Re: Read automic database to vara details

    Posted 05-24-2018 02:48 AM

    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