Keywords › SELECT Keyword—Record Control › Examples: SELECT keyword

Examples: SELECT keyword

This example creates a SELECT record called PROBE1 in the SDT, selecting departments ranging from 200 through 299:

TSS ADDTO(SDT) SELECT(PROBE1)
               SELDATA('IF DEPARTMENT GE "200" AND DEPARTMENT LE "299" ')

This example permits a user to access all data from an FCT called PAY and select all records so that departments 1000 through 1999 are chosen:

TSS PERMIT(USR01) FCT(PAY) 
                  ACCESS(ALL)
                  SELECT('IF DEPT GE "1000" AND DEPT LT "2000" ')

This example revokes access:

TSS REVOKE(USR01) FCT(PAY)

This example permits a user to access all data from an FCT called PAY and select all records so that departments 1000 through 1999 are chosen, but limit user only to update DEPARTMENT 1500:

TSS ADDTO(SDT) SELECT(READDEPT)
               SELDATA('IF DEPARTMENT GE "1000" AND DEPARTMENT LT "2000" ')

TSS ADDTO(SDT) SELECT(UPDTDEPT)
               SELDATA('IF DEPARTMENT EQ "1500" ')

TSS PERMIT(USR01) FCT(PAY)
                  ACCESS(ALL)
                  SELECT(READDEPT,UPDTDEPT)

This example revokes access:

TSS REVOKE(USR01) FCT(PAY)