Interested to Buy Any Domain ? << Click Here >> for more details...
What if we fail to give values in columns declared as NOT
NULL ?
- 3 Answers
- 9925 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / santy
we will get the sql error code "-407"
-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the
object column cannot contain the NULL values.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / mani
the above mentioned will happen provided there is no default
value specified at the time of defining the table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / santy_rathod007@yahoo.co.in
Please correct the above error defintation :-
-407 :- An UPDATE, INSERT or SET VALUE is NULL, but the
object column defiend as NOT NULL values.
| Is This Answer Correct ? | 2 Yes | 2 No |
How do I add a column in db2?
What is db2 bind process?
how 2 resolve the -311 sqlcode
How can we read records for specific member in CL? AND rpg?
what is the difference between declaring the cursor in WS section and Procedure division?
What is the syntax required for the creation of a cursor?
How to fetch the uncommited data from table ?
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 are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
What does DSNDB07 database do?
what is cursor stability?
What types of tables are there in the db2 database?
COBOL 
