EBCDIC to ASCII conversion for '|' character

ArndW · Post by **ArndW** » Wed Sep 09, 2009 11:58 am

Do you have the hex value of both the EBDIC source and final ASCII characters?

ArndW · Post by **ArndW** » Wed Sep 09, 2009 1:42 pm

Standard EBCDIC 4f is a pipe symbol, so that is good. But after copying it to UNIX it should still be 4F, so i am not sure what your value of "O" means - if the value isn't 4F then the error isn't inside DataStage.

nagarjuna · Post by **nagarjuna** » Wed Sep 09, 2009 1:42 pm

Within the sequential file or complex flat file , Use cobol copy books to read the data in the file ....Also could you please let us know what are the options that you are using dd command ??

ArndW · Post by **ArndW** » Wed Sep 09, 2009 2:26 pm

Are you doing an explicit conversion from EBCDIC to ASCII in your CFF stage? Is that field declared as Char(1)?

alkanti · Post by **alkanti** » Wed Sep 09, 2009 2:59 pm

I tried to test it with sample file. I created only one character '|' in the file in ebcdic format. In CFF, I gave char(1) and character set = EBCDIC and the output is coming as '!' instead of '|'. Same thing is happening with SEQ FILE stage.

ArndW wrote:Are you doing an explicit conversion from EBCDIC to ASCII in your CFF stage? Is that field declared as Char(1)? ...

chulett · Post by **chulett** » Wed Sep 09, 2009 5:59 pm

Where did you create this sample file - on the Mainframe? If so, how exactly did you transfer it to the DataStage server?

ArndW · Post by **ArndW** » Thu Sep 10, 2009 1:15 am

As Craig has already hinted, the problem might be in a nonbinary FTP or transfer from the host. Just create a UNIX file with an ASCII capital "O" (4F) and then push that through your CFF stage to see if you still have the problem.

Klaus Schaefer · Post by **Klaus Schaefer** » Thu Sep 10, 2009 4:34 am

You may also check which EBCDIC codepage is being used at your host system and then set the environment variable APT_EBCDIC_VERSION accordingly.

Klaus

alkanti · Post by **alkanti** » Fri Sep 11, 2009 7:54 am

I have created a unix file with one character "O" on datastage host server and tried to read that from CFF, SEQ file stages and it is still getting converted into '!' instead of '|'. Is there anything to change in the Adminstrator?

Thanks
Kiran

ArndW wrote:As Craig has already hinted, the problem might be in a nonbinary FTP or transfer from the host. Just create a UNIX file with an ASCII capital "O" (4F) and then push that through your CFF stage to see ...

bcarlson · Post by **bcarlson** » Mon Sep 14, 2009 6:39 pm

Klaus Schaefer wrote:You may also check which EBCDIC codepage is being used at your host system and then set the environment variable APT_EBCDIC_VERSION accordingly.

Klaus

Any idea what APT_EBCDIC_VERSION is set to if it is not explicitly set? Where can I find it? I looked in Administrator at the project level settings and could not find it defined anywhere.

Thanks!

Brad.

adityavinay · Post by **adityavinay** » Mon May 20, 2013 7:32 am

If this issue is resolved, could you please post what have you done to fix this?

Thanks,
Aditya.

ray.wurlod · Post by **ray.wurlod** » Mon May 20, 2013 1:21 pm

No-one has marked it as Resolved.

adityavinay · Post by **adityavinay** » Mon May 20, 2013 1:45 pm

ray.wurlod wrote:No-one has marked it as Resolved. ...

I used "if" in my question as it is not marked as "resolved" .