Remote Library Services (RLS) |
When using RLS, one of the best ways to reduce the amount of
data that needs to move through the network to the client session is to use
WHERE statement processing whenever possible. When WHERE statements are used,
the WHERE clause is passed to the server environment and interpreted. Only
the data that meets the selection criteria is transferred to the client environment
for processing.
If the data you are accessing is stored in an external
database, the WHERE statement is passed to the database and evaluated, if
possible. If the database cannot complete the evaluation, the server completes
it before returning any of the data to the client session. For examples of
using the WHERE statement, see Example 2, Example 4, and Example 6.
Copyright © 2008 by SAS Institute Inc., Cary, NC, USA. All rights reserved.