I am using DB2 Database. Due to the performance issues I want use "FOR UPDATE" to update the records in DB.< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
Suggest me a way how to use “FOR UPDATE” in DataAdapter.
HOW TO USE "FOR UPDATE" in DataAdapter
Hot Topic
- load
- System.ArithmeticException (Overflow or underflow in the arithmetic operation.)
- What determines DateTime.Today.ToString() output?
- Editor
- System.Web.Mail and reply to field
- Storing program settings
- How to get the project name of a project while execute it?
- Whidbey
- Problem with timer and progress bar
- How to constrain generic type to a superclass instead a subclass of another type?
HOW TO USE "FOR UPDATE" in DataAdapter
Jivko Dobrev - MSFT
Hi,
As i know "FOR Update" is an optional clause in SELECT statement to check if the resultset is updatable or not.
I think you need to write the sql command to check how you can deal with it. Any way using SQL commands is strightforward you shouldn't have any problem if you are using DB2 Provider.
**Bob
Mujdat Dinc