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
Delete is not working in ODBC stage for SQL server 2000
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 49
- Joined: Fri May 11, 2007 12:24 am
- Location: kolkata
Delete is not working in ODBC stage for SQL server 2000
regards
sunayan
sunayan
-
- Participant
- Posts: 49
- Joined: Fri May 11, 2007 12:24 am
- Location: kolkata
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 49
- Joined: Fri May 11, 2007 12:24 am
- Location: kolkata
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
Moderator: please move to parallel forum
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.