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 do you retrieve the data from a nullable column?

Answer Posted / amol

We have to include one variable in working storage datatype
s9(4).

and while retriveing the value from nullable column we can
give ;host variable :null indicater. If value from column
is found to be null it will stoare in null indicater.

If we have not include the null indicater and value while
fetching found to be null the program will abend with
saqlcode -305.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the maximum No of rows per page?

1011


What is db2? Explain.

987


How many databases are there?

989


What is dbrm? What it contains? When it will be created?

991


What type of database is db2?

910


What are the 2 sqlcodes that are returned?

1128


What is a db2 cursor?

1004


what is db2 restart?

2101


What is a db2 collection?

981


What do you mean by storage group (stogroup)?

984


How can we read records for specific member in CL? AND rpg?

644


What is the use of predicate?

983


How can you classify the locks in db2?

1032


Explain correlated sub-queries.

976


How does cobol compile db2 program?

1005