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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is iseries database?

1056


Explain about rct.

1093


What is nvl in db2?

1103


Is ibm db2 free?

1019


What is concurrency?

1240


What is the difference between oracle and db2?

1117


What do you mean by commit and rollback?

1049


Which component is responsible for db2 startup and shutdown?

1038


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2860


What is database manager in db2?

1027


Explain in brief how does db2 determine what lock-size to use?

1047


What is dbrm? What it contains?

1163


Explain correlated sub-queries.

1038


What is innodb buffer pool?

1063


What is rebind in db2?

1073