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 iseries database?

1046

Explain the function of data manager.

1044

What is concurrency?

1233

What is a db2 table?

1015

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

1195

What are the 2 sqlcodes that are returned?

1189

Is db2 relational database?

979

How would you find out the total number of rows in a db2 table?

1051

What is null indicator in cobol db2?

1066

How can we read records for specific member in CL? AND rpg?

700

Is schema the same as database?

1058

What is a collection in db2?

1035

What is db2 stogroup?

1160

Which components manage deadlocks in db2?

1071

How do I delete a column in db2?

1109