File properties

The File properties notebook describes information about the file. It also allows you to specify the printer device type and page size for printer files. This notebook contains the following tabbed pages:

Basics page

The Basics page contains the general properties of the display file.

Source
Displays the fully qualified name of the file.

Type
Displays the type of source that describes the file.

Number of records
Shows the number of records in the file.

Description
Briefly describes the contents of the file and stores this description in the TEXT keyword.

Basics page

The Basics page contains the general properties of the physical file.

Source
Displays the fully qualified name of the file.

Type
Displays the type of source that describes the file.

Description
Briefly describes the contents of the file and stores this description in the TEXT keyword.

CCSID for NLS support
Specifies the default coded character set identifier for all character fields in the file.

Referenced file (REF)
Specifies the default database file from which you select database reference fields for your physical file. To choose a database file, specify the following information:

Library
Specifies the library containing the database file. If nothing is specified, the library list (*LIBL) at file creation time is used.

File
Specifies the name of the file.

Record
Specifies the name of the record.

Browse
If an AS/400 connection is established, then click on Browse to bring up a dialog which allows you to search for the AS/400 file, library, and record lists.

Basics page

The Basics page contains the general properties of the printer file.

Source
Displays the fully qualified name of the file.

Type
Displays the type of source that describes the file.

Number of records
Shows the number of records in the file.

Description
Briefly describes the contents of the file and stores this description in the TEXT keyword.

Line to move to before (SKIPB)
Skips to a specific line number before each record is printed.

Line to move to after (SKIPA)
Skips to a specific line number after each record is printed.

DSPSIZ page

The DSPSIZ keyword dialog lets you specify more than one display size to which your program can open this display file. When you create a display size, the program generates the DSPSIZ keyword.

Select either the 24x80 or the 27x132 display size as the primary display size. The primary display size should be the one with which the display file frequently uses.

Note:
If you do not specify this keyword, you can only open the display file with the default 24x80 display size.

To enable a secondary display size, check the Secondary display size checkbox. You can also name each display size. The default name for 24x80 is *DS3 and the default name for 27x132 is *DS4.

CA/CF page

Use this page to define the function keys you want to have active for the file or given record. The list shows all 24 function keys and the icon used for each one indicates whether the function key is active as an attention key (CA ), function key (CF) or not at all. For the selected function key, its state can be seen and modified using the controls at the bottom of the page. You can modify if and how the function key is active, its conditions and what response indicator will be turned on when the function key is pressed.

Note:
A function key can only be defined at the file or record level.

Function key
Specifies function key type.

Blank
Specifies that this function key is not defined.

CA red
Specifies that this is a CA function key.

CF blue
Specifies that this is a CF function key.
Conditioning:
You can specify the condition under which the current keyword is in effect by selecting the push button.

Parameters
Displays the specified response indicator.

If you selected the Parameters check box, then specify the following information:

Indicator
Specifies which response indicator you want to turn on for this keyword.

Text
Provides a description for this keyword and the intended use for the indicator.

Printer page

The Printer page contains information on the page size and printer device type for the PRTF file.

Page length
Specifies the length of the printer page in lines per page that is used by the device file.

Page width
Specifies the width of the printer page in print positions (characters) per line that is used by the device file.

Printer device type
Specifies the type of data stream that is created for the printer device file. Select SNA Character Stream to specify an SCS printer or Intelligent Printer Data Stream to specify an IPDS printer.

Key sequencing page

The Key sequencing page contains the general properties of the key.

Duplicate Key Sequence
Specifies the retrieval order for the data records that have duplicate key values. Select from the following keywords:

No duplicate keywords allowed (UNIQUE)
Does not allow data records with duplicate key values in the database file member.

You can specify whether to include *INCNULL or exclude *EXCNULL null values when determining duplicate key values.

The total length of all the key fields in the file must be less than or equal to 2000.

First-changed first-out order (FCFO)
When data records in the same database file member have duplicate key values, the record with the key value that was changed first is retrieved first. The total length of all the key fields in the file must be less than or equal to 1995.

First-in first-out order (FIFO)
When data records in the same database file member have duplicate key values, the program retrieves them in the order in which they were written to the member. The total length of all the key fields in the file must be less than or equal to 2000.

Last-in first-out (LIFO)
When data records in the same database file member have duplicate key values, the program retrieves them in the reverse order in which they were written to the member. The total length of all the key fields in the file must be less than or equal to 2000.

Alternative Collating Sequence
Specifies a collating sequence table that sequences data records in the database file member for retrieval. This is valid only if you specify key fields in the file. To choose the table, enable this check box and enter the following information:

Library
Specifies the name of the library that contains the table.

Collacting table
Specify the name of the table.

Browse
If an AS/400 connection is established, then click on Browse to bring up a dialog which allows you to search for the AS/400 library and table lists.