How do you check for a null value in a db2 column?
Answers were Sorted based on User's Feedback
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 |
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 |
What are the four lockable units for DB2?
if i made sme changes in sub pgm wht r the things to be done for this ?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What's The Error Code For Unique Index Voilation?
What language is db2 written in?
How does one remove entries from the SCT02 table?
What is with ur in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
Where do you specify them?
How can you split a table in to exactly half?
What is the physical storage length of the data types date, time, and timestamp?
How do I change the column size in db2?