How to handle null values in db2
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 to find last record before record through SQLRPGLE?
How to find schema of a table in db2?
What is a db2 cursor?
What happens in bind step in a db2 program?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
What is copy pending status in db2?
what is a trigger and types of triggers
What is a synonym ?
What is lock escalation?
How can record locking be achieved in those DB2 versions which do not support it?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
I use CS and update a page. Will the lock be released after I am done with that page?