Some Failed to execute errors may be displayed during the first run of the above command in DB2 Universal Database™. The errors are typically of the following type and may be ignored:
[sql] Failed to execute: DROP VIEW YNA_STATUS_VW
[sql] com.ibm.db2.jcc.b.SqlException: DB2 SQL error: SQLCODE: -204,
SQLSTATE: 42704, SQLERRMC: STAGING.YNA_STATUS_VW
Some other Failed to execute errors could be displayed when running the above script from Windows operating system on the DB2 Universal Database. The errors are typically of the following type and may be ignored:
[sql] Failed to execute: DROP VIEW YNA_STATUS_VW
[sql] com.ibm.db2.jcc.b.SQLException: A result has opened by the previous
getResultSet() or getUpdateCount() call, Need to call getMoreResults()