Carlo Romagnano (2/2/2011)

---

Koen (da-zero) (2/2/2011)

---

No, it is TRUE.

You cannot use the /Set or the /Connection option to override single values that are also...

You have a to watch list? :w00t:

You scare me 🙂

(unless you mean a to watch list to offer him...

No, it is TRUE.

Ugh. If someone else wants to skip in on this thread.

Apparently English doesn't work...

:ermm:

Just like reading a thread on 4chan...

shanureddy (2/2/2011)

---

create TRIGGER parent_trigger ON parenttable

FOR update AS

begin

declare @id int

DECLARE @name VARCHAR(10)

declare @id1 int

select @id=id from inserted

select @name=name from inserted

select @id1=id from deleted

update childtable1 set id=@id,name=@name where id=@id1

update childtable2...

This is a weird thread:

http://www.sqlservercentral.com/Forums/Topic1057267-391-1.aspx

Apparently, halfway through the topic, the OP changes of user.

And then some guy walks in "hacking the question".

Weird stuff...

shanureddy (2/2/2011)

---

Not only changing the primary key column, we want to change remaining columns in the record..

By using on update cascade we can update the primary & foreign key...

Then UPDATE CASCADE would be the most obviously easy solution.

How many times are you updating a primary key?

Is it an option to go to the DB2 database and execute the source query there, just to see if it works?

What is the exact error that you get?

Is it possible to show us the source query that you have written?

You can also write a second UPDATE statement in your application logic,...

Use FTP?

Preferable an FTP tool that can resume an interrupted transfer, since you have fairly large files?

Please don't crosspost. It wastes peoples time and fragments replies.

Original thread with responses can be found here:

http://www.sqlservercentral.com/Forums/Topic1057264-391-1.aspx

If I understand your question correctly, you have two (easy) options:

* triggers

* UPDATE CASCADE

You can also write a second UPDATE statement in your application logic, that takes the updated IDs...