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
- 18955 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
What is performance tuning db2?
What is the max length of sqlca?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is db2 optimizer?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What does db2 stand for?
What is host variable in db2 cobol?
How do I create a view in db2?
What are host variables in db2?
What does reorg do in db2?
What is dbrm? What it contains?
What is runstats db2?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
