Hi Folks,

What does question mark (?) in the following insert statement mean ?

insert into AMERT1.NOTE (NOTE_ID, DEFECTS_VAL_1, DEFECTS_VAL_2, DEFECTS_TYP_ID, NOTE_SETTINGS_ID) values (?, ?, ?, 6, defect)

Thanks,
Panditt

The ? is a parameter marker for a prepared SQL statement. The statement is compliled (prepared), and then it is executed with specific values in place of the parameter markers. This allows DB2 to use one compliled package (with the access plan) that can be cached in memory and reused even though the parameter marker values change for each execution.

Excellent !! thanks a lot Marcus.