Interested to Buy Any Domain ? << Click Here >> for more details...
How do you check for a null value in a db2 column?
- 2 Answers
- 11804 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 |
List down the data types in the db2 database.
What is ALTER ?
What is a view? Why use it?
What is null indicator in db2?
What is a cursor and what is its function?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
Can there be more than one cursor open for any program?
What is bind in db2?
What is ACQUIRE/RELEASE in BIND?
What is a host variable?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
I have two tables A and B. Both tables are connected with SSN number as foreign key. I want to retrieve a column data from B table. How will you write a query?
COBOL 
