Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...
The DICTIONARY tables component is specified in the FROM clause of a SELECT statement. DICTIONARY is a reserved libref for use only in PROC SQL. Data from DICTIONARY tables are generated at run time.
The following sequence of statements would be used in an OS/390 SAS session to establish a connection to DB2 and query the table SYSIBM.SYSTABLES: connect to db2 (ssid=db2p); select * from connection ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback