Keywords › USING Keyword—Model ACID › Examples: USING keyword

Examples: USING keyword

This example creates a new ACID (USER02) which is modeled after an existing ACID (USER01) including USER01's name and password:

TSS CREATE(USER02) USING(USER01)

This example gives USER02 a name of John Smith with an initial password of SMIJO01. Passwords expire every every seven days:

TSS CREATE(USER02) USING(USER01)
                   NAME('JOHN SMITH')
                   PASSWORD(SMIJO01,7,EXP)

To omit an information field from the new ACID, enter the keyword with no value specified in the parentheses. In this example,the INSTDATA keyword is omitted from USER02:

TSS CREATE(USER02) USING(USER01)
                   INSTDATA()

All ACID attributes in USER01 not desired in USER02 must be explicitly removed from USER02 after the CREATE. ACID attributes (SUSPEND and NORESCHK) have no values to nullify with () string values and therefore cannot be nullified within the CREATE syntax. Information not copied by CREATE USING (such as PERMITs) must be explicitly granted to the new ACID after the CREATE.