Page 1 of 1
DB2 Warning
Posted: Thu Jul 24, 2008 7:50 am
by ramkarthik
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
Posted: Thu Jul 24, 2008 7:55 am
by chulett
And?
Ask a question.
Posted: Thu Jul 24, 2008 3:04 pm
by ray.wurlod
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).
Posted: Thu Jul 24, 2008 4:38 pm
by chulett
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.
Posted: Thu Jul 24, 2008 5:36 pm
by ray.wurlod
Is it just me, or wasn't the message "no rows affected"? Or is this a different thread? Odd, it's not even Monday!
Posted: Thu Jul 24, 2008 5:37 pm
by chulett
Different thread.
Posting from another airport lounge?
Posted: Thu Jul 24, 2008 5:38 pm
by ray.wurlod
Hotel room. Airport lounge is tonight (local time).
Posted: Thu Jul 24, 2008 8:39 pm
by John Smith
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?