How do you insert a record with a nullable column?

Answer Posted / santosh

For the column which you want to incert a null value,
incert -1 value to indicator variable then incert the
column.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rebind in db2?

790


What does db2 mean?

785


What is alias in db2?

814


How do you simulate the explain of an embedded sql statement in spufi/qmf?

857


Why db2 is called db2?

790


Define buffer pool.

811


What are db2 tables?

874


List out the three types of page locks that can be held.

922


Explain the function done by data manager?

1044


Can we update view in db2?

782


Mention the definition of cobol in varchar field.

916


What is db2 purescale?

774


Why do we need reorg in db2?

753


Is ibm db2 free?

778


How and when does the db2 enforces the unique key?

866