Re: SCAN vs %scan

I like the REPLACE function, too - but I don't see that Steve wants to replace anything - he's only trying to find something - unless he mentions replacing later in the thread.

Someone else mentioned the main difference between them is that SCAN returns the position of all instances in an array, while %scan returns only the first instance that exists after the start position. I really like what SCAN does and wish it would be brought back into free-form.

If he only wants to know that a string is somewhere in a field, and doesn't need to know all of them, a SELECT using the POSSTR function is good, too. Or LOCATE, I think.

On 1/10/2012 8:24 AM, Rick.Chevalier@xxxxxxxxxxxxxxx wrote:

Have you thought about using the SQL REPLACE function? If 'Abc' is always going to be replaced with 'ABC' in every record maybe it would be faster to use SQL and operate on the records as a set.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-
bounces@xxxxxxxxxxxx] On Behalf Of sjl
Sent: Monday, January 09, 2012 1:12 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: SCAN vs %scan

has anyone benchmarked speed comparison of using SCAN versus %SCAN?

I inherited and am maintaining a fixed-format RPGIV program which uses
SCAN to scan strings for certain values (hundreds of occurences of the SCAN
opcode), and I am wondering if I can get any kind of performance
improvement if I change them to use %scan instead.

- sjl



--
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.

Privileged and Confidential. This e-mail, and any attachments there to, is intended only for use by the addressee(s) named herein and may contain privileged or confidential information. If you have received this e-mail in error, please notify me immediately by a return e-mail and delete this e-mail. You are hereby notified that any dissemination, distribution or copying of this e-mail and/or any attachments thereto, is strictly prohibited.