Step 5—Completing file allocation
File-AID/RDX displays the Create New File screen illustrated in the following figure when the specified extract file does not yet exist. The allocation parameters are prefilled with the current profile’s settings.
Create New File
To complete the file allocation information: | |
|---|---|
In all fields… | Do the following: |
Review the values and fill according to your site’s specifications. The Record Format and Record Length are supplied by File-AID/RDX based on the maximum record length of the data to be extracted. | |
Command | Type END |
Press Enter | File-AID/RDX submits the extract job (remember you entered GO in the Extract - DB2 Driving Object screen) and returns to the Primary Option Menu. When the extract is completed you will receive a message with a completion code. You can then review the delimited extract file and load its data into other RDBMS or spreadsheets that accept delimited file format. Remember that you cannot use the delimited file with the File-AID/RDX load or delete features. |
Field Names and Descriptions
The following list describes the fields on this screen.
FIELD | DESCRIPTION |
|---|---|
File Name | Displays the name of the file to be allocated. |
Management Class | Specify the SMS management class to use for the allocation of the file. The management class describes the migration, backup, and retention for the file. |
Storage Class | Specify the SMS storage class to use for the allocation of the file. The storage class describes the hardware requirements of the file. |
Generic Unit | Indicates the device type on which the new file will reside. |
VOLSER | Displays the volume serial number for a non-cataloged or new file. |
Data Class | Specify the SMS data class to use for the allocation of the file. The data class describes the attributes of the file such as RECORG, KEYLEN, KEYOFF, SPACE, etc. |
Space Units | Indicates whether the file is allocated in blocks (BLK), tracks (TRK), or cylinders (CYL). |
Primary quantity | Specify the primary allocation quantity as specified in the space units field. |
Secondary quantity | Specify the secondary allocation quantity as specified in the space units field. |
Directory blk | For a PDS, specify the number of directory blocks. For a Sequential file, specify zero (0). |
Record format | Specify a value with a combination of the following codes (F, V, or U is required): F - Fixed length V - Variable length U - Undefined format B - Blocked A - ANSI printer control characters M - Machine code printer control characters S - For Sequential files only: Standard for F or spanned for V T - Track-overflow feature |
Record length | Specify a logical record length, in bytes, of the records to be stored in the file. File-AID validates this value with the record format and block size. |
Block size | Specify the physical record length, in bytes, of the blocks to be stored in the file. File-AID validates this value with the record format and record length. |
Dataset name type | Specify the type of the data set you wish to create. The type must be one of these: LIBRARY - Allocates a Partitioned Dataset Extended (PDSE). This type of partitioned dataset has unlimited directory blocks and reuses its own space. PDSE libraries do not need to be compressed. PDS - Allocates a standard Partitioned Dataset (PDS). EXTREQ - Indicates that an extended data set is required. EXTPREF - Indicates that an extended data set is preferred. BASIC - Indicates that neither an extended nor a large format sequential dataset is to be allocated. blank - Allocates a partitioned or sequential dataset based on the data set characteristics entered. |
Extended Attributes | Specify one of the following extended attributes: NO - Data set cannot have extended attributes or reside in EAS. OPT - Data set can have extended attributes and reside in EAS. blank - Use default based on data type. |
Number of Volumes | Specify the number of volumes requested for this data set, or leave this field blank for a single volume allocation. |
Primary Commands
The following list identifies the primary command that is available from this window. For details on the command, see File-AID/Related Data XPERT Reference.
COMMAND | DESCRIPTION |
|---|---|
END | Returns to the Extract - DB2 Driving Object screen. |
Line Commands
There are no line commands associated with this screen.