Interested to Buy Any Domain ? << Click Here >> for more details...
What do you mean by NOT NULL? When will you use it?
- 3 Answers
- 6483 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / s
NOT NULL disallows nulls for the column. Primary Key must
be defined as NOT NULL or any key that you do not want to
have NULLS, becaue the default is that any column can
contain NULLs
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / andank
NOT NULL is the keyword used define columns, when create a
table. When you specify NOT NULL to a column, that column
can not hold NULL values.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / s
CREATE UNIQUE WHERE NOT NULL INDEX index1
ON table(column);
WHERE NOT NULL ensures that non-null values are unique.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is meant by dclgen?
What is the physical storage length of the data types date, time, and timestamp?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Which component is responsible for db2 startup and shutdown?
what's the best lock size that you could use when you create a tablespace?
How and when does the db2 enforces the unique key?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What are union and union all?
What are data types?
What is the significance of DB2 free space and what parameters control it?
What is the meaning concurrency in the db2 database?
What does db2 blu stand for?
COBOL 
