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

Explain about dbrm.

1037


Is db2 a programming language?

1041


What is scrollable cursor in db2?

1050


What is db2 plan table?

1044


Can one database have multiple instances?

1047


How to execute stored procedure in db2 command editor?

1047


What is a storage group (stogroup)?

1241


What is the syntax for seeing the columns and data types of a table in the db2 database?

1161


Before you give the explain statement, what are the prerogatives?

1024


If I have a view which is a join of two or more tables, can this view be updateable?

1139


Discuss about db2 bind?

1088


define clustering index.

1016


Which command is used to connect to a database in DB2 ? Give the Syntax.

1097


What is db2 stogroup?

1154


Is db2 relational database?

971