INSERT INTO TABLE X VALUES('ABC','DEF','')

How do you insert a record with a nullable column?

Question Posted / s

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is host variable in db2 cobol?

1039

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1044

How do you concatenate the firstname and lastname from emp table to give a complete name?

1028

What are the different types of base tables?

1041

What is the syntax for FETCH in DB2 ?

1153

Explain db2.

998

What is multi row fetch in db2?

998

What are host variables in db2?

999

What is the difference between nvl and coalesce?

1018

What is null indicator in cobol db2?

1002

Which components manage deadlocks in db2?

1029

Explain the function of data manager.

999

Define sqlca.

1062

Is ibm db2 free?

961

How do I import data from excel to db2?

1025