What do you mean by NOT NULL WITH DEFAULT? When will you
use it?

Answer Posted / s

NOT NULL WITH DEFAULT indicates that the column cannot
contain a NULL, if a user doesnt enter a value, DB2
generates the default.

Is This Answer Correct ?    20 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Which isolation level provides highest data integrity?

819


What is the difference between cursor and select statement?

857


what are bind concepts in db2 cobol?

834


What is dbrm library?

797


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2979


What is bind package and plan in db2?

805


What do you mean by between and in? Is between inclusive of specified range values?

875


How does coalesce work?

760


What is nvl in db2?

826


In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

857


What is the maximum size of varchar data type in db2?

864


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

977


What is meant by explain?

856


What is db2? Explain.

790


What are bind parameters in db2?

804