Q4. How will you get the count of record without using COUNT verb in query?
Answer Posted / sasidharreddy
by using inspect
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
How does coalesce work?
Can one database have multiple instances?
How to take backup of table in db2?
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 ?...
What is a buffer in memory?
What is performance tuning db2?
What is check constraint. Explain with example.
What do you mean by cursor?
What is a bind card?
What is the syntax for creating a table in the db2 database?
What is node in db2?
What is buffer pool and list some of them?
What is access path in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is meant by union and union all?