Automic Workload Automation

Expand all | Collapse all

DB Table that stores DB of an CONN object

Jump to Best Answer
  • 1.  DB Table that stores DB of an CONN object

    Posted 05-13-2019 03:39 PM

    Hi everyone,

    I am getting crazy searching for the DB Table that holds DB+DB server+Port+ user of a CONN(SQL) object...

    (V11.2 and up)

     

    anyone any idea?

     

    many THX

     

    Wolfgang



  • 2.  Re: DB Table that stores DB of an CONN object
    Best Answer

    Posted 05-14-2019 01:34 PM

    Hi Wolfgang,

    It's all in the OCV table (I had to do a little digging) - looks like the OCV_VNames are:

    db.name
    db.port
    db.server
    db.type



  • 3.  Re: DB Table that stores DB of an CONN object

    Posted 05-14-2019 02:35 PM

    Wow, thanks man!!

     

    Indeed that must have been a lot of digging, I never ever had searched there!

     

    THX a lot!!!

     

    KR Wolfgang