ORDER BY DB2 Order by clause is used to sort the result table values by the sort Key order. Here, sort key can be the column name or column number. Results can be sorted either by Ascending (ASC) or by Descending (DESC) order. ASC is the default order by clause. If you do not specify [...]
Archive for the ‘Database’ Category
DB2 Isolation Level details
October 21st, 2012
admin In DB2 or in any Relational databases, the concurrency & data integrity is the key factor. Concurrency is the feature that makes multiple applications or users to access the resources at the same time without affecting each other’s work. Concurrency control is important as without the proper concurrency the applications may end with an invalid [...]
DB2 Locks and Importance of Concurrency Control
September 3rd, 2012
admin Locks & Concurrency: Concurrency is the feature that makes multiple applications or users to access the resources at the same time without affecting each other’s work. It makes the applications/users to share the resources interactively at the same time by using the locking concept. Concurrency control is important as without the proper concurrency the applications [...]

Posted in
Tags:

