Posted: Mon Nov 04, 2013 3:33 pm Post subject: Omitting records with null value in field
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:
does anyone know the syntax for the first omit condition for the field starting in column 10? if i get one i should be able to do 'ands' modify the syntax for the next ones.
thanks
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).
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?
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
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum