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

How to rename a table in DB2 ?

1145

What is concurrency?

1303

What are concurrency issues?

1170

What is temporal table in db2?

1099

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9355

What is blu acceleration in db2?

1126

What is precompiler in db2?

1075

Why do we use cursor?

1162

What is view db2?

1131

How does a cursor work?

1038

How can we read records for specific member in CL? AND rpg?

757

What action db2 takes when a program aborts in the middle of a transaction?

1192

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

11743

How to create db2 table in mainframe?

1217

What is phantom read in db2?

1223