Hi Ambrish 82
“suppose i want to access all records in which any field begins with ‘S’ …
how can i do this in RPG ILE without using %subst”
You asked how to limit access not how to read all records and only use selected records.
Access can be limited by:
– logical files with select or omit clause
– SQL select commands with where clause
– OPNQRY files with QRYSLT command
Did you want to explore any of these or change the question?
No wild card in RPG
if flda >= ‘S’ and flda <‘T’
D flda1 S 1 overlays(flda)
if flda1 = ‘S’