Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Table: T_DEFINITION
- ============================
- TABLE_NAME | WHERE_CONDITION
- -----------+----------------
- TBL1 | WHERE CMP_ID=0
- TBL2 | WHERE 1=0
- TBL3 | WHERE SEQ_ID=10 OR CMP_ID=0
- ...
- INCLUDE=TABLE:"IN (SELECT TABLE_NAME FROM T_DEFINITION WHERE (WHERE_CONDITION!= '1=0' OR WHERE_CONDITION IS NULL))"
- QUERY=DEV.TBL1:"WHERE CMP_ID=0"
- QUERY=DEV.TBL2:"WHERE 1=0"
- ...
- QUERY="SELECT TABLE_NAME||':'||WHERE_CONDITION FROM T_DEFINITION"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement