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 |
What are the two types of logging in the db2 database? Explain them.
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is universal database?
What are foreign keys in db2?
What are host variables in db2?
What does the sqlcode of -818 pertain to?
How do you stop a db2 database in linux?
What is runstats utility in db2?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
What is referential integrity?
Why do we need reorg in db2?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2