1. HP72LoadCustSegETLTable..LoadETLCustSeg: SQLExecDirect: Returned success with info for statement 'DELETE FROM UHCDM001.ETL_CUSTOMER_SEGMENT'. See following DB2 error for details.
2. HP72LoadCustSegETLTable..LoadETLCustSeg: [IBM][CLI Driver][DB2/AIX64] SQL0513W The SQL statement will modify an entire table or view. SQLSTATE=01504
You have executed DELETE FROM table WHERE condition and no row in the table meets the condition. DB2 has returned an informational message showing you that this has obtained. Because it is an "unusual" event, DataStage logs it as an alert (warning).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Was really hoping for a question to respond to. And actually, the informational message is because there is no where clause and it deleted every record from the table.
Hopefully, that's what they intended.
-craig
"You can never have too many knives" -- Logan Nine Fingers
You can ignore the warning if you know what you are doing because DB2 is warning you that you are deleting ALL records from your table using the SQL statement. Is that what you want to do?