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...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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

Question Posted / angoca

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 are packages in db2?

1023

What is deadlock in db2?

1069

Which are the db2 tools to protect integrity of the database?

1120

Give the name of some fields form sqlca.

1077

What is buffer pool in the db2 database?

1103

What is load utility in db2?

1181

What is sqlca’s maximum length?

1186

What db2 400?

1189

Mention the way of highlighting as well as putting a cursor to use in a cobol program.

1077

What is the picture clause of null indicator variable?

1138

Is ibm db2 free?

1010

What is a db2 cursor?

1055

What is with ur in db2?

1316

What is the maximum length of sqlca?

1529

How do I delete a column in db2?

1109