You can configure the Adapters for Flat and Delimited Flat Files from the Web Console or the Data Management Console. In addition, for each type of file, you must specify the location of the data files you wish to access. You can define the location, either by:
You can configure the adapter from either the Web Console or the Data Management Console.
or
From the Data Management Console, expand the Adapters folder.
The Adapters folder opens.
The Add Adapter to Configuration pane opens.
Note: The Flat Files and Delimited Flat Files adapters are under the Sequential and Indexed group folder. No input parameters are required.
An FTP Server can be used as a source for delimited and flat files by configuring a connection to the server. First, you must configure an adapter.
To configure a connection to an FTP server:
These are the connection parameters for FTP.
Parameter |
Value |
---|---|
Connection Name |
Name for this connection, default is CON01 Note: To use the Connection Name, you need to specify it in the CONNECTION attribute of the synonym located in the Data Allocation section. |
Host Name |
Name or IP address of FTP Server |
Initial Directory |
Directory on FTP server on initial connection |
User |
User ID to connect to FTP server or anonymous |
Password |
Password to connect to FTP or an email address |
Profile |
Profile on server to add this connection |
FIXED data sets may be allocated with the FILEDEF command
FILEDEF FILE1 DISK filename [(LRECL lrecl RECFM recfm]
where:
Is the full path and file name of the data file.
Is the record length in bytes. This parameter is optional. If you omit it, it is calculated based on the metadata description.
The left parenthesis preceding the optional parameters is required.
Is the record format. Specify F for fixed format, V for variable format. This parameter is optional. If you omit it, the default is fixed format.
FIXED data sets may be allocated using JCL
//FILE1 DD DISP=SHR, DSN=dataset_name
or file definition
FILEDEF FILE1 DISK //'dataset_name' [(LRECL lrecl RECFM recfm]
where:
Is the fully qualified data set name.
iWay Software |