Advertisement
Guest User

Untitled

a guest
Oct 27th, 2016
52
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. Table: T_DEFINITION
  2. ============================
  3.  
  4. TABLE_NAME | WHERE_CONDITION
  5. -----------+----------------
  6. TBL1 | WHERE CMP_ID=0
  7. TBL2 | WHERE 1=0
  8. TBL3 | WHERE SEQ_ID=10 OR CMP_ID=0
  9. ...
  10.  
  11. INCLUDE=TABLE:"IN (SELECT TABLE_NAME FROM T_DEFINITION WHERE (WHERE_CONDITION!= '1=0' OR WHERE_CONDITION IS NULL))"
  12. QUERY=DEV.TBL1:"WHERE CMP_ID=0"
  13. QUERY=DEV.TBL2:"WHERE 1=0"
  14. ...
  15.  
  16. QUERY="SELECT TABLE_NAME||':'||WHERE_CONDITION FROM T_DEFINITION"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement