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 an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
wht steps we need will coding cobol and db2 pgm ?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
What is release/acquire in bind?
What is reorg and runstats in db2?
What is bind package and plan in db2?
what is static sql? what is dynamic sql? Give me details
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert