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 blu acceleration in db2?

1070


What is database reorganization?

1128


What is access path in db2?

986


what is utility for parm lib

2377


What is null indicator in cobol db2?

1067


Is it possible to create an Instance in DB2 using DB2 Control Center ?

1104


How is deadlock resolved?

1147


i want to maintain uniqueness on pdf without make lf??????????

2158


What is the information associated with sysibm.syslinks table?

1125


What is a cursor in programming?

1069


What is meant by explain?

1133


How to get the ddl of a table in db2?

1131


What do you mean by commit and rollback?

1044


What is commit in db2?

1056


Which components manage deadlocks in db2?

1071