Answer Posted / saravana
select empname,empno from tablename order by empno fetch
first row only;
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
How to execute stored procedures?
Mention the various locks that are available in db2.
What is release/acquire in bind?
Explain what are the various isolation levels possible?
What os does db2 run on?
What is the role of data manager in the db2 database?
what is the role of the cursor in db2?
What is difference between rollback and commit?
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 dclgen (declaration generator)?
How to find the maximum value in a column in the db2 database?
Define predicate?
What is difference between alias and synonym in db2?
List out the data types available.