Interested to Buy Any Domain ? << Click Here >> for more details...
How to handle null values in db2
- 4 Answers
- 20242 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 |
Write a query to retrive partial string.
What is a SELECT statement?
What does the RUNSTATS Utility do?
What are some characteristics of columns that benefit from indexes?
Define db2.
Explain the use of the WHERE clause?
Define db2 and its databases?
What is page size in db2?
Explain about cursor stability?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?
COBOL 
