Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / srini
Declare cursor instead of singleton select,as the query you
are running has multiple records.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a db2 schema?
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?
List out the three types of page locks that can be held.
Mention the various locks that are available in db2.
What is the default page size of buffer pools?
What is the role of schema in the db2 database?
Explain what are the various isolation levels possible?
What are the bind parameters ibm db2?
Define check constraint.
What is role in db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
Why do we use cursor?
What is the difference between cursor stability and repeatable read isolation levels?
How do I add a column to an existing table in db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
