In the Teradata database, issuing the following SHOW command from Basic Teradata Query (BTEQ) software returns all of the table or view structure on which this view is dependent:

However, when you issue the same command through the SQL procedure's Pass-Through facility, as shown in the next example, Teradata only returns one dynamic data library (DDL).

Teradata returns the first part (via the Teradata CREATE MULTISET command) in a separate parcel, followed by the second part (via the REPLACE VIEW command) in a separate parcel. The Teradata engine in SAS/ACCESS® Interface to Teradata currently examines only the first parcel. As a result, only the first parcel is displayed.

The workaround for this problem is to issue a separate SHOW VIEW command if the requested object is a view, as shown in the following example.

Operating System and Release Information