How do you insert a record with a nullable column?
- 2 Answers
- 5638 Views
- I also Faced
- E-Mail Answers
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 is REORG? what is the use?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
What is a buffer in memory?
How do run the JCL which has 25 steps by skipping the following steps 5, 10,15 and 25 without using COND statement
What are the various locks available?
Describe major components of db2?
What is correlated subquery?
What is access path in db2?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
What does it mean if the null indicator has -1, 0, -2?
What are the four lockable units for DB2?
how to u check the query is executing or not ?where will u check for sqlcode ?
COBOL 
