You are here: LANSA for i User Guide > 6. Administration > 6.2 Review System Settings > 6.2.3 Field and File Defaults

6.2.3 Field and File Defaults

To display the Work with Field and File Defaults screen, select Administration from the Main System Menu (Advanced), choose Review system settings from the Administration Menu and then select Field and File defaults from the Review of System Settings menu.

 

  DC@P8118        Work with Field and File Defaults 

  Field defaults

    Input attributes

      - alpha fields   .  . : FE __ __ __ __ __ __ __ __ __

      - numeric fields  . . : FE RB __ __ __ __ __ __ __ __

    Output attributes

      - alpha fields   .  . : __ __ __ __ __ __ __ __ __ __

      - numeric fields  . . : __ __ __ __ __ __ __ __ __ __

                                                 

  File defaults

    File SIZE parameter default  . . . . . : 10000_____

                                             2000______

                                             3_________

    File LVLCHK parameter default . . . . .: *YES      *YES, *NO

    File commitment control default. . . . : N          Y,N

    Always build using SQL . . . . . . . . : Y          Y,N

  

  

  Fnn=Help Fnn=Exit Fnn=Cancel Fnn=Messages Fnn=Change            

 

 

The settings on the Work with Field and File Defaults screen are retrieved from these data areas:

Setting

DC@A01

DC@A07

DC@OSVEROP

Field attributes

158 - 317

 

 

File Size

112 - 141

 

 

LVLCHK parameter

142 – 145

 

 

Commitment control

391

 

 

Always build using SQL

 

 

*SQL_BUILD

 

Field default attributes

Positions 158 - 317 in data area DC@A01.

These specify the default attributes for fields. The values specified must be valid field attributes.  Refer to information on fields for a detailed list of valid attributes.

File default SIZE parameter

Positions 112 - 141 in data area DC@A01.

This default SIZE parameter is used when initially creating LANSA files. The initial number of records, the increment number of records and the maximum increments may be specified. The parameter must be a valid operating system size parameter.

File default LVLCHK parameter

Positions 142 - 145 in data area DC@A01.

This default level check, LVLCHK, parameter is used when initially creating LANSA files.

File default commitment control

Position 391 in data area DC@A01.

This default commitment control value is used when initially creating LANSA files. It specifies whether or not the file is to be placed under commitment control. Refer to information on files for a detailed description of the commitment control parameter.

Always build using SQL

Set this option to Y to indicate that physical files and logical files on IBM i are to be built using SQL as much as possible when in an RDMLX partition. The physical file will be built as an SQL table. This keyword will have no effect on how logical files are built, and logical files sharing the access path of  a corresponding SQL index no longer occurs.

Note that there are some valid CRTPF /CHGPF parameters that will not be able to be applied to physical files created as tables using SQL, and similarly some valid CRTLF / CHGLF parameters that will not be able to be applied to logical files created as indexes. One such parameter for both is MAXMBRS with a value other than 1 or *SAME.

RDML files built when the *SQL_BUILD option is in effect can be imported to RDML partitions provided they do not have DB triggers set on, however if they are rebuilt in the RDML partition they lose the effects of the *SQL_BUILD option.