Re: AW: Embedded RPG and the WHERE LIKE

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Also check the results of your sorting - I think that if you use 
*LANGIDSHR, that the order is more like ASCII. In particular, I've seen 
an instance that numbers are before letters in the sort, while with 
EBCDIC they are after letters.

But check this - it has been awhile.

On 11/16/2015 12:40 PM, Birgitta Hauser wrote:
> But keep in mind the SET OPTION alternative affects all queries executed
> within the same member/module.
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
>
> -----Ursprüngliche Nachricht-----
> Von: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im Auftrag von Brian
> Garland
> Gesendet: Monday, 16.11 2015 19:27
> An: rpg400-l@xxxxxxxxxxxx
> Betreff: Re: Embedded RPG and the WHERE LIKE
>
> Another option for case insensitive searches is to have the following at the
> start of your program
>
> EXEC SQL SET OPTION SRTSEQ=*LANGIDSHR
>
> This causes SQL to use a different character set where upper and lower case
> characters are weighted the same.  This does effect sorting (ORDER BY) too.
>
>
>
> --
> Brian J. Garland
> Vermont Information Processing, Inc.
> brian.garland@xxxxxxxxxx
>
> --
> This email and any files transmitted with it are confidential and intended
> solely for the use of the individual or company to whom they are addressed.
> Do not disclose, distribute, or copy this email to others outside your
> company. If you have received this email in error, please notify the sender
> immediately and delete this email from your system.
> --
> This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
> mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> http://archive.midrange.com/rpg400-l.