Interested to Buy Any Domain ? << Click Here >> for more details...
What do you mean by NOT NULL WITH DEFAULT? When will you
use it?
- 3 Answers
- 18925 Views
- I also Faced
- E-Mail Answers
Answer Posted / kumar
Using 'NOT NULL WITH DEFAULT' you can also specify you own
values. INTEGER, SMALLINT will assigned with zero, CHAR,
VARCHAR will be assigned with spaces. DATE, TIME, TIMESTAMP
will be assigned with system DATE, TIME & TIMESTAMPE values
respectively.
As the table is declared with 'NOT NULL WITH DEFAULT',
there is no chance of getting the null values during data
fetch.
| Is This Answer Correct ? | 15 Yes | 2 No |
Post New Answer View All Answers
How to retrieve rows from a db2 table in embedded sql?
How many databases can be created inside an instance in db2 ?
Who uses db2?
What is node in db2?
What is package in cobol db2?
What r the comman abends in db2, jcl and cobol???????
What is concurrency?
Which component is responsible for processing sql statements and selecting access paths?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is the difference between oracle and db2?
What is the max length of sqlca?
How do we specify index to include or not during bind process.
What is meant by dclgen?
How to fetch the last row from the table in SQL (db2)?
What is data manager?
