Answer Posted / manisha
DB2 bind is a type of compiler for SQL statements which
read sql statement from DBRM and produces a mechanism to
access data as divided by SQL statement being bound.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is cloudant database?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Mention some fields that are a part of sqlca.
What is the use of commit in db2?
How to create backup table in db2?
List down the data types in the db2 database.
Why do we use cursor?
What is a cursor in programming?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is db2 plan table?
What is the max length of sqlca?
Highlight all the advantages that are attached to a package.
What does a deadlock mean in DB2?
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?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
