How to do a numeric check using easytrieve?

rsm_deepak · Posted: Thu May 20, 2010 10:41 am

I have a requirement as follows

If garbage data exists for some fields
a) move Zeroes in case of Numeric fields and
b) spaces for Non-Numeric fields

This needs to be done using Easytrieve only. Can any one help me in this regard?

PeterHolland · Posted: Thu May 20, 2010 12:13 pm

Its all in the reference manual :

IF fieldname [NOT] NUMERIC

NUMERIC tests for the digits 0 through 9 (in the correct format for the field's data type), and for a possible algebraic sign in the low-order position of type P fields or in the high-order position of type N fields.

IF fieldname [NOT] ALPHABETIC

ALPHABETIC tests for the characters A through Z or a blank space in each byte of the subject field.