SPDSWSEQ Macro Variable

Set the SPDSWSEQ macro variable to YES. When set to YES, the SPDSWSEQ macro variable overrides WHERE clause costing and forces a global EVAL3 or EVAL4 strategy.

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).

Syntax

SPDSWSEQ=YES | NO

Required Arguments

YES

overrides WHERE clause costing and forces a global EVAL3 or EVAL4 strategy.

NO

does not override WHERE clause costing.

Example

%let SPDSWSEQ=YES;

See Also

Last updated: February 8, 2017