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 handle null values in db2

Answer Posted / biswamoy majumder

To insert a NULL, move -1 to the null indicator, To insert
a valid value, move 0 to the null indicator.
declare separately Null indictor variable in Working-
Storage section.
10 variable-NI pic s9(04) Usage comp.

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is copy pending and check pending in db2?

962


When reorg is used?

1082


What is the difference between bind and rebind in db2?

1405


What is the use of dclgen in db2?

1021


What are the rules for db2 programming?

1046


What is the maximum number of columns in a db2 table?

1229


How do I delete a table in db2?

1018


What is lock escalation in db2?

976


by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9035


Why db2 is called db2?

981


What are the 2 sqlcodes that are returned?

1140


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

2215


In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

1000


What is db2 purescale?

951


What is runstats db2?

970