Item name | Required / Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
Name | Required | Not available | Enter the name on the script canvas. |
Item name | Required / Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
File | Required | Available | Enter the file path to read a fixed-length.
Click [Browse] button to activate the file Selectr and Select the file. |
|
Format | Required | Not available | Select a file format definition that is fixed for global resources.
How to set the "Fixed-Length Wizard" Please for more information.
|
Item name | Description | Remarks |
---|---|---|
Preview | Start the previewer, display the contents of the file specified in [File]. |
|
Item name | Required / Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
Encoding | Required | Available | Select or input read file encode.
Use only the canonical name supported by Java SE Runtime Environment 8 when specifying the encoding directly in the field. Refer to "Supported Encodings"(http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html) for details. |
|
New line code | Required | Not available | Select a new line code.
|
|
Retrieves the suppressed characters as empty string | Optional | Not available | Select whether to retrieve the value of the field as an empty string or as null if it consists of suppressed character.
|
|
Retrieves the suppressed characters of the numeric type as 1 digit suppressed character | Optional | Not available | If the numeric data field is composed only of padding characters, this will determine whether the value of this filed is retrieve as a single padding character.
|
|
Item name | Required / Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
Mass data processing | Required | Not available | Select a data processing method.
|
Item name | Required / Optional | Use of Variables | Description | Remarks |
---|---|---|---|---|
Comment | Optional | Not available | You can write a short description of this adapter. The description will be reflected in the specifications. |
Component variable name | Description | Remarks |
---|---|---|
count | Return number of read columns. |
|
message_category | Stroes the category to which corresponding message code belongs to, when an error occurs. |
|
message_code | Stores its corresponding message code of occured error. |
|
message_level | Stores the severity of the corresponding message code of the occured error. |
|
error_type | Stores the type of the occured error. |
|
error_message | Stores the error message for the occured error. |
|
error_trace | Stores stack trace of the occurred error. |
|
Filed type |
Padding character | Field value | [Retrieves the suppressed characters as empty string] | [Retrieves the suppressed characters of the numeric type as 1 digit suppressed character] | Value retrieved |
---|---|---|---|---|---|
String | a | aaaaa | Not Checked | Not Checked | null |
String | a | aaaaa | Checked | Not Checked | Empty character |
Number | 0 | 00000 | Not Checked | Not Checked | null |
Number | 0 | 00000 | Checked | Not Checked | Empty character |
Number | 0 | 00000 | Not Checked | Checked | 0 |
Number | a | aaaaaa | Not Checked | Checked | null |
Number | a | aaaaaa | Checked | Checked | Empty character |
Exception name | Cause | Solution |
---|---|---|
ResourceNotFoundException Resource definition could not be found.Name:[] |
The [Format] is not specified. | Specify the [Format]. |
ResourceNotFoundException Resource definition could not be found.Name:[<Global Resource Name>] |
The resource definition specified in the [Format] is not found. | Make sure the global resource specified in the [Format]. |
InvalidPropertyConfigurationException
<Property name> is not specified. |
[<Property name>] is not specified. | Specify the [<Property name>]. |
FileIsDirectoryException | Path input in [File] is directory. | Input file path in [File]. |
StructuredTextParseException
Could not read the file in the specified format. |
The file specified in the [File] can not be parsed by the format specified in the [Format]. | Make sure the [File] or [Format]. |
java.io.FileNotFoundException | The file specified in [File] does not exist. | Check the [File]. |
java.io.UnsupportedEncodingException | The encoding that is not supported is specified in [Encoding]. | Specify an encoding that is supported in Java SE Runtime Environment 8.
Refer to "Supported Encodings"(http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html) for details. |