DB2 Warning

ramkarthik · Post by **ramkarthik** » Thu Jul 24, 2008 7:50 am

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

chulett · Post by **chulett** » Thu Jul 24, 2008 7:55 am

And?

Ask a question.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 24, 2008 3:04 pm

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).

chulett · Post by **chulett** » Thu Jul 24, 2008 4:38 pm

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.

ray.wurlod · Post by **ray.wurlod** » Thu Jul 24, 2008 5:36 pm

Is it just me, or wasn't the message "no rows affected"? Or is this a different thread? Odd, it's not even Monday!

chulett · Post by **chulett** » Thu Jul 24, 2008 5:37 pm

Different thread.

Posting from another airport lounge?

ray.wurlod · Post by **ray.wurlod** » Thu Jul 24, 2008 5:38 pm

Hotel room. Airport lounge is tonight (local time).

John Smith · Post by **John Smith** » Thu Jul 24, 2008 8:39 pm

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?