Re: %scan not working as I'd expect...

[Luis Rodriguez <luisro58@xxxxxxxxx>]

Bryce,

I could be mistaken (often are :-) ) but, as I see it, your are searching
for 'HOSPITAL                      ' (lots of blanks) in your name1 string.
Try using %trim(), as in

pos = %scan(%trim(Criteria) : name1);

HTH,
Luis Rodriguez
IBM Certified Systems Expert — eServer i5 iSeries
--



On Wed, Nov 3, 2010 at 11:25 AM, Bryce Martin <BMartin@xxxxxxxxxxxx> wrote:

> I'm trying to use the %scan bif and it doesn't seem to be working.  I must
> really misunderstand how it works or something....
>
> short example....
>
>     D Criteria...
>     D                               30a             //parameter for my
> procedure.
>
>     D name1...
>     D                 s             30a
>     D pos...
>     D                 s             10i 0
>      /free
>        ....some sql code to populate name1.
>
>           pos = %scan(Criteria : name1);
>
>        ....some more code later on
>      /free
>
>
> I'm using a SEP to debug this.  When the %scan is performed the value of
> pos is being returned as 0.  Criteria = HOSPITAL, name1 = '**MY EXAMPLE
> HOSPITAL'
>
> Why is pos = 0?  HOSPITAL is CLEARLY in there...  shouldn't it return the
> position on the H?  Which in the real data for my first record I would
> expect to be position 19.  In this example I would expect it to return
> position 14.
>
> Am I missing something?
>
> Thanks
> Bryce Martin
> Programmer/Analyst I
> 570-546-4777
> --- This message (including any attachments) is intended only for the use
> of the individual or entity to which it is addressed and may contain
> information that is non-public, proprietary, privileged, confidential, and
> exempt from disclosure under applicable law. If you are not the intended
> recipient, you are hereby notified that any use, dissemination,
> distribution, or copying of this communication is strictly prohibited. If
> you have received this communication in error, please notify us and destroy
> this message immediately. ---
> --
> This is the RPG programming on the IBM i / System i (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.