Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to resolve -407 sql code in DB2?

Answer Posted / anandrao

This error occures when you are assigning NULL value to NOT
NULL column.
You can wrap the variable with coalesce/value and default
it but it is totally dependant on business logic.

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is bind plan?

1048


Which component is used to execute the sql statements?

1096


What is consistency token in db2?

1145


What is dbrm?

1105


How do you eliminate duplicate values in db2?

1194


What is the maximum size of varchar data type in db2?

1137


What is the advantage in De-normalizing tables in DB2?

1181


How is deadlock resolved?

1148


What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1160


Is it possible using max on a char column?

1141


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

1148


How can you do the explain of a dynamic sql statement?

1069


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

1149


what is diffrence b/w file-aid tool and file-aid utility???

4892


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

2947