SQL Reference Guide > SQL Reference Guide > SQL Statements > SET > INSERTMODE DEFAULT | ROW | BULK
Was this helpful?
INSERTMODE DEFAULT | ROW | BULK
X100 Only. Specifies the mode to use for inserts and merges. This statement can be used to force appends to go through the PDTs, to allow concurrent inserts. Modes are as follows:
DEFAULT
Uses default behavior: Single row inserts go through the PDT, INSERT...AS SELECT does not.
ROW
Inserts through the PDT (allows concurrent inserts)
BULK
Appends directly to disk (does not allow concurrent inserts)
Last modified date: 01/30/2023