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.