August 17, 2023

tFileOutputEBCDIC – Docs for ESB 5.x

  2. Talend for ESB Docs
  3. Docs 5.x
  4. tFileOutputEBCDIC – Docs for ESB 5.x

tFileOutputEBCDIC

tFileOutputEBCDIC_icon32_white.png

Warning

This component requires an Oracle JDK to be functional.

tFileOutputEBCDIC properties

Component family

File/Output

Note that this component is deprecated. The EBCDIC handling capabilities are now fully
supported by Talend Data Mapper that comes with any Talend Platform
solutions. For more information about Talend Data Mapper, see Talend Data Mapper User Guide.

Function

The tFileOutputEBCDIC writes an
EBCDIC file based on various source data files, each of them with a
different schema.

Purpose

This component writes an EBCDIC file with data extracted from
files based on their schemas.

Basic settings

Property type

Either Built-in or Repository.

 

 

Built-in: No property data stored
centrally.

 

 

Repository: Select the repository
file where the properties are stored. The fields that follow are
completed automatically using the data retrieved.

 

Schema

Select an option from the list to edit either the Built-in or
Repository schema for the data to be processed.

Note

This list is enabled when you select the Custom set Original Length in
Schema check box.

 

 

Built-in: Select this option to
edit the Built-in schema for the data to be processed.

 

 

Repository: Select this option to
edit the Repository schema you select. The field that follows is
completed automatically using the schema you select.

 

File name

Click […] to browse to or type
in the path to the EBCDIC file containing the data to be
generated.

 

Edit schema

Click […] to edit the Built-in
or Repository schema for the data to be processed.

Note

This button is enabled when you select the Custom set Original Length in Schema
check box.

 

Xc2j file

Click […] to browse to or type
in the path to the xc2j file to transform the EBCDIC schema(s) into
an intermediary XML file.

Note

This field will be disabled and xc2j file will not be
needed when you select the Custom set
Original Length in Schema check box.

 

Custom set Original Length in Schema

Select this check box to improve the speed of reading files.

Note

When you select this check box, the Xc2j file field will be disabled and xc2j
file will not be needed and you are able to edit the
Built-in or Repository schema for the data to be
processed.

Advanced settings

Create directory if not exist

Select this check box to create a directory when the one you
specified does not exist.
 

tStatCatcher Statistics

Select this check box to gather the processing metadata at the Job
level as well as at each component level.

Global Variables

NB_LINE: the number of rows read by an input component or
transferred to an output component. This is an After variable and it returns an
integer.

ERROR_MESSAGE: the error message generated by the
component when an error occurs. This is an After variable and it returns a string. This
variable functions only if the Die on error check box is
cleared, if the component has this check box.

A Flow variable functions during the execution of a component while an After variable
functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl +
Space to access the variable list and choose the variable to use from it.

For further information about variables, see Talend Studio
User Guide.

Usage

Use this component to write an EBCDIC file and to output the data
separately depending on the schemas identified in the incoming
file.

Log4j

The activity of this component can be logged using the log4j feature. For more information on this feature, see Talend Studio User
Guide.

For more information on the log4j logging levels, see the Apache documentation at http://logging.apache.org/log4j/1.2/apidocs/org/apache/log4j/Level.html.

Scenario: Creating an EBCDIC file using two delimited files

Note

This scenario uses the [Copybook Connection]
wizard that guides users through the different steps to create a Copybook
connection and to retrieve the EBCDIC schemas. This wizard is available only for
users who have subscribed to one of the Talend solutions.
Otherwise, you need to drop the tFileInputEBCDIC
component from the Palette and set its basic
settings manually.

The following scenario is a three-component Job that aims at writing an EBCDIC-format
file using two delimited files with different schemas.

Use_Case_tFileOutputEBCDIC1.png

This Java scenario uses the [EBCDIC] Connection
wizard to set up a connection to the Copybook file and to generate an xc2j file, which
allows the retrieval and transformation of the different file schemas.

  • Create a connection to the Copybook file, which describes the structure of
    your EBCDIC file. In this scenario, the Copybook connection is called EBCDIC.
    For more information on how to
    set up a Copybook connection, see Talend Studio
    User Guide.

  • Retrieve the file schemas. For
    more information on how to retrieve schemas from the Copybook file, see
    Talend Studio
    User Guide.

Once the Copybook connection has been created and the schemas retrieved, using the
[EBCDIC] and [Schema] wizards, the new schemas appear under the node Metadata > Copybook. They
are called 01, 04 and
05.

To create an EBCDIC file based on two delimited files in Talend Studio :

  • Drop the following components from the Palette to the design workspace:
    tFileInputDelimited (x2) and tFileOutputEBCDIC.

  • To connect them together, right-click on each tFileInputDelimited component, select Row > Main in the contextual
    menu and click on the tFileOutputEBCDIC
    component.

  • Double-click on the first tFileInputDelimited
    component to display the Basic settings view
    and set the component properties.

Use_Case_tFileOutputEBCDIC2.png

  • In the File Name field, browse to the
    delimited file via the three-dot button […].

Warning

If the path of the file contains some accented characters, you will get an error
message when executing your Job. For more information regarding the procedures to
follow when the support of accented characters is missing, see the Talend
Installation and Upgrade Guide of the Talend solution you
are using.

  • In the Schema field, select Repository, then click the three-dot button and, when
    prompted, select the schema corresponding to your file, under the Copybook node.

  • In the Header field, set the number of fields
    that are used as “headers”, 1 in this example.

  • Set the properties for the second tFileInputDelimited component the same way as for the first
    component.

  • Double-click the tFileOutputEBCDIC component
    to display the Basic settings view and set the
    component properties:

Use_Case_tFileOutputEBCDIC3.png

  • In the Data file field, enter or browse to
    the directory path and the EBCDIC file name that is to be created based on both
    delimited files.

  • In the Xc2j file field, enter or browse to
    the path to the file allowing to extract the schema that describes the EBCDIC
    structure file.

  • Save your Job via Ctrl+S and click on the
    Run view, select the Statistics and Exec time check
    boxes then click Run to execute the Job.

Document get from Talend https://help.talend.com
Thank you for watching.
Docs 5.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x