Return file from BAPI stage

getlaxman25 · Post by **getlaxman25** » Mon May 25, 2009 6:27 am

Hi,

I am using BAPI stage to load data to SAP. I have a problem in reading one column in the return file from BAPI. The column type is integer, but when I see in Unix the value comes as "". All other fields are coming correctly. Now I need to read "" back in datastage and interpret the actual value for this field.

Thanks in advance.

chulett · Post by **chulett** » Mon May 25, 2009 7:49 am

Sounds like it is extended ascii... can you check the file with a hex editor or "od -x" and see what the hex value actually is?

getlaxman25 · Post by **getlaxman25** » Tue May 26, 2009 12:48 am

I am not able to paste that character to the hex converter. Its not a hexadecimal character.

getlaxman25 · Post by **getlaxman25** » Tue May 26, 2009 4:09 am

The text is hex "03", "04", and "05" which stands for ETX (end of text), EOT (End of transmission), and ENQ (Enquiry) respectively.

arunsardana · Post by **arunsardana** » Tue Jul 21, 2009 2:51 pm

So I guess you can simply ignore that character as it indicates end of text (kind of end of file). Let me know if still issues and I should be able to assist.

Regards,
Arun

vjonnala1516 · Post by **vjonnala1516** » Wed Nov 11, 2009 9:42 am

Hi, while reading the return file use "tr -d" command on sequential file stage, for the confirmation just try the same on unix... you will get it done..