What if we fail to give values in columns declared as NOT
NULL ?
Answer Posted / mani
the above mentioned will happen provided there is no default
value specified at the time of defining the table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
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 bind in db2?
What is the latest version of ibm db2?
What is the maximum No of rows per page?
How to view db2 table structure?
What action db2 takes when a program aborts in the middle of a transaction?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is a db2 table?
Define buffer pool.
What is db2 catalog database?
What are foreign keys in db2?
Which are the db2 tools to protect integrity of the database?
What is release/acquire in bind?
How to find the maximum value in a column in the db2 database?
Explain the contention situations caused by locks?