|
View previous topic :: View next topic
|
| Author |
Message |
Debasis Misra
Warnings : 1
New User
Joined: 16 Sep 2008
Posts: 72
Location: Bangalore
|
|
|
|
Hi,
I need to join 2 files using SYNCSORT. One file is having ACCT No is SIgned PD form at and another one is having in PD format.
1st file (Signed PD):
00008
1002C
2nd File (Unsigned PD):
00008
1002F
IS there anything in SYNCSORTconvert Signed PD to Unsigned PD? Please advise. |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
in any language the arithmetic comparison of PD fields will be well behaved
it will consider C/F as positive and D as negative
so for the sample posted the PD comparison will provide equality
by the way, for PD fields the unsigned/signed concept does not apply/does not have any meaning |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
One problem though. If Syncsort is like DFSORT in this, the JOINKEYS key is solely a BInary comparison, not arithmentic, so the bit-settings count.
Yes, you'd have to "normalise" one or the other, would be my guess. Refer to your Syncsort documentation for field types which are supported. |
|
| Back to top |
|
|
|
|
