Interested to Buy Any Domain ? << Click Here >> for more details...
How do you check for a null value in a db2 column?
- 2 Answers
- 11671 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 |
Is ibm db2 open source?
What keyword does an SQL SELECT statement use for a string search?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
What is read-only cursor?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
Give the name of some fields form sqlca.
What is a DB2 bind?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What is syscat in db2?
How will you return the number of records in table?
How does db2 sample database connect?
COBOL 
