I'm not sure about data validation on 5250 display... does it have a
of a "mask"?
As for database integrity, there is no substitute for check constraints.
you had them on, you would never have to worry about ANY method putting
"bad" data in (5250 or otherwise).
Using RPG built-in for input data validation will probably perform better
than embedded SQL call to a TRANSLATE function.
Celebrating 11-Years of SQL Performance Excellence on IBM i5/OS and OS/400
Subject: RE: Finding non-alphanumeric characters using SQL
That is a really cool idea! My question may need to go to the RPG list,
that would be my preferred language, but I have a similar problem to
The difference is that mine is a text entry field, so all normal
including punctuation are valid. I could just build up a list of valid
characters and use the technique, but I wonder if there is a "better" way.
I need to validate at input time as well as clean up the database (maybe -
might have fixed them all). The problem I have is people paste from email
and have characters that are not valid on a 5250 display. I'm not sure
it allows them to be entered, but it does. Any suggestion as to whether
below approach is better or if there is an easy way to check for
outside the "normal" range?
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives