What is the difference between nvl and coalesce?
No Answer is Posted For this Question
Be the First to Post Answer
The only place of VSAM KSDS in DB2 is?
Can a array declared with an index be displayed(readable format) in spool?
What is a db2 schema?
In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?
What is declare cursor?
What is a view? Why use it?
List down the data types in the db2 database.
what are stage one indexable predicates?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
What are the rules for db2 programming?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.