Interested to Buy Any Domain ? << Click Here >> for more details...
What do you mean by NOT NULL? When will you use it?
- 3 Answers
- 6341 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 |
Mention some fields that are a part of sqlca.
how can u nderstand the sql stmts executed successfully or not ?
What if we fail to give values in columns declared as NOT NULL ?
What is RUNSTATS?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
What is DCLGEN ?
How many sub queries can you combine together ?
What is view db2?
How do we specify index to include or not during bind process.
What is the use of predicate?
What is meant by explain?
what is the use of cursors?
COBOL 
