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 |
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What do you mean by commit and rollback?
How many types of page locks can be held in db2?
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
What do the initials DDL and DML stand for and what is their meaning?
How to find primary key of a table in db2?
What do you need to do before you do EXPLAIN ?
How to insert more than one record using insert?
What is scrollable cursor in db2?
What is temporal table in db2?
What is package versioning? Please give an example.
How to resolve -818 sql code in DB2?