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-
10 variable-NI pic s9(04) Usage comp.
|Is This Answer Correct ?||5 Yes||0 No|
Answer / yuvaevergreen
>>"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.
insert into employee(name)
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|
What is the purpose of using commit?
What are the abend codes occour in ur latest PROJECT in DB2
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What is a clustering index?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What is the use of db2 optimizer?
How do you stop a db2 database in linux?
What is difference between rollback and commit?
how can u retrieve the data from null values using applicaion program.
Which catalog table stores referential constraints?
How are write I/Os from the buffer pool executed?
how to resolve -811 sqlcode .give clear explaination