Simon Fraser University

Using a Pass-Through Query in a Subquery

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 ...
Simon Fraser University

CREATE INDEX Statement

Creates indexes on columns in tables. Restriction: You cannot use CREATE INDEX on a table accessed via an engine that does not support UPDATE processing. an IN subquery where the column in the inner ...
GitHub

sql-ref-syntax-qry-select-lateral-subquery.md

Licensed to the Apache Software Foundation (ASF) under one or more contributor license agreements. See the NOTICE file distributed with this work for additional ...