What is difference between isnull and coalesce?
No Answer is Posted For this Question
Be the First to Post Answer
What do you mean by between and in? Is between inclusive of specified range values?
How does DB2 determine what lock-size to use?
Explain the contention situations caused by locks?
What is a collection in db2?
What is dbrm in db2 database?
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
What is concurrency?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
What are the various locking levels available?
What is the meaning concurrency in the db2 database?
What language is db2 written in?
When is the authorization check on DB2 objects done - at BIND time or run time?