Question

RPG %SCAN Question

RPG IV, RPG, AS/400 Query

I am unable to get all the scanned records for a string in a file. For example, my file itemmast has 1000 records in it. When I use Query 400 and search for 'cable' I get 50 records with the word cable in various positions of a 30 character field. When I use the statement "x = %scan (xcust_pn : cpt#:1);" in RPG I get 15 records. If I replace the field xcust_pn with 'cable' I get all 50 records. What am I missing to get all 50 records in RPG using the %scan and the field xcust_pn.

Thank You,

Douglas L. McDuffie

Check your field len... If it is more than 5, then you scan for "CABLE " instead of "CABLE" If you still want to use a variable name, use X = %scan (%TRIM(xcust_pn) : cpt#:1) to get your result.

Good luck !

_______________________
DanTheMan