hello.

Wld appreciate for your help.

We have DB2 7.2 running on Windows.
We have scheduled ajob which inserts record in the table using the Task center.
After the script Runs Websphere datasource starts giving problem
It does not inserts data into the the specified table

But if we restart the websphere server it stsrts working fine again

wld appreciate your thoughts

thanks

ashaq

so what is the message / symptom you get
from db2 or websphere ?
any entries in diag.log - websphere logging ?
Best Regards, Guy Przytula

It returns,

SQL0100W No row was found for FETCH,
UPDATE or DELETE; or the result
of a query is an empty table.