Interested to Buy Any Domain ? << Click Here >> for more details...
How do you check for a null value in a db2 column?
- 2 Answers
- 11684 Views
- I also Faced
- E-Mail Answers
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 |
How many buffer pools are available in db2?
What is dbrm?
What are delete-connected tables?
When is the results table for the query in a DECLARE CURSOR statement created?
How do you check for a null value in a db2 column?
db2 restart logic ?
What's the difference between DB2 active log and archive log? Thanks a lot...
What is dynamic SQL?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
When reorg is used?
What are the uses of db2 optimizer?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
COBOL 
