To use File Processor Connector in a synchronization task, you must first create a connection in Data Integration. When you create a File Processor connection to connect to an IBM AS/400 FTP server, an IBM z/OS FTP server, an IBM AS/400 SFTP server, or an IBM z/OS SFTP server, specify the source file directory as QGPL. QGPL is the library of the IBM AS/400 FTP, the IBM z/OS FTP, the IBM AS/400 SFTP, and the IBM z/OS SFTP servers.
You can configure a connection on the Connections page or in a wizard as you configure a task.
1On the Connections page, click New Connection to create a connection.
The New Connection page appears.
The following image shows the New Connection page details:
2Configure the following connection properties on the New Connection page:
Connection Property
Description
Runtime Environment
The name of the runtime environment where you want to run the tasks.
Source File Directory
The location that contains files you want to transfer.
Target File Directory
The location where you want to place the transferred files.
Select File
The files that you want to transfer. You can select files based on the fields.
File Pattern
The pattern of the files that you want to transfer. For Example, if you want to select file based on a date pattern, you can specify the date format as DD/MM/YYYY in the file pattern field.
Note: File Pattern field is not applicable when you select all from Select File connection property.
Days Calculation
Use days calculation to select files that are created or modified before the specified date or after the specified date. Select files based on Contains Date Pattern, specify the days calculation value so that you can select files that are modified before or after the specified date. Specify the value in terms of days. You cannot specify the value in terms of month and year.
For example, if you select file based on Contains Date Pattern, use the data filters to specify LastModDate as 02/02/2016 in DD/MM/YYYY format, and specify days calculation as -1. Files that are modified till 01/02/2016 are selected.
PassKey
The credentials to connect to FTP or SFTP server. For example, you can specify the password and passphrase of the FTP or SFTP server as passkey1 and passkey2 values.
3Click Save to save the connection.
You should test the connection before you save the connection details. You can click Test Connection to verify if the connection is successful.
Selection of Specific Files
When you perform a File Processor operation, you can select a single file or multiple files. The files are selected based on the fields that you configure from the Select File connection property. The following table describes the Select File fields to select a specific file or set of specific files.
Fields
Description
All
Selects all the files from the source directory.
Equals
Selects the files that are equal to the specified name in the file pattern property. For Example, if you specify sample.docx, the sample.docx file is selected.
Notequals
Selects all the files other than the file pattern that you specify. For example, if you specify, the file pattern as sample.txt, the sample.txt file is not selected.
Startswith
Selects files that start with the pattern that you specify. For example, if you specify the StartsWith value as sample, all the files that start with name sample are selected.
Endswith
Selects files that end with the pattern that you specify. For example, if you specify EndsWith pattern as .txt, all the files that end with .txt are selected.
FileExtension
Selects the files that contain the specified file name extension. For example, if you specify the values as .txt in the file pattern, all the .txt files are selected.
Contains
Selects files that contains the specified pattern. For example, if you specify the contains pattern as sample, all the files that contain sample in the file name are selected.
FileSizeGreaterThan
Selects files greater than the size specified in the file pattern. Specify the file size in KB. For example, if you specify the file size as 30, all the files greater than 30 size are selected.
FileSizeLessThan
Selects files that are less than the specified size. Specify the file size in KB.
For example, if you specify file size as 30, all the files less than 30 size are selected.
FileSizeEqualsto
Selects files equal to the specified size. Specify the file size in KB.
For example, if you specify file size as 30, all the files with 30 size are selected.
FileSizeNotEqualsto
Selects files not equal to the specified size. Specify the file size in KB.
For example, if you specify file size as 30, all the files with size that is not equal to 30 size are selected.
Starts with DatePattern
Selects files that start with the specified date pattern. For Example, if you specify the file pattern as DD/MM/YYYY, all the files that start with DD/MM/YYYY date pattern are selected.
EndsWithDatePattern
Selects file that end with specified date pattern. If you specify the file pattern as DD/MM/YYYY, all the files that end with DD/MM/YYYY date pattern are selected.
Contains Date Pattern
Selects files that contain the specified date pattern. For example, if you specify the file pattern as DD/MM/YYYY, all the files that contain DD/MM/YYYY date pattern are selected.
Date Pattern Format
When you specify a date pattern to select files, you can specify the values in different formats.
The following table displays formats that you can use to specify Date Pattern:
Date or Time Component
Value Representation
Date Pattern Terminology
ERA Designator
Text
G
For example, If you want to specify the era as 20 AD, you can specify the value in GG:AD format, such as 20:AD.
Year
Number
y
For example, if you want to mention year as 2001, you can specify the value in yyyy:2001 or yy:01 format.
Month in year
Number
M
For example, if you want to mention year as June, you can specify the value in MMMM:JUNE or MM:06 or MMM:JUN format.
Week in year
Number
w
For example, if you want to specify the value as 45, you can specify the value in ww:45 format.
Week in month
Number
W
For example, if you want to specify the value as 2, you can specify the value in W:2 format.
Day in year
Number
D
For example, if you want to specify the value as 227, you can specify the value in DDD:227 format.
Day in a month
Number
d
For example, if you want to specify the value as 9, you can specify the value in dd:09 format.
Day of week in month
Number
F
For example, if you want to specify the value as 3, you can specify the value in F:3 format.
Day in week
Text
E
For example, if you want to specify the value as wednesday, you can specify the value in E:Wednesday format.
AM/PM marker
Text
a
For example, you can specify the value in aa:AM/PM format.
Hour in day (0-23)
Number
H
For example, if you want to specify the value as 15, you can specify the value in HH:15 format.
Hour in day (1-24)
Number
k
For example, if you want to specify the value as 24, you can specify the value in kk:24 format.
Hour in am/pm (0-11)
Number
K
For example, if you want to specify the value as 8, you can specify the value in K:8 format.
Hour in am/pm (1-12)
Number
h
For example, if you want to specify the value as 12, you can specify the value in hh:12 format.
Minute in hour
Number
m
For example, if you want to specify the value as 45, you can specify the value in mm:45 format.
Second in Minute
Number
s
For example, if you want to specify the value as 58, you can specify the value in ss:58 format.
Millisecond
Number
S
For example, if you want to specify the value as 450, you can specify the value in sss:450 format.
Time Zone
General Time Zone
z
For example, if you want to specify the value as 450, you can specify the value in sss:450 format.
Time Zone
RFC 822 Time
Z
For example, if you want to specify the value as 800, you can specify the value in zzz:800 format.
