What if we fail to give values in columns declared as NOT NULL ?

What if we fail to give values in columns declared as NOT
NULL ?

Question Posted / mangesh

3 Answers
9943 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What if we fail to give values in columns declared as NOT NULL ?..

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

What if we fail to give values in columns declared as NOT NULL ?..

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

What if we fail to give values in columns declared as NOT NULL ?..

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

Post New Answer

More DB2 Interview Questions

How to rename a table in DB2 ?

0 Answers MCN Solutions,

When reorg is used?

0 Answers

What is db2 optimizer?

0 Answers

What is the function of logging in the db2 database?

0 Answers

What is the difference between Where and Having Clause

7 Answers IBM, iFlex,

SI Stud name Subject Marks Pass/Fail 1 Sham Maths 40 P 1 Sham Physics 50 P 1 Sham Bio 20 F 2 Ram Maths 40 P 2 Ram Physics 50 P 2 Ram Bio 60 P For the above data , write the SQL query for the student who passed in all the subjects . For eg : I want the data of only Ram coz he passed all subjects .

2 Answers Cognizant,

How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?

1 Answers

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?

1 Answers

i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

0 Answers TATA,

What is the difference between IN subselects and EXISTS subselect?

1 Answers HCL, PreVator, TCS,

what are the SQL codes u freequently got?

2 Answers Logica CMG,

List out the three types of page locks that can be held.

0 Answers

For more DB2 Interview Questions Click Here