When Can you be sure that a query will return only one row?
Answer Posted / shankar
When you use CURSORS in your program.
or
when you use FETCH FIRST (n) ROW ONLY option on your SELECT
statement.
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is commit in db2?
What is the default page size of buffer pools?
What is database alias db2?
What is the maximum size of varchar data type in db2?
What is the role of union all and union
define clustering index.
What is the use of dclgen in db2?
What is nvl in db2?
What is reorg and runstats in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is page size in db2?
How can you quickly find out the # of rows updated after an update statement?
How do I change the column size in db2?
What is db2 catalog database?
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?