Automic Workload Automation

  • Private Community
 View Only

  • 1.  DB Table that stores DB of an CONN object

    Posted May 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 May 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 May 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