How to view data in datastage with EBCIDIC file

kamaldeep.kaur · Post by **kamaldeep.kaur** » Tue Mar 13, 2007 10:51 pm

Hi All,

I m converting a EBCIDIC file into the fixed width ASCII file ,but i m not able to view data in the source stage itself , how can i convert the above file ?

kumar_s · Post by **kumar_s** » Wed Mar 14, 2007 2:58 am

What is source stage that you are using. CFF (Complex Flat File) plugin is very suitable stage to do this job.

kamaldeep.kaur · Post by **kamaldeep.kaur** » Wed Mar 14, 2007 3:53 am

but i have restriction to use only Sequential file stage for the source.

kumar_s · Post by **kumar_s** » Wed Mar 14, 2007 4:39 am

How are you reading the data as? I mean which format? Irrespective of "View Data" would you able to run the job without any error? Hope you are using Transformer to convert to Ascii.
By the way, why was the restriction?

kamaldeep.kaur · Post by **kamaldeep.kaur** » Wed Mar 14, 2007 6:05 am

Ya, i m using transformer to convert the data(but the transformer is holding the direct move)
I m able to run the job but the data is not actually converting,the source file is fixed width.

kumar_s · Post by **kumar_s** » Wed Mar 14, 2007 6:33 am

What is the data type you are using to read the data?

ray.wurlod · Post by **ray.wurlod** » Wed Mar 14, 2007 7:01 am

kamaldeep.kaur wrote:but i have restriction to use only Sequential file stage for the source.

Always push back on (that is, resist) insane requirements. Demand justification. Would they expect you to tighten screws with a spanner? You have the right tool; insist upon the right to use it. It's not as if it's not in the toolbox.

DSguru2B · Post by **DSguru2B** » Wed Mar 14, 2007 8:15 am

If your truely on PX then in sequential file stage, under format tab, you have Type defaults. Under type defaults you have String. String has a property Export EBCDIC as ASCII. Look into that. This property will enable you to read a binary file via sequential file stage.