Interested to Buy Any Domain ? << Click Here >> for more details...
How do you check for a null value in a db2 column?
- 2 Answers
- 11794 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 |
Suppose we have a query for update update table1 set col1 = 'val1' where col2=(select .... from ...) suppose the subquery does not return any record, what will happen to update?
How can you get the number of rows impacted by the last executed query?
How can you split a table in to exactly half?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
What is the clustering index in the db2 database?
What is concurrency?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
How to test SQL -911 error while developing COB-DB2 program
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
I have a table which has thousand of records i want to fetch only record num 100 to record num 200. Write a query that satisfies this criteria.(Cant use any keys) Anyone please reply ASAP!
17 Answers KNIT, Tech Mahindra,
How would one remove old reorg information from the DB2 catalog?
Mention data types used in db2 ?
COBOL 
