Interested to Buy Any Domain ? << Click Here >> for more details...
How to handle null values in db2
- 4 Answers
- 20022 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 |
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
What is meant by AUTO COMMIT?
cobol-db2 runjcl please?
How do you prepare a COBOL + DB2 program from coading till execution ?
What is a DB2 catalog?
What is consistency token in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
How to restart a DB2 program?
What is load utility in db2?
How can record locking be achieved in those DB2 versions which do not support it?
COBOL 
