This Natural profile parameter can be used to specify a system file for parameter profiles (FPROF).
| Possible settings | See FPROF Parameter Syntax. | ||
|---|---|---|---|
| Default setting | none | ||
| Dynamic specification | yes | ||
| Specification within session | no | ||
Notes:
FPROF is used to read parameter profiles
specified by the profile parameter PROFILE, provided no database
information is supplied as subparameter of PROFILE.
FPROF is not defined, the system file FNAT is used as the system file for
parameter profiles.
The parameter syntax is as follows:
| FPROF=(database-ID,file-number,password,cipher-key,RO) |
Where:
| Syntax Element | Value | Explanation |
|---|---|---|
database-ID |
1 - 65535, except 255 |
Database identification of the database in which the Natural
system file for parameter profiles is located.
Note |
file-number |
1 -65535
|
File number of the database file in which the Natural system file for parameter profiles is located. |
password |
1 - 8 characters | Password for the Natural system file FPROF.
Notes:
|
cipher-key |
8 characters | Cipher key for the Natural system file FPROF.
Note |
RO |
- | Read-only option.
Notes:
|
Note
Default values: If any subparameter of profile parameter
FPROF is not specified, the corresponding setting of the profile
parameter DBID, FNR, SYSPSW or SYSCIP applies to the system file for parameter
profiles.
FPROF=(10,56)
In this example, the system file FPROF is located on database file
56 in database 10.