why is a SQL Query on _alert_hdl.._act_state not possible?

 A query like SELECT ALERT '_alert_hdl.._act_state' FROM '*.**' WHERE _DPT = "myDPType" is not possible because the alert_hdl.._act* attributes can not be used alone in Query Connects because they do not trigger a work function.

If there is also an attribute in the Select Statemant which can be used for connects, the query will be possible.

 

e.g this will work:

SELECT ALERT '_alert_hdl.._act_state', '_alert_hdl.._ack_time' FROM '*.**' WHERE _DPT = "myDPType"

Date added:
Last revised:
Hits:
7.667
Version:
ALL Versions
Rating:
Rating: 0.0. 0 vote(s). No rating done at all.
Your vote was '' (0 of 5) You are an anonymous user.
You may log on to do personalized votings
Click the rating bar to rate this item Please log on to do ratings
  • Notification

    FE user cannot be identified! (1403201096)

  • Information

    Not already rated (1403203414)