How to handle null values in db2
- 4 Answers
- 19274 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / lu
you need to declare binary indicator variable....
10 Ind-variable pic s(904) comp.
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / biswamoy majumder
To insert a NULL, move -1 to the null indicator, To insert
a valid value, move 0 to the null indicator.
declare separately Null indictor variable in Working-
Storage section.
10 variable-NI pic s9(04) Usage comp.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / yuvaevergreen
IN DCLGEN,
>>"INDICATOR VARS .. ===> NO" indicates the presence of
null variables for the fields in the tables.
>>indicator variable should be declared of type s9(4) comp.
77 DAY-IND PIC S9(4) BINARY.
Move -1 to the indicator variable and use in sql.
exec sql
insert into employee(name)
values(:ws-name:ws-name-ind)
end-exec;
ws-name-ind is the indicator variable which inserts null in
the field ws-name.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / ankitha
you can use value function or null indicators if you want to
handle nulls in program.
| Is This Answer Correct ? | 4 Yes | 2 No |
How do you prepare a COBOL + DB2 program from coading till execution ?
What do you need to do before you do EXPLAIN?
Can we declare DB2 HOST variable in COBOL COPY book?
What is schema in db2?
What is alias in db2?
What is a subselect? Is it different from a nested select?
What is deadlock in db2?
Explain db2.
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
can any one expalin check point with an example?
My SQL is not performing well. Describe how will you fine tune it?
What are catalog tables in db2?
COBOL 
