RE: SQLRPG with LIKE

["Joe Pluta" <joepluta@xxxxxxxxxxxxxxxxx>]

> From: Rick.Chevalier@xxxxxxxxxxxxxxx
> 
> What value is in FIC?  SQL wants something like this 'value%'.  If FIC
> contains the value only without % it will fail.  There is another
special
> character that works with LIKE but I can't recall it at the moment.

To add to this, with a fixed-length field even a '%' won't necessarily
work.

For example, if FIC contains "ABC%      ", it won't do what you expect,
because SQL interprets this as "starts with ABC and ends with six
blanks, with anything in between".  You'll get ABC and ABCD, but not
ABCDE.

Two workarounds:

1. Pad your compare field with wildcards.  Use either % or _ (underscore
matches any single character).  Thus, instead of "ABC%      ", use
"ABC%%%%%%%".

2. Use a varying length string.  Set the varying length string equal to
the %trim() value of your compare.

D FICTRIM         S             10A   Varying

C                   Eval      FICTRIM = %trim(FIC)
C/EXEC SQL 
(...)
C+ WHERE DBXATR = 'PF' AND DBXLIB = :BIB AND DBXFIL 
C+ LIKE :FIC 
C/END-EXEC


Joe