Home > IT Answers > AS/400 > how to prevent values
9783444184
1,240 pts.
 how to prevent values
AS400 RPGLE, RPGLE values
how to prevent  these values &<>" in a field

Software/Hardware used:
ASKED: May 11, 2012  5:46 AM
UPDATED: May 15, 2012  1:22 PM
RELATED QUESTIONS
Answer Wiki:
If the only way to update a field in a file is programatically, you can add an edit to that program(s). We all know that files are updated many other ways: CPYF, DBU, UPDDTA, SQL, etc, the only solution is to add a trigger program to the file. In the program you can vaildate your field and then take whatever action you want. You may want to convert those invalid characters to blanks and sent out an an error message. Depending on the possible values in the field, you could just add a Constraint ADDPFCST
Last Wiki Answer Submitted:  May 11, 2012  1:22 pm  by  CharlieBrowne   32,835 pts.
All Answer Wiki Contributors:  CharlieBrowne   32,835 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

RPG supports calls to the regular expression API. It is designed to handle the situation you describe. However, unless you are familiar with regular expressions it may be a lot quicker to code up an RPG procedure.

WoodEngineer
 5,525 pts.
 

…in a field

What “field”? A database field? A field in the program? A display field? A Printer field?

Are those always going to be the only characters that must be prevented?

Tom

TomLiotta
 108,055 pts.
 

Hi Tom,
Display field entry field….

9783444184
 1,240 pts.
 

If it is a field being entered from a DSPF, they you need to add an edit in your program to check for those invalid characters..
You can then force an error an make the user correct the value.

CharlieBrowne
 32,835 pts.