SELECT and suppress "Record xxx is not on file" error

[Greg Motter]

Ignorant question here, but I don't remember this being such an issue on Universe. But is there a way in a SELECT statement to suppress the "Record xxx is not on file" error? Can do this with a DuoSelect, but seems there should be an easier way to just suppress the errors which slow it down so much.

[Clifford Ponce]

If you are using an EXECUTE in a program to run the statement use the CAPTURING and RETURNING clauses to suppress screen output.

[David Lamoree]

If you haven't already resolved this, use the "(R" option at the end of the select statement.  For example: SELECT VENDOR (R.  This also works for the any other jBASE function (eg; SORT, LIST, COUNT, etc).