AW: SQL Case Sensitive selection

Hi Marco,

The SET OPTION statement is only considered at compile time, but not at run
time.
The SET OPTION statement can be compared with the H-Specs, containing
compiler options.

One solution would be to use SRTSEQ = *LANDIDUNQ in combination with dynamic
SQL.
Something like the following statement (not tested!)
 /Free
    MySQLStm = 'SELECT ....... WHERE ';
    If  pCase = Yes;
        MySQLStm += ' MyField like ''%' + %Trim(MySearch) + '%''';
    Else;
        MySQLStm += ' Upper(MyField) ''%Upper(' + %Trim(MySearch) + ')%''';
    EndIf;
 /End-Free
C/EXEC SQL   Prepare ....
C/End-Exec


Mit freundlichen Gru?en / Best regards

Birgitta

"Shoot for the moon, even if you miss, you'll land among the stars."
(Les Brown)

-----Ursprungliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]Im Auftrag von Marco Velazquez
Gesendet: Donnerstag, 9. Marz 2006 22:20
An: rpg400-l@xxxxxxxxxxxx
Betreff: SQL Case Sensitive selection


I'm trying to provide users with the ability to toogle between making their
search case-sensitive or not by using the following:

  * Case-sensitive selection
 c                   if        pCase = Yes
 C*/EXEC SQL
 C*+   SET OPTION SRTSEQ = *LANGIDUNQ
 C*/END-EXEC
 c                   else
 C*/EXEC SQL
 C*+   SET OPTION SRTSEQ = *LANGIDSHR
 C*/END-EXEC
 c                   endif

However this is not having an effect on the result set...   Does anybody has
any ideas?

Thanks,

Marco.
--
This is the RPG programming on the AS400 / 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.