Null value will allow only one null (That is maximum) as per DB2 stds. If

Can a unique index have more than one null value? If not,
what error code is given if an attempt is made to insert
more than one null value?

Question Posted / sri

3 Answers
7820 Views
I also Faced
E-Mail Answers

Answer Posted / sri

Null value will allow only one null (That is maximum) as
per DB2 stds. If we try to insert more we get error -305.

Is This Answer Correct ?

2 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is ibm db2 used for?

1080

What are packages in db2?

1023

What is host variable in db2 cobol?

1077

What are host variables in db2?

1072

How to find the number of rows in a db2 table?

1120

List down the data types in the db2 database.

1123

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2852

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

4312

What is dpf in db2?

1109

Define db2 and its databases?

1055

Can one database have multiple instances?

1054

Mention the different locking levels that are available in db2.

1134

Explain the function of data manager.

1044

What is package in db2 mainframe?

987

What is db2 stogroup?

1160