How do you insert a record with a nullable column?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / s
INSERT INTO TABLE X VALUES('ABC','DEF','')
will allow you to insert a record with no value specified
for the nullable column
| Is This Answer Correct ? | 2 Yes | 3 No |
What are the levels of isolation available with DB2V4
What is null indicator in db2?
What is DCLGEN ?
Which isolation level provides highest data integrity?
How to test SQL -911 error while developing COB-DB2 program
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
What is the size of a data page?
What do you do to keep the cursor from closing after a commit?
Parm value passed is PARM=(10,20). how do code linkage section and how would you add these two passes values and show result in cobol program.
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
Assuming that a site's standard is that pgm name = plan name, what is the easiest way to find out which Will precompile of an DB2-COBOL program bomb, if DB2 is down?
How can we read records for specific member in CL? AND rpg?