DSXchange

HI ,

i am trying to delete a few data from a table where i have the delete permission.
the job is working fine. but is not deleting the data at the database end.
when i am running the same query in the database i am able to delete
the flow of the job is:

Sequential read - > copy --> Odbc ( delete from table where store_num <> '' )

after completion of the job with status=OK still it is not deleting the data

SQL server : 2000

Datastage version : 7.5.3

Parallel job

ODBC information is also added into uvodbc.config

Please explain how this is a comment about the DSXchange site/forum, and then post your question in the correct forum.

My apology for this mistake. any way to bring it back to the actual forum.

You can open a new thread there, or post a message here asking the moderator to move this thread to the correct forum.

Moderator: please move to parallel forum