SFL Load - SQL vs. LF

[michael@xxxxxxxxxxxxxxxxxx]

I'm developing a new application and would like some comments. The
application is a standard subfile, where the user can search by
different criteria (name, number, etc.). The traditional method would
be to have different logical files, each ordered by the search
criteria, and use SETLL and READE. I'm also thinking about embedded SQL
and selecting into a MODS. What would be the pros and cons of the
different approaches? Overhead? The record count is pretty small.
Complexity? I can make the SQL pretty reuseable.

TIA....