Re: characters to not use in files with sql and rpgle functions

Let me back up a bit...
I certainly agree proper sql can handle all characters, and
we have some old code around that have had to fix for
example: sql "select where like" and the parm passed for the
search value had single quote in it.
I guess I was looking to see if others had certain characters
they normally strip out and it seems not..
We do have in imports a check to remove characters not on a normal
keyboard, but that is not consistent, therefore trying to build a
standard list.
Jim

---- Scott Klement <midrange-l@xxxxxxxxxxxxxxxx> wrote:

there's nothing intrinsic to sql that prohibits certain characters.
therefore to help you, we'd need to know what characters your program(s)
cant handle...

--
Scott Klement http://www.scottklement.com

On Tue, 17 Aug 2010, franz400@xxxxxxxxxxxx wrote:

Need to develop a generic list of characters to strip in imported data from other systems that could cause problems in various sql processes. We trade data (import & export) with many systems, in many different formats, and sometimes issues, or we create issues for others when we pass data on.
Perhaps a better solution is to create a list of characters allowed and blank all others?
We do a fair amount of re-formatting names & addresses, using %replace, %scan in rpgle, sql "like" selects, etc.
Generally US data, but names from around the world.
Jim Franz


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.