Databases Reference
In-Depth Information
Choosing the operation
When we choose the type of operation, we again notice that the screen is different
from the file adapter, having an additional
File Type
category. This relates to the
Ascii
and
Binary
settings of an FTP session. ASCII causes the FTP transfer to adapt
to changes in character encoding between the two systems, for example, converting
between EBCDIC and ASCII or altering line feeds between systems. When using text
files, it is generally a good idea to select the ASCII format. When sending binary files,
it is vital that the binary file type is used to avoid any unfortunate and
unwanted transformations.
Selecting the file destination
Choosing where the file is created is the same for both the FTP and the file adapter.
Again, there is a choice of physical or logical paths. The file naming convention
allows us some control over the name of the output file. In addition to the
%SEQ%
symbol that inserts a unique sequence number, it is also possible to insert a date or
date time string into the filename. Note that in the current release, you cannot have
both a date time string and a sequence string in the file naming convention.
When using a date time string as part of the filename, files with the
same date time string will overwrite each other. If this is the case,
then consider using a sequence number instead.
