I am looking for some help on make changes to key fields within a record.
Essentially I have a key similar to the following:
int1 format "9"
int2 format "zzz9"
date format "99/99/9999"
cha1 format "x(4)"
int3 format "zzzz9"
cha2 format "x"
I am looking to change all records with int2 = 2 to int2 = 4 along with this i need to ensure that a sequence (int3) is increased if there is already a record with int2 = 4 and int3's equal.
Thanks for any help.
Essentially I have a key similar to the following:
int1 format "9"
int2 format "zzz9"
date format "99/99/9999"
cha1 format "x(4)"
int3 format "zzzz9"
cha2 format "x"
I am looking to change all records with int2 = 2 to int2 = 4 along with this i need to ensure that a sequence (int3) is increased if there is already a record with int2 = 4 and int3's equal.
Thanks for any help.