Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 1 Answers
- 6706 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 is release/acquire in bind?
What is meant by isolation level?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
Name some fields from SQLCA.
Which component is responsible for processing sql statements and selecting access paths?
What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?
What is dclgen (declaration generator)?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
Can we install 2 different versions of Db2 on same mainframe?
How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)
can we view the access paths created by dbrm ? how ? thx
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
COBOL 
