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

How do I add a column to a table in db2?

618


Explain in brief how does db2 determine what lock-size to use?

595


Why select is not preferred in embedded sql programs?

713


What language is db2 written in?

595


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 .....

1897






How can the duplicate values be eliminated from db2 select?

625


List some fields from sqlca?

613


What is dbrm? When it will be created?

598


What is cascading rollback?

623


What is release/acquire in bind?

656


What are the prerogatives?

615


How does cobol compile db2 program?

608


How to connect to db2 database from windows command line?

562


What is dclgen in db2?

676


Which is faster delete or truncate?

677