topic Re: Read/Extract Data Mainframe in Talend Studio

Read/Extract Data Mainframe

Anonymous — Mon, 10 Dec 2012 02:05:14 GMT

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

Re: Read/Extract Data Mainframe

Anonymous — Mon, 10 Dec 2012 02:45:12 GMT

Hi,
So your problem is how to extra data from text file that do not contain any delimiter? I have designed a demo job as follows:
id name
1 shong
2 sabrina
tfileinputdelimited-->tLogrow
Is that what you need? Or Is your file fixed_length?
Would you give us an example of your source file(without delimiter)
see pics
Best regards
Sabrina

Re: Read/Extract Data Mainframe

Anonymous — Wed, 12 Dec 2012 02:52:07 GMT

Hi Sabrina,
I'm not sure that is accurate resolution since i received encoded data that contain of number in the whole file like '321900000000000003000000440300' and i need to break it accurately so that this encoded data can be translated properly.
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.
I'm personally hard to explain....

Regards,
Kal

Re: Read/Extract Data Mainframe

Anonymous — Wed, 12 Dec 2012 08:36:21 GMT

Hi,
The info about your requirement is a little for us. Would you get more info from user? Do you mean the data "321900000000000003000000440300" is ASCII? and encoding it into UTF8 or others? Need your confirmation.
Best regards
Sabrina

Re: Read/Extract Data Mainframe

Anonymous — Tue, 18 Dec 2012 07:33:18 GMT

Hi Sabrina,
I am Kal colleague. The data is in ASCII code.
You have any idea on that?
Regards,
Omie

Re: Read/Extract Data Mainframe

Anonymous — Tue, 18 Dec 2012 07:39:19 GMT

Hi,
What is your expected result? Encoding the ASCII code into what type? I think we can support encoding ASCII code in Talend.
Best regards
Sabrina

Re: Read/Extract Data Mainframe

Anonymous — Tue, 18 Dec 2012 07:53:33 GMT

Hi,
Our expected result is to translate it to readable text. Talend can do so?
Regards,
Omie

Re: Read/Extract Data Mainframe

Anonymous — Tue, 18 Dec 2012 08:35:48 GMT

Hi,
I have designed a demo job using component tChangefileEncoding and converting "ASCII" into "UTF-8". The result is "3.219E+29". Is it the readable test you mentioned? What's more, you can use "Custom" option to custom which type you want.
Best regards
Sabrina

Re: Read/Extract Data Mainframe

Anonymous — Tue, 18 Dec 2012 09:13:56 GMT

Hi Sabrina,
I try already but the output is still same data in code view.
Regards,
Omie

Re: Read/Extract Data Mainframe

Anonymous — Tue, 18 Dec 2012 09:17:04 GMT

Hi,
Would you mind sending your screenshot on the forum, just like what i give to you in #8, and i need take a look in your job.
Best regards
Sabrina

Re: Read/Extract Data Mainframe

Anonymous — Tue, 18 Dec 2012 09:27:47 GMT

Hi Sabrina,
I give you my sample data picture 1,
and my job picture 2
Regards,
Omie

Re: Read/Extract Data Mainframe

Anonymous — Tue, 18 Dec 2012 10:14:15 GMT

Hi,
Well, it is too small to see........
Best regards
Sabrina

Re: Read/Extract Data Mainframe

Anonymous — Wed, 19 Dec 2012 01:57:38 GMT

Hi Sabrina,
Now you can see the image?
Regards,
Omie

Re: Read/Extract Data Mainframe

Anonymous — Wed, 19 Dec 2012 08:06:01 GMT

Hi,
Not yet, can you see it in the forum? Well, you can send me a e-mail with these screenshots, which will be better.
Best regards
Sabrina

Re: Read/Extract Data Mainframe

Anonymous — Thu, 20 Dec 2012 04:41:26 GMT

Hi,
I attached once again the images. Capture1 is output, capture2 is input, and capture3 is the configuration.

Rgds,
Kal

Re: Read/Extract Data Mainframe

Anonymous — Thu, 20 Dec 2012 07:43:04 GMT

Hi,
I have noticed that, and please check the "Use Custom Input Encoding" item. The component tchangeFileEncoding will read your system type by default. You need change it into your type "ASCII".
Best regards
Sabrina

Re: Read/Extract Data Mainframe

Anonymous — Thu, 20 Dec 2012 08:22:40 GMT

Hi,
I also noticed that, these images produced by myself. If you refer to Omie's images, she've done exactly what you asked me to do now, the result still same...just like mine. Also, i've selected to the other type, still got the same output.
Regards,
Kal

Re: Read/Extract Data Mainframe

Anonymous — Thu, 20 Dec 2012 09:12:23 GMT

Hi,
I think we make a misunderstanding on your issue. i have consulted my leader and he said you don't really need to encoding your file but just want to get a readable text. I have known your requirement, using Talend to transfer the source file you got into readable text. Would you give some example, about the readable text? what exactly it look like? or tell us how do you get the source file, so that we can use the related component to help you. I don't think the Encoding is what you need. Because i have said it is the "3.219E+29" in 6#, which is not a readable text. Sorry for the inconvenient.
Best regards
Sabrina

Re: Read/Extract Data Mainframe

Anonymous — Thu, 20 Dec 2012 09:30:24 GMT

Hi,
This file is sample file from user and they said that the data has been retrieve from mainframe and they converted into delimiter file. I require to translate it and load it into target. Readable text means i wants to translate it.
Rgds,
Kal

Re: Read/Extract Data Mainframe

janhess — Thu, 20 Dec 2012 09:37:53 GMT

If this is mainframe data you need to know what the original encoding was (EBCDIC?) and what the output encoding is. I don't recognise the output as any obvious encoding. It would be useful if you could get a copy of the original before it was encoded so you know what you're trying to create.
It looks like it's a lot of mainframe fields for numeric data probably 8 characters each. They don't translate directly to text items. I've seen stuff like this years ago but would need to know what the original was to remind me of how to translate it.