Answer Posted / srinivas yadav
OPTIMIZER: IT CHOOSES THE BEST ACCESS PATH.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is null value in db2?
Is db2 relational database?
What is rct?
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 the maximum length of sqlca?
Comment whether the cursor is closed during commit or not.
Are views updateable?
How to run db2 command in windows?
What parameters are used to control the free space in DB2?
What is the difference between cursor stability and repeatable read isolation levels?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
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 do we specify index to include or not during bind process.
What is the physical storage length of date data type?
What is scrollable cursor in db2?