DB2 Warning Msgs

JDionne · Post by **JDionne** » Mon Jul 26, 2004 12:04 pm

How do i stop these msgs from db2?

EXP2LUReconcilation..US_Port.ETL_US_Port_Lu_Tbl: SQLExecDirect: Returned success with info for statement 'DELETE FROM DB2ADMIN.STG_ETL_US_PORT_LU_TBL'.  See following DB2 error for details.

and

Code: Select all

EXP2LUReconcilation..US_Port.ETL_US_Port_Lu_Tbl: [IBM][CLI Driver][DB2/NT] SQL0513W  The SQL statement will modify an entire table or view.  SQLSTATE=01504

Jim

peterbaun · Post by **peterbaun** » Mon Jul 26, 2004 2:32 pm

Hi Jim,

As far as I know you can't. We have decided to use the "Before SQL" tab in the DB2 plugin for emptying the tables where we need to do this in order to avoid the warning message. Running on AS400 we also add the "with none" clause to the sql in order to reduce the log information produced hence getting a little better performance.

Regards
Peter