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.