Read/Extract Data Mainframe

[Anonymous]

Hi,
I just wonder how do i wants to extract data from mainframe?
I got the data as text file that do not contain any delimiter? Is there any way Talend can handle this matter?
Plz help me

Rgds,
Kal

[Anonymous]

if it is EBCDIC file then you can verify it using hex mode, open file in Hex mode and then send attached the screen shot i think this will help others to give you solution. another way is use Cobol copy book to parse the EBCDIC file with component named as EBCDIC file input.
One more thing changing Encoding of EBCDIC file will not work you have to parse it then transfer it readable format

[Anonymous]

Hi All,
Thanks for your support. I just met the user and they said it is no need to translate it. However, they need to break that code into respective size of characters.
Is it possible for me to break it into each sizes and is Talend able to read the size and break it based on size defined in excel file?
Meaning that, there are 2 files provided. 1st file is text file containing code extracted from mainframe and 2nd file is excel file contain of size needed to break the code inside text file. I used tFileInputPositional to break it size per sizes.
regards,
Kal

[Anonymous]

Hi,

I used tFileInputPositional to break it size per sizes.

I agree with you that tFileInputPositional is a suitable component for your requirement. It can break your resource file into each sizes.
Best regards
Sabrina

[Anonymous]

Hi,
Indeed, but if i put the sizes in excel file and then i wants my ETL job to read the excel file with sizes and then set it up automatically to tFileInputPositional the sizes to break the resource files without manually set the sizes on it...is it possible?

Regards,
Kal

[Anonymous]

Hi,

i wants my ETL job to read the excel file with sizes and then set it up automatically to tFileInputPositional the sizes to break the resource files without manually set the sizes

It is possible to do that. Using tContextload-->tFileInputPositional. Please see the related technology article from Talend Help Center https://help.talend.com/search/all?query=tContextLoad&content-lang=en
Best regards
Sabrina

[_AnonymousUser]

According to user they retrieve info from mainframe (not sure what it is) and convert it into textfile with encoded info and that's why nobody can understand the info and only after translate it back to analog.

[janhess]

If the user can't tell you what the data is then there is no way you can construct it.
The data looks like a string of value fields. You need to know the length of each field and use tFileInputPositional to split it up.