Delete is not working in ODBC stage for SQL server 2000

Make suggestions regarding the DSX site or the Forum

Moderators: chulett, rschirm, roy

Post Reply
sunayan_pal
Participant
Posts: 49
Joined: Fri May 11, 2007 12:24 am
Location: kolkata

Delete is not working in ODBC stage for SQL server 2000

Post by sunayan_pal »

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
regards
sunayan
sunayan_pal
Participant
Posts: 49
Joined: Fri May 11, 2007 12:24 am
Location: kolkata

Post by sunayan_pal »

Datastage version : 7.5.3

Parallel job

ODBC information is also added into uvodbc.config
regards
sunayan
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Please explain how this is a comment about the DSXchange site/forum, and then post your question in the correct forum.
:roll:
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sunayan_pal
Participant
Posts: 49
Joined: Fri May 11, 2007 12:24 am
Location: kolkata

Post by sunayan_pal »

My apology for this mistake. any way to bring it back to the actual forum.
regards
sunayan
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply