What if we try to insert the base table through updatable
view , but failed to give a column value which is defined
as NOT NULL.
Answer / santy
get error code "-407"
-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the
object column defined as NOT NULL values.
| Is This Answer Correct ? | 11 Yes | 0 No |
What will the COMMIT accomplish?
Q3. How will you fetch duplicate values from a DB2 table?
What is syscat in db2?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
What is the STOSPACE Utility used for?
How would you find out the total number of rows in a db2 table?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
How to select the duplicate rows from a table?
What is DCLGEN?
what is the name of the default db2 catalog database?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Mention the various locks that are available in db2.