validating a numeric field using SYNCSORT

bijoybabu83 · New User Joined: 15 Jan 2007 Posts: 36 Location: Kerala

How can i validate a numeric field for alphanumeric values using SYNCSORT?

William Thompson · Posted: Tue Jan 16, 2007 3:17 pm

I do not think that is possible, why would you need to?

bijoybabu83 · New User Joined: 15 Jan 2007 Posts: 36 Location: Kerala

I need to write all records in a file whose one field contains alphanumeric values.I am using jcl sort to do that.

For example if UPC is a field in the file.This field should be always numeric.If any alphanumeric values are found in this field,My sort step picks that record as a whole and writes to another file....

I'm using INCLUDE AND OUTFIL functionality in sort step.

Can you help me.

William Thompson · Posted: Tue Jan 16, 2007 6:23 pm

I looked and I couldn't find anything other than a long byte by byte include/omit for GE '0' & LE '9'.....

Frank Yaeger · Posted: Tue Jan 16, 2007 10:21 pm

bijoybabu83,

If you happen to have access to DFSORT, you can use its NUM function with INCLUDE/OMIT as described at:

www.ibm.com/servers/storage/support/software/sort/mvs/peug/

Note that Syncsort does not have this function.