How to handle null values in db2

Answer Posted / lu

you need to declare binary indicator variable....
10 Ind-variable pic s(904) comp.

Is This Answer Correct ?    10 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

can all users have the privilage to use the sql statement select * (dml)?

638


How do we specify index to include or not during bind process.

1674


i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?

2044


What is the syntax for seeing the columns and data types of a table in the db2 database?

576


How can we retrieve the total number of records in RPG & CLLE?

193






In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?

575


What is cursor with hold option in db2?

610


What are the benefits of using the db2 database?

658


Which isolation level provides highest data integrity?

593


What is the use of dclgen in db2?

586


What are the contents of dclgen?

652


Which component is responsible for processing sql statements and selecting access paths?

661


Discuss about db2 bind?

667


Which command is used to remove all rows from a table?

551


Can we insert update delete in view?

571