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? What it contains? When it will be created?

1050


Mention the length of physical storage of the given data types of db2 – date, timestamp, time

1077


How does a cursor work?

985


What's The Error Code For Unique Index Voilation?

1237


What is db2 bind process?

1237


What is table space in db2?

1016


What is a collection in db2?

1034


What is runstats db2?

1036


How do I create a view in db2?

1022


Can we delete records from view?

967


What is release/acquire in bind?

1103


What is db2 connect?

1068


What is a db2 tablespace?

1062


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

1653


What is netezza database?

1026