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 can u retrieve the data from null values using
applicaion program.

Answer Posted / bhavani

When we retrieve data from a nullable field, we need to
have a null indicator declared in the working storage.

WS-NULL-INDICATOR s9(04) comp

And after you have fetched the value for that column,

we need to check the value of the null indicator.

It can have the following values

-2 - Exceptional condition
-1 - Null Value is present in that field
0 - Not null

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is dbrm in db2 database?

1123


What is runstats utility in db2?

1024


Can you tell me how can you find out the # of rows updated after an update statement?

1101


Explain the function done by data manager?

1284


What are the different types of base tables?

1099


What is the maximum size of a char data type in db2?

1012


What is the role of schema in the db2 database?

1278


What is null indicator in cobol db2?

1068


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

1150


is it compulsory commitment control in journal?

2483


Which are the db2 tools to protect integrity of the database?

1124


What is null value in db2?

1030


What is meant by union and union all?

1012


Which component is used to execute the sql statements?

1102


What's The Percentage Free Space ?

1227