COBOL File Source

The COBOL File Source object holds the ability to fetch data from a COBOL source file if the user has the workbook file available. The data present in this file can then be processed further in the dataflow and then written to a destination of your choice.

Video

Working with the COBOL Source Object In Astera Data Stack

  1. Expand the Sources section of the Toolbox and select the COBOL Source object.

  1. Drag-and-drop the COBOL Source object onto the dataflow. It will appear like this:

By default, the COBOL Source object is empty.

  1. To configure it according to your requirements, right-click on the object and select Properties from the context menu.

Alternatively, you can open the properties window by double-clicking on the COBOL Source object header.

COBOL Source Properties

The following is the properties tab of the COBOL Source object.

File Path: Clicking on this option allows you to define a path to the data file of a COBOL File.

Note: File Path registers files with extensions of .dat and .txt (Additionally, it can also register files with an .EBC extension)

For our use case, we will be using a sample file with an .EBC extension.

Encoding: This drop-down option allows us to select the encoding from multiple options.

In this case, we will be using the IBM EBCDIC (US-Canada) encoding.

Record Delimiter: This allows you to select the kind of delimiter from the drop-down menu.

(Carriage Return): Moves the cursor to the beginning of the line without advancing to the next line.

(Line Feed): Moves the cursor down to the next line without returning to the beginning of the line.

<CR><LF>: Does both.

For our use case, we have selected the following.

Copybook: This option allows us to define a path to the schema file of a COBOL File.

Note: Copybook registers files with the extensions of .txt and .cpy

For our use case, we are using a file with the .cpy extension.

Next, three checkboxes can be configured according to the user application. There is also a Record Filter Expression field given under these checkboxes.

Ignore Line Numbers at Start of Lines: This option is checked when the data file has incremental values. It is going to ignore line numbers at the start of lines.

Zone Decimal Sign Explicit: Controls whether there is an extra character for the minus sign of a negative integer.

Fields with COMP Usage Store Data in a Nibble: Checking this box will ignore the COMP encryption formats where the data is stored.

COMP formats range from 1-6 in COBOL Files.

Record Filter Expression: Here, we can add a filter expression that we wish to apply to the records in the COBOL File.

On previewing output, the result will be filtered according to the expression.

  1. Once done with this configuration, click Next, and you will be taken to the next part of the properties tab.

COBOL Source Layout

The COBOL Source Layout window lets the user check values which have been read as an input.

Expand the Source node, and you will be able to check each of the values and records that have been selected as an input.

This gives the user data definition and field details on further expanding the nodes.

  1. Once these values have been checked, click Next.

The Config Parameters window will now open. Here, you can further configure and define parameters for the COBOL Source Object.

Parameters can provide easier deployment of flows by eliminating hardcoded values and provide an easier way of changing multiple configurations with a simple value change.

Note: Parameters left blank will use their default values assigned on the properties page.

  1. Click Next.

Now, a new window, General Options, will appear.

Here, you can add any Comments that you wish to add. The rest of the options in this window have been disabled for this object.

  1. Once done, click OK.

The COBOL Source object has now been configured. The extracted data can now be transformed and written to various destinations.

This concludes our discussion on the COBOL Source Object and its configuration in Astera Data Stack.

© Copyright 2023, Astera Software