MVSFORUMS.com

[newcobol]

i need to omit records with null value in a field. currently the only syntax in sort is sort=copy.
the file is ftp's up to the mainframe, the only description i have of the file is in the step after the sort that loads it to the table. this is the load card:

[newcobol]

i tried this so far but not working yet:

[newcobol]

it did not paste correctly. the asterisk marking the error should but under the X

[William Collins]

1) why have you defined the field as ZD?
2) is the value that you are testing for really binary zero, or is it space? Don't be confused by NULL (which has no value) and binary zero, which outside of the mainframe in data is often referred to as null (like a null-terminated field).

[newcobol]

i was told to define it that way. no one here is sure how to do this in the shop. the value im testing for is a null. after this sort, they dont want rows being loaded if there are null values. so this sort should not copy them all, it should omit the nulls. i am googling all over and reading manual, but not finding the syntax i need. what should it be defined as?

[William Collins]

If the correct value for indicating NULL is your case is binary zero, then use CH,EQ,X'00'.

[kolusu]

Your load card shows that the NULL value is a Space so you should be checking for a space instead of binary zeroes. Use the following

[newcobol]

you are right Kolusu, i got there last night with some trial and error. I was trying to understand the 'integer external' code in the load card and tried it this way and it worked. I am not sure i thoroughly understand what that load is doing

[papadi]

Suggest you study & understand why/how your code is working (and come back here and ask if there are doubts).

It is most important to understand what is running on our systems . . .
_________________
All the best,

di