Is have a DBMS SQL Flow in DataMigrator (7706M) with a DB2 bulk load as target. Somehow this bulk load is not providing a return code > 0 when it runs into a sql error. See log below:
Starting bulk load procedure 09/27/2015 11:12:17 CONNECT TO DWHDB USER wsuser USING 09/27/2015 11:12:18 DB20000I The SQL command completed successfully. 09/27/2015 11:12:18 SQL0964C The transaction log for the database is full. SQL STATE=57011 09/27/2015 11:12:18 CONNECT RESET 09/27/2015 11:12:18 DB20000I The SQL command completed successfully. 09/27/2015 11:12:18 QUIT 09/27/2015 11:12:18 DB20000I The QUIT command completed successfully. SQL0964C The transaction log for the database is full. SQLSTATE=57011 Statistics not available for target file amd_etl/amd_babhis Ending bulk load procedure Return Code = 0
The SQL error is passed on to the ETL log, but nevertheless the return code = 0. I would like to have a return code > 0, so in the process flow I can take appropriate action. Is there a way to catch the error situation?
Martin.This message has been edited. Last edited by: <Kathryn Henning>,
WebFocus 8206M, iWay DataMigrator, Windows, DB2 Windows V10.5, MS SQL Server, Azure SQL, Hyperstage, ReportCaster
October 05, 2015, 10:08 AM
Clif
Please open a hottrack case if you have not already done so.