DSXchange

Hi,

1.my file in as/400 is moved into unix box,
2.we could see the records from unix box into datastage and read in this manner
3.,we checked in source file but in place of null values ^ is present.

32001 CMP^O0010301^O^O0153


after CMP it is null and should keep 9 characters but it is redaing the next record .Ihad taken csv file with fixed width.When i am checking in csv view data i could see"^" in place of null.
4.When i opened as/400 file and saw the meatdat it fine.after moving it to
unix box and reading that file they is a problem.


So finally i require null characters in my view data in place of "^"

Thanks
sunitha

You are seeing a "^O" displayed. I don't know which tool you are using, but it could be ASCII 15. The value has probably been introduced during the move from the AS400 system.

How you moved the file from AS/400 to unix box ? If its ftp then which mode are you using ??

i moved my file s from as/400 to unix by using ascript

i moved my file s from as/400 to unix by using ascript and it is not "^0" ,is is only "^" ,here 0 is a record.

Look again, the character after the carat is always an uppercase O in the sample you provided.

I am using datastage server

I moved files through ftp with ASCII as the transfer type and the files are fixed width in the source system. How to handle these control characters in the output so that I am able to process the data further using DataStage?

The FTP program has done an EBCDIC to ASCII conversion (usually not a problem unless you have packed decimal fields). The EBCDIC Null maps to ASCII null so that isn't your issue.

Use "cat -v {yourfile}" to find out which characters you really have.

It appears to be ^0, null value in bin.

No, what is posted in an "upcaret-oh" as in "^" followed by the letter O... note the difference in the zeroes posted next to them. And also note this is one character not two.

Sainath - I assume the OP did a "cut-and-paste" in the original post, and there it is written with a capital O; I had the same original thought about the ^0. This is also why I want to get the "real" values, either with the grep -v command or with od -x

Hi,



32001 CMP^O0010301^O^O0153 here in place upcaret 9 null charcters should be placed but Ds is reading it as
32001 CMP(HERE NINE NULL CHARACTERS SHOULD BE PLACED in tenth positon
BUT IT IS READING AS"^"AND TAKING THE NEXT RECORD Into "zero" in the 11th position .
Thanks
sunitha

Hi,

I am not a not a Premium member so not able to see the whole message.
Thanks
sunitha

Hi,
have you checked both both AS400 System and unix server are
the same transfer ASCII.

Thanks,
Malli