how will you retrieve first record in table
Answer / saravana
select empname,empno from tablename order by empno fetch
first row only;
| Is This Answer Correct ? | 11 Yes | 0 No |
Plan has the optimized access path in it. But is that optimized access path is attained or known
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
What is a view? Why use it?
What is package in cobol db2?
How could one combine a set of incremental image copies into a single copy?
What is QUIESCE?
how to execute qcmdexc in rpgle?plz write code also?
What action db2 takes when a program aborts in the middle of a transaction?
Name some fields from SQLCA.
Where can you declare a cursor in a cobol-db2 program?
What are column-name qualifiers used?
What's the maximum number of volumes that can be added to a STOGROUP?