Interested to Buy Any Domain ? << Click Here >> for more details...
How do you check for a null value in a db2 column?
- 2 Answers
- 11879 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 |
what is SPUFI ?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
What action db2 takes when a program aborts in the middle of a transaction?
What is a dbrm in db2?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
I have 1000 rows in a db2 table.I want to update first 100 records,How do I do it?
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
How do I import data from excel to db2?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What is db2 bind process?
Discuss about db2 bind?
How to get the ddl of a table in db2?
COBOL 
