This option is used to enhance the performance of the SELECT commands on different tables (that is, SQL and native I/O) because SQL, using ODBC, doesn't handle table operations the same way as native I/O on System i. This option supersedes the SELECT command's option: *ENDWHERE.

This option allows developers to handle specific SELECT commands in the most appropriate manner according to the WHERE condition. It signals the LANSA system to interpret ALL *ENDWHERE options in SELECT commands as though *ENDWHERESQL had been coded. It is recommended that, as code is updated or new code is written, that the SELECT commands are changed to use this new option where it is appropriate.