Your output file is adding a position for each line? like this:
aaaa
bbb
b cc
cc dd
You are having a problem with carriage return and line feed at the end of wich line. It's common when you pass files from Windows to UNIX. Check your ftp option when passing files between these environments.
Standardizing Business Address and Shipping Address
-
- Charter Member
- Posts: 560
- Joined: Wed Jul 13, 2005 5:36 am
- Location: Ohio
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
When you're processing Shipping Address, use a different file dictionary that identifies the business address fields as something innocuous.
Make sure that your data are, or are transformed to, fixed width so that there can be no ambiguity about what's in what column.
Make sure that your data are, or are transformed to, fixed width so that there can be no ambiguity about what's in what column.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 2
- Joined: Mon Apr 12, 2004 6:55 pm
Hi Ray,ray.wurlod wrote:When you're processing Shipping Address, use a different file dictionary that identifies the business address fields as something innocuous.
Make sure that your data are, or are transformed to, fix ...
When I spoke to IBM, thay told us to "stack" the data. That is to create a new record with shipping address instead of business address and to have an indicator telling what kind of address it is. This seems to make sense as it would help in matching. It seems a little cumbersome but I would like other dear contributer's comments on this approach.
Thanks,
Saad
p.s. how's the weather down under? It's freezing here!
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's sound advice. I wasn't aware you wanted to compare the addresses (since this wasn't in the problem as originally specified), which is why I was advocating two STAN stages/jobs each processing a different set of columns; I thought that all you wanted was standardization.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.