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

What os does db2 run on?

570


How to find schema of a table in db2?

570


What is access path in db2?

562


When the like statement is used?

640


What is load replace in db2?

560






What is dpf in db2?

664


What is the advantage in De-normalizing tables in DB2?

745


What is null indicator in db2?

602


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

749


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

630


What is runstats and reorg in db2?

798


What is cursor in dbms?

591


What is cloudant database?

641


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.

2757


Explain about rct in db2?

640