How many sub queries can you combine together ?
Answers were Sorted based on User's Feedback
What is universal database?
How does coalesce work?
which is the most efficient tablespace?? a.simple tablespace. b.partitioned tablespace. c.segmented tablespace. d.none of the above. please post answer with the reason.?
What does the CHECK Utility do ?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
why we go for SPUFI for creating tables or for sql queries?
How would you print the output of an SQL statement from SPUFI?
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
What is the difference between using bind () and rebind () methods of naming class?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What are concurrency issues?