Explain correlated sub-queries.
No Answer is Posted For this Question
Be the First to Post Answer
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What do you mean by between and in? Is between inclusive of specified range values?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
What is auditing?
What is the picture clause of null indicator variable?
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 a db2 table?
Can we update view in db2?
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 db2 connect?
How would you print the output of an SQL statement from SPUFI?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.