How does coalesce work?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,


run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,


What is dbrm?

0 Answers  


Mention the downsides of page level lock.

0 Answers  


In a single table,How to retrieve a employee-id of an employee who works in more than one department?

15 Answers   Cap Gemini,






What are the various locking levels available?

3 Answers  


List down the data types in the db2 database.

0 Answers  


what is cursor stability?

2 Answers   IBM,


why we go for SPUFI for creating tables or for sql queries?

4 Answers  


wht is d/f between union and joins ?

2 Answers  


select distinct(empid),distinct(dept),name from EMP will the above query work?

2 Answers   CTS,


Why select is not preferred in embedded sql programs?

0 Answers  


Categories