MVSFORUMS.com

gore · Posted: Fri May 23, 2003 4:13 am Post subject: Binary fields in syncsort.

Hi,

I am using syncsort to pass records to an ouput file conditionally. I am using the following control statement :
INCLUDE COND=(27,8,BI,GT, X'hex equivalent of -9999999999')

The problem is the Binary field, it is defined as PIC S9(10) comp and it has both positive & negative values. but when I ckeck the output, only negative numbers GT the -9999999999 are being passed to output file. Numbers like +234556 are being filtered out. Can any one suggest a solution? I have checked that I am using the correct hexdecimal equivalent of -9999999999.

Thanks,
Gore

kolusu · Posted: Fri May 23, 2003 5:13 am Post subject:

Gore,

Try using FI instead of BI.

gore · Posted: Sun May 25, 2003 6:53 am Post subject:

Thanks kolusu. I found the same in syncsort manual too!!

gore · Posted: Tue May 27, 2003 7:12 am Post subject:

Hi,
Now I am facing another problem:
I have value in my binary field : 9223372036854775807 (PIC clause PIC S9(10) COMP)
When i am giving the following condition in my control card it is not selecting that record for output:

Frank Yaeger · Posted: Tue May 27, 2003 10:30 am Post subject:

For DFSORT, the limits for a decimal constant compared to an FI field with INCLUDE or OMIT are +2147483647 (X'7FFFFFFF') and -2147483648 (X'80000000'). Larger decimal constants are flagged in error by DFSORT. I suspect Syncsort has the same limits (I don't know why they don't flag it as an error).
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

gore · Posted: Thu May 29, 2003 12:42 am Post subject:

In the light of above discussion...
Can any one suggest me as to how to estructure this condition(I have to use syncsort.).