What if we fail to give values in columns declared as NOT
NULL ?

Answer Posted / mani

the above mentioned will happen provided there is no default
value specified at the time of defining the table.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we delete records from view?

652


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

801


what is the role of the cursor in db2?

720


What is the maximum size of a char data type in db2?

672


Define sqlca.

729






What is the difference between cursor and select statement?

714


What is a Foreign Key?

744


Who uses db2?

658


What are iseries servers?

644


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

668


How many databases can be created inside an instance in db2 ?

701


What is a bind in db2?

680


What db2 400?

795


What are packages in db2?

688


What is a system catalog table in db2?

683