iSeries Object
- Create New Member
- This item specifies that a new member, to which data is transferred,
is created in an existing iSeries™, eServer™ i5,
or System i5™ file.
Note:
- To create a new member, you must have the following authorities:
- *OBJOPR, *OBJMGT, and *ADD for the file that will include the new member
- *READ and *ADD for a library that will contain the file
See Security Descriptions (SC41-8083) for details of object authorities.
- To create a member to add to a file, the transfer function uses the iSeries™, eServer™ i5, or System i5™ default value for the add physical file member (ADDPFM) command.
When you specify this item, the following item must also be specified:- Member Text
- This item is used to add an explanation of a new iSeries™, eServer™ i5,
or System i5™ member. This explanation helps remind
you of the contents of the member. This explanation appears, for example,
when a list of all members in a file is requested (Browse is
selected). If this item is left blank, no explanation is added to
the new iSeries™, eServer™ i5,
or System i5™ member.
To specify an apostrophe (') in the explanation, enter two apostrophes (' ').
- To create a new member, you must have the following authorities:
- Create New Member in New File
- This item specifies that a new member, to which data is to be
transferred, is created in a new iSeries™, eServer™ i5,
or System i5™ file.
Note:
- To create a new member in a new file, *READ and *ADD authorities are required for the library that will contain that file. Authority to use the create physical file (CRTPF) command of the iSeries™, eServer™ i5, or System i5™ is also required.
- To create a new member in a new file, the transfer function uses
the default value for the create physical file (CRTPF) command of
the iSeries™, eServer™ i5,
or System i5™. It does not, however, use the following
values:
- (MAXMBRS[*NOMAX]). This indicates that the file can contain up to 32,767 members.
- (SIZE[*NOMAX]). This indicates that each member of the file can contain an unlimited number of records.
When this item is specified, also specify the following item:- Member Text
- This item is optional. It is used to add an explanation of a
new iSeries™, eServer™ i5,
or System i5™ member. This explanation helps remind
you of the contents of the member. This explanation appears, for example,
when a list of all the members in a file is requested (Browse is
selected). If this item is left blank, no explanation is added to
the new iSeries™, eServer™ i5,
or System i5™ member.
To specify an apostrophe (') in the explanation, enter two apostrophes (' ').
- iSeries File Type
- This item is always required. It specifies the type of iSeries™, eServer™ i5,
or System i5™ file and the members to be created (same
type for both).
Specify one of the following things:
- To create an iSeries™, eServer™ i5,
or System i5™ physical source file and its members,
specify Source. These members are created with
two fields (order number and date) added to the beginning of the data
transferred from the workstation file. A new iSeries™, eServer™ i5,
or System i5™ source file and its members have the
following record format:
Field Type Length Decimal Places Order number Zoned 6 2 Date Zoned 6 0 Data Character 1 to 32755 or Open
Note that in an iSeries™, eServer™ i5, or System i5™ physical source file, each record can be up to 32 755 bytes in length. But, the maximum size of a source file created using the workstation-to-iSeries transfer function is 4,107 bytes. Also, this file must include the order and date fields. Therefore, the maximum amount of data that can be transferred is 4,096 bytes per record.
The data portions of members inherit the workstation file characteristics. In other words, when a workstation file is a workstation code text file consisting of many records containing text, the created data fields will be the same.
- To create aniSeries™, eServer™ i5, or System i5™ physical data file and its members, specify Data. The file and members will contain only the data fields described in the file-description file.
The value of the iSeries™ File Type is assumed to be Data when a file-description file is used to transfer data. If a file-description file is not used for data transfer, the value of this item is assumed to be Source.
- To create an iSeries™, eServer™ i5,
or System i5™ physical source file and its members,
specify Source. These members are created with
two fields (order number and date) added to the beginning of the data
transferred from the workstation file. A new iSeries™, eServer™ i5,
or System i5™ source file and its members have the
following record format:
- Field Reference File Name
- This item appears only when Use of File Description
File is specified for the creation of a new file.
When Use of File Description File is not specified, an iSeries™, eServer™ i5, or System i5™ physical source file is created. iSeries™ File Type and Field Reference File Name are not displayed. Instead, Record Length opens.
This item is always required. A new iSeries™, eServer™ i5, or System i5™ file is created using the field name in a file-description file and the field definitions in an iSeries™, eServer™ i5, or System i5™ field-reference file.
The format of a field-reference file name is as follows. (Items inside brackets [ ] can be omitted.)[library-name/]file-name
- library-name
- This is the name of an iSeries™, eServer™ i5, or System i5™ library containing a field-reference file. If this library name is not specified, *LIBL is assumed. If you cannot find the desired library, selecting Browse displays a list of all libraries in *USRLIBL of the iSeries™, eServer™ i5, or System i5™ job library list. *USRLIBL of the library list can be changed by modifying the job description by executing a CHGJOBD command on the eServer™ i5 or iSeries™ processor.
- file-name
- This is the name of the iSeries™, eServer™ i5, or System i5™ physical database file containing the field definitions. Always specify this file name. When a library name is specified concurrently, use a slash (/) to delimit the library name and file name. If the desired file cannot be found, enter the library name and a slash, then select Browse. The system displays a list of files in that library. To list all the files in the libraries defined in *USRLIBL of theiSeries™, eServer™ i5, or System i5™ job library list, enter *USRLIBL/ then select Browse.
If you enter part of a file name followed by an asterisk (*) and then select Browse, the system displays a list of available file names, each beginning with the specified part of the name.
For example, enter ARLIB/AR* in the Field Reference File Name item, then select Browse. The system displays a list of all physical file names beginning with AR in library ARLIB.Note: You must have *OBJOPR authority for the field-reference file to be specified. To list certain files, you must also have *OBJOPR authority for those files. - Record Length
- This item is always required. It specifies the record length of an iSeries™, eServer™ i5, or System i5™ physical source file. When the data receiver is an iSeries™, eServer™ i5, or System i5™ physical source file, the specified value must include the length of the order number and date fields that are added to a workstation file at transfer (the total length of these two fields is 12 bytes).
- Authority
- This item is always required. It specifies the authority level
of a new iSeries™, eServer™ i5,
or System i5™ file.
Specify one of the following things:
- Read/Write. This enables other users to read from and write to the iSeries™, eServer™ i5, or System i5™ file and allows the file name to be displayed in lists. However, users cannot delete the file (*OBJOPR, *READ, *ADD, *OBJMGT, *UPD, and *DLT authorities). If other users might be transferring data from a workstation file to the iSeries™, eServer™ i5, or System i5™ file, specify Read/Write or All.
- Read. This enables other users to read from the iSeries™, eServer™ i5, or System i5™ file, and allows the file name to be displayed in lists. However, other users can neither write to the file nor delete it (*USE authority).
- All. This enables other users to read from and write to the iSeries™, eServer™ i5, or System i5™ file as well as delete it. The file name is displayed in lists (*ALL authority).
- None. This prevents other users (except for the system administrator) from writing to or deleting the iSeries™, eServer™ i5, or System i5™ file. The file name does not appear in lists (*EXCLUDE authority).
- File Text
- This item is optional. It is used to add an explanation of a
new iSeries™, eServer™ i5,
or System i5™ file. This explanation helps remind the
user of the contents of the file. This explanation appears, for example,
when a list of all files in a library is requested (Browse is
selected). If this item is left blank, no explanation is added to
the new iSeries™, eServer™ i5,
or System i5™ file.
To specify an apostrophe (') in the explanation, enter two apostrophes (' ').
- Replace Existing Member
- This item transfers data to an existing iSeries™, eServer™ i5, or System i5™ member, specified in the Library/File (Member) item. The existing data in that iSeries™, eServer™ i5, or System i5™ member is replaced with the transferred data.