(Sorry, I didn't see a C# section so I didn't know where to post. ) Using: DB2 Advanced Enterprise Server, Version 10.1.200.238, Fix Pak 2is this a JAVA question or a C# question, if C# it should be in the C section also is it a language problem (C#) or a DB2 problem?

when you refer to timestamp are you referring to the timestamp datatype or setting the current system time.

It would be possible to do this executing the update as separate statement: UPDATE table SET column= CURRENT TIMESTAMP but since DB2 doesn't have a row ID on every row it is not possible to do this on exaclty the row which was selected before. Or do we have to add a row ID column to all tables on which we want to execute an update with a CURRENT TIMESTAMP value?

(That would really mean a lot of change, not sure if that's possible, so I'm hoping for another solution.) Thank you for any help!

Hello, I'm using C# to execute a SELECT on the Database.

The Result Set Data is then read and updated line by line using Db2Result Set.

The Client Data Set/Provider architecture allows you to specify a primary update table (and advanced features actually not covered in the book) and also customize the updates' SQL, as we partially saw in Chapter 14 and we'll further explore in Chapter 16, "Multitier Data Snap Applications." ADO supports an equivalent to cached updates called batch updates, which are similar to the BDE approach.AFCAT 2 2015 exam was conducted by Indian air force on across many AFCAT test centers in Indian.Many aspirants and future air warriors took part in the AFCAT 2 2015 exam and there was huge a crowd in all AFCAT centers.One of those is Multiple Active Result Sets or MARS.Multiple Active Result Sets is a new SQL Server 2005 feature that, putting it simply, allows the user to run more than one SQL batch on an open connection at the same time.