Put simply, views are virtual-only and run the query definition when they’re accessed. Here’s an example of when you should use SQL views.

Example 4: AS/400 Short Alias Names in SQL Pass-Through Views This example demonstrates a problem in which AS/400 short alias names cannot be returned by the AS/400 ODBC driver.

Note: This example uses a Version 6 view descriptor with the Pass-Through Facility to access DBMS data. Beginning in Version 7, you can associate a libref directly with your DBMS data and use the ...