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 |
select 100 records from million records ?
What is package in cobol db2?
What does the REORG Utility do?
Can you define an Index if the table size less than 10 PAGES?
What is a system catalog table in db2?
what's the best lock size that you could use when you create a tablespace?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
What is db2 command?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
Why do we bind in db2?
What is iseries database?
What is ibm db2 connect?