What do you mean by NOT NULL WITH DEFAULT? When will you
use it?
- 3 Answers
- 17462 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
Comment whether the cursor is closed during commit or not.
What are db2 tables?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is package in cobol db2?
What is host variable?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is ibm db2 connect?
Is db2 free?
What is dbrm in db2 database?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Give the name of some fields form sqlca.
How would you find out the total number of rows in a db2 table?
How do I add a column in db2?
What are catalog tables in db2?
