Hi John,

You might also take a look at the copy command. You could create a temp table structure from the source table something like:

select sourcetable,

copy structure to temptable

copy all to temptable where UPPER(substr(thefield))="S"

As you can see this would copy a subset of the source table to temptable. If sourcetable had an index, the records copied to temptable would also be ordered, so it might not be necessary to pass the index paramenter to the exe program. Maybe you could just pass the temptable name to the exe.

The copy command is very fast, much faster than a scan doing inserts, etc.

When done, zap temptable.

Just a thought.

I'm in Linux right now, so the syntax will be way off, but you will get the idea.


LelandJ