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 the maximum size of a char data type in db2?

1050


What is the role of union all and union

1185


How to find the number of rows in a db2 table?

1154


How do I delete a column in db2?

1152


How to check last update on table in db2?

1097


How to fetch the last row from the table in SQL (db2)?

1693


What r the comman abends in db2, jcl and cobol???????

2309


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

1174


What is the difference between nvl and coalesce?

1105


What is the use of value function?

1203


Is db2 a mainframe database?

1045


What are the uses of db2 optimizer?

1350


What is the reason behind not using select * in embedded sql programs?

1166


How to execute stored procedure in db2 command editor?

1097


When the like statement is used?

1280