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.

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.

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 ...

To view an article, run the view.sql script and give it an article ID. The article ID is the value displayed in the ID column in the hitlist generated by the query scripts. For example: @view 14 The ...