SQL statement to list all objects/activities with activated breakpoint

Document ID : KB000089170
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
SQL statement to list all objects/activities with activated breakpoint
Resolution:
If there is a need to list all objects/activities with activated breakpoint you could use the following sql statements:

List all objects with breakpoints:

select oh.oh_name, oh.OH_Client, o2.JPP_Object from oh,(select jpp_oh_idnr,JPP_Object from JPP where JPP_Active in (2,3)) o2 where oh.OH_Idnr=o2.JPP_OH_Idnr

List all activities (activity window) with breakpoints:
select ah.ah_name, ah.AH_Client,o2.EJPP_Object from AH,(select EJPP_Object, EJPP_AH_Idnr from EJPP where EJPP_Active in (2,3)) o2 where ah_idnr =o2.EJPP_AH_Idnr