null replaced by "^"
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
null replaced by "^"
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
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
Look again, the character after the carat is always an uppercase O in the sample you provided.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
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.
Use "cat -v {yourfile}" to find out which characters you really have.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
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
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact:
-
- Participant
- Posts: 98
- Joined: Thu Feb 05, 2009 1:14 am
- Location: visakhapatnam
- Contact: