What do you mean by NOT NULL WITH DEFAULT? When will you
use it?
Answer Posted / shankar
when we specified NOT NULL WITH DEFAULT in the query ,the
database will set the default values to that key eg. system
date ,time.
| Is This Answer Correct ? | 9 Yes | 10 No |
Post New Answer View All Answers
List out the buffer pools in db2
What is a db2 collection?
How will you return the number of records in table?
What is buffer pool in the db2 database?
What do you mean by between and in? Is between inclusive of specified range values?
What is db2 stogroup?
What are db2 tables?
What is dbrm in db2 database?
What is a db2 schema?
Is db2 relational database?
How do I copy a table in db2?
What is db2 instance?
What are the various data types available in db2?
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 information associated with sysibm.syslinks table?