Details of Connection Objects

[Shravani Vedantham]

​Hi All

Does anyone have a query to list all the details/values from the connection objects created in the system? Like, port number, server IP address etc.,
I am only aware that the ONA table has the details, but it has only types not the actual values.


------------------------------
Thanks Shravani
------------------------------

[Pete Wirfs]

I just spent some time searching the database for this information but so far, I'm stumped too.

I found this list of RA parameters to be interesting though;

select * from jppcv
where jppcv_vname like '%port%'​

------------------------------
Pete
------------------------------

[Pete Wirfs]

Found it.  I didn't want to give up because I thought it would be a useful query to have.

select oh_client, oh_name, oh_otype
	 , (select ocv_value from ocv where ocv_oh_idnr = oh_idnr and ocv_vname = 'operation') as Operation
     , (select ocv_value from ocv where ocv_oh_idnr = oh_idnr and ocv_vname = 'port') as Port
	 , (select ocv_value from ocv where ocv_oh_idnr = oh_idnr and ocv_vname = 'userId') as Userid
	 , ona.*
from ona, oh
where ONA_OH_Idnr= oh_idnr
  and oh_otype = 'CONN' and oh_deleteflag = 0
order by 1, 2;

------------------------------
Pete
------------------------------

[Shravani Vedantham]

Thank you so much Pete for your time in looking into this. I will try this and also post updates if i find anything too. Its time taking for me as I am not so good at SQL stuff.

------------------------------
Thanks Shravani
------------------------------

[Shravani Vedantham]

Thank you Pete. you are awesome! It worked!  :)

------------------------------
Thanks Shravani
------------------------------