Interested to Buy Any Domain ? << Click Here >> for more details...
How to handle null values in db2
- 4 Answers
- 20243 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 |
what is the difference between declaring the cursor in WS section and Procedure division?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
List down the types of triggers in the db2 database?
what is difference between random and sequence file access
What are the three lock types?
What is the function of the Data Manager?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
What is catalog database in db2?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What does sqlcabc has?
COBOL 
