Perform the following steps to change the MAXLENGTH attribute of
an existing custom field with the TYPE(NUM) attribute.
- Issue the RLIST command to review the attributes of the custom
field. Record the values for the MAXLENGTH, MAXVALUE, and MINVALUE
attributes.
Example:
RLIST CFIELD USER.CSDATA.SALRYCAP NORACF CFDEF
CLASS NAME
----- ----
CFIELD USER.CSDATA.SALRYCAP
CFDEF INFORMATION
-----------------
TYPE= NUM
MAXLENGTH= 00000006
MAXVALUE= 0000999999
MINVALUE= 0000000100
FIRST= NUMERIC
OTHER= NUMERIC
MIXED= NO
HELP= SALARY MAXIMUM, 3-6 DIGITS
LISTHEAD= SALARY CAP =
______________________________________________________________________
- Issue the RALTER command to update the values for MAXLENGTH and
other related attributes, as needed.
Example:
RALTER CFIELD USER.CSDATA.SALRYCAP
CFDEF(MAXLENGTH(8) MAXVALUE(99999999) MINVALUE(1000)
HELP('SALARY MAXIMUM, 4-8 DIGITS'))
______________________________________________________________________
- Reissue the RLIST command to review attributes of the updated
custom field.
Example:
RLIST CFIELD USER.CSDATA.SALRYCAP NORACF CFDEF
CLASS NAME
----- ----
CFIELD USER.CSDATA.SALRYCAP
CFDEF INFORMATION
-----------------
TYPE= NUM
MAXLENGTH= 00000008
MAXVALUE= 0099999999
MINVALUE= 0000001000
FIRST= NUMERIC
OTHER= NUMERIC
MIXED= NO
HELP= SALARY MAXIMUM, 4-8 DIGITS
LISTHEAD= SALARY CAP =
______________________________________________________________________
- Activate the new custom field using the IRRDPI00 UPDATE command
to refresh the dynamic parse definitions on each system that will
use the custom field. For instructions, see Steps for activating a custom field.
______________________________________________________________________
You have now changed the MAXLENGTH and other related attributes
for a numeric field using the RALTER command. You can now begin to
add data for the changed custom field.