Answer Posted / amarnadh reddy
If we set SQLCODE=100 means end of the table.
EX: if sqlcode=100
Display end of the table
end-if.
| Is This Answer Correct ? | 9 Yes | 1 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 run db2 command in windows?
How does coalesce work?
What is the difference between db2 and oracle?
Explain the function of data manager.
Can there be more than one cursor open for any program?
What is meant by explain?
What do you mean by commit and rollback?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is difference between alias and synonym in db2?
Mention the different locking levels that are available in db2.
Why cursor is used in db2?
When the like statement is used?
What is the maximum length of sqlca?
What os does db2 run on?
