How to handle null values in db2

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can the duplicate values be eliminated from db2 select?

639


How can deadlocks be resolved?

548


what is the sqlcode -501

11332


Define check constraint.

650


What is db2 instance?

597






What is data manager?

614


what are bind concepts in db2 cobol?

656


What is node in db2?

612


What are the contents of dclgen?

664


What is a db2 cursor?

631


Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

1908


How to find the maximum value in a column in the db2 database?

622


What does db2 blu stand for?

677


What is db2? Explain.

610


Mention data types used in db2 ?

688