What is the difference between nvl and coalesce?
No Answer is Posted For this Question
Be the First to Post Answer
What is read-only cursor?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How is the SUBSTR keyword used in sql?
is it compulsory commitment control in journal?
What is query for your birthday date should be in hours,minute and seconds format?
How connect db2 database to datastage?
How can deadlocks be resolved?
What types of tables are there in the db2 database?
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 is a collection?
what is difference between Static call and Dynamic call? How does it function?