db2 Error

MURALI123 · Post by **MURALI123** » Tue Sep 15, 2009 2:41 am

Hi All,
while loading the data into db2 table i am getting the following
warning can anybody suggest how can we across.

SQLExecDirect: Returned success with info for statement 'DELETE FROM Table Name'. See following DB2 error for details.

[DB2/AIX64] SQL0513W The SQL statement will modify an entire table or view. SQLSTATE=01504

Regards,
Malli

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Sep 15, 2009 2:44 am

Try including a dummy clause

Code: Select all

where 1 = 1

MURALI123 · Post by **MURALI123** » Tue Sep 15, 2009 3:16 am

here in target we update action :
insert new rows and clear exciting rows

Regards,
Malli

chulett · Post by **chulett** » Tue Sep 15, 2009 5:30 am

That's what you get for clearing the exciting rows.