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?

Answers were Sorted based on User's Feedback



How do you retrieve the data from a nullable column?..

Answer / s

DB2 application must also include a null indicator host
variable along with the host variable to contain the actual
value.

Is This Answer Correct ?    6 Yes 1 No

How do you retrieve the data from a nullable column?..

Answer / 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

More DB2 Interview Questions

What is the use of db2 optimizer?

0 Answers  


Plan has the optimized access path in it. But is that optimized access path is attained or known

1 Answers   IBM,


PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,


What is a buffer in memory?

0 Answers  


what are stage one indexable predicates?

1 Answers  


how to check the table is empty or not?

3 Answers   IBM,


What is correlation names?

1 Answers  


What is dbrm?

0 Answers  


What is the role of union all and union

0 Answers  


Bind concepts in DB2 cobol

10 Answers   IBM, TCS, TRD, Virtusa,


If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?

1 Answers   RBS,


What is the usage of open cursor command?

0 Answers  


Categories