Using the Clean up alternate temporary library after a successful run option in SAS^® Data Integration Studio generates a DATASETS procedure delete code to delete the tables in the specified temporary library.

The generated code lists the tables in the temporary library for deletion in the order that they were created. This order cannot be changed.

This order causes a problem when the temporary library is a database library and the tables are nested views. When you delete the underlying view, the view that references it can no longer be deleted. The code results in an error similar to the following:

WARNING: File ATEMP.WWH3CX4.DATA does not exist.

However, the view still exists and is not deleted.

This issue occurs for certain databases, such as Netezza and SQL Server. This issue does not occur in Oracle.

Workaround

To work around this issue, do the following:

• Avoid using nested views.
• Change the order of the tables in the code manually using user-written code.