SPDSEINT Macro Variable

Specifies how SPD Server responds to network disconnects during SQL explicit pass-through EXECUTE() statements.

Valid in: SPD Server
Default: YES
Restriction: Assignments for macro variables with character input (for example, YES | NO | BINARY arguments) must be entered in uppercase (capitalized).
Syntax
Required Arguments
Details

Syntax

SPDSEINT=YES | NO

Required Arguments

YES

interrupts SQL processing by default when a network failure occurs.

NO

configures the server's SQL processor to continue processing until completion regardless of network disconnects.

Details

The server’s SQL processor interrupts SQL processing by default when a network failure occurs. The interruption prematurely terminates the EXECUTE() statement. Setting SPDSEINT=NO configures the server's SQL processor to continue processing until completion regardless of network disconnects.
CAUTION:
Use the macro variable setting SPDSEINT=NO carefully!
A runaway EXECUTE() statement requires a privileged system user on the server machine to kill the server SQL proxy process. This is the only way to stop the processing.
Copyright © SAS Institute Inc. All Rights Reserved.
Last updated: February 8, 2017