SPDSSADD Macro Variable

Specifies whether SPD Server appends tables by transferring a single row at a time synchronously, or by transferring multiple rows asynchronously (block row appends).

Valid in: SPD Server
Default: NO
Restriction: Assignments for macro variables with character input (for example, YES | NO | BINARY arguments) must be entered in uppercase (capitalized).
Interaction: Corresponding table option is SYNCADD=.
Tip: Use the UNIQUESAVE table option (or SPDSUSAV macro variable) to save rejected rows when SPDSSADD is set to NO.

Syntax

SPDSSADD=YES | NO

Required Arguments

YES

applies a single row at a time during an Append operation.

NO

appends multiple rows at a time.

Details

SPDSSADD=YES slows performance.

See Also

SPD Server macro variables:
SPD Server table options:
Last updated: February 8, 2017