System Profiles › CREATE SYSTEM PROFILE › Examples: CREATE SYSTEM PROFILE

Examples: CREATE SYSTEM PROFILE

The following example shows the definition of a system profile for an MIS production system:

create system profile misprod
attributes  dictname=misdict,
            dbname=benefits,
            prtclass=47,
            prtdest=westwood;

stores system profiles in the system dictionary; up to ten levels of nesting is supported.

The following example shows how you include one profile within another. The system profile SYS74PROF is created, then included in profile JKSPROF.

create system profile sys74prof
 attributes dictnode=system90,
            dictname=persdict,
            dbnode=system90,
            dbname=employee;


create system profile jksprof
 attributes dept=personnel,
            group=c0400,
            jobcode=1200,
            include sys74prof;

The special keyword INCLUDE can be specified to invoke one profile from another.

The following example shows the use of substitution parameters within a profile that can be associated with all users able to signon to the DC/UCF system:

create system profile sys74prof
 attributes dictnode=system90,
            dictname=persdict,
            dbnode=system90,
            schema='&group_user'.,
            include='&user'
.

create user profile jpdprof
attributes   include=&system
.