What do you mean by NOT NULL? When will you use it?
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 package versioning? Please give an example.
What is correlation names?
How many sub queries can you combine together ?
How would one remove old reorg information from the DB2 catalog?
what's the error code for Unique Index Violation?
What is the purpose of the WHENEVER statement?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
how can u nderstand the sql stmts executed successfully or not ?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
Is schema the same as database?
What is buffer pool?