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 the max length of sqlca?

1273


Explain what are the various isolation levels possible?

1100


Why do chiropractors use drop table?

1165


How do I add a column to an existing table in db2?

1084


What are packages in db2?

1077


Explain about dbrm.

1110


what is db2 restart?

2218


What is table space in db2?

1072


What is dbrm in db2 database?

1195


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

1543


How do I add a column to a table in db2?

1161


What is isolation level in db2?

1070


How does a cursor work?

1043


can all users have the privilage to use the sql statement select * (dml)?

1224


Is db2 a database?

1029