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
define clustering index.
What is bufferpool in db2?
Is the primary key a clustered index?
What are the contents of dclgen?
What is cursor stability in db2?
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 ?...
What is view db2?
What is the physical storage length of the data types date, time, and timestamp?
what is utility for parm lib
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How to execute stored procedure in db2 command editor?
Give the name of some fields form sqlca.
What is reorg?
Who uses db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.