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 check for a null value in a db2 column?

Answers were Sorted based on User's Feedback



How do you check for a null value in a db2 column?..

Answer / guest

You use a null indicator on the colunm and if the null
indicator = -1 then the column has a null value.

Is This Answer Correct ?    32 Yes 0 No

How do you check for a null value in a db2 column?..

Answer / angoca

By querying the catalog
select nulls
from syscat.columns
where tabschema like 'XX%'
and tabname = 'YY'
and colname = 'ZZ'"

Or with the describe command
db2 describe table ZZ.YY

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More DB2 Interview Questions

List down the data types in the db2 database.

0 Answers  


What is ALTER ?

3 Answers  


What is a view? Why use it?

2 Answers  


What is null indicator in db2?

0 Answers  


What is a cursor and what is its function?

2 Answers  


could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..

5 Answers  


Can there be more than one cursor open for any program?

0 Answers  


What is bind in db2?

0 Answers  


What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,


What is a host variable?

3 Answers  


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  


I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?

3 Answers   CTS,


Categories