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

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2837


Who uses db2?

1031


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2082


For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1100


What is db2 instance?

1072


What is difference between rollback and commit?

1151


What is the role of the data page in the db2 database?

1017


How do I delete a column in db2?

1103


How to check sequence on a table in db2?

1053


Is db2 a programming language?

1040


Define data page.

1056


How do we specify index to include or not during bind process.

2122


What are the 2 sqlcodes that are returned?

1181


What is page size in db2?

971


What is db2 bind process?

1233