BL_EXECUTE_LOCATION= Data Set Option

Specifies which segment instances runs the given command.

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default:	none
Requirement:	To specify this option, you must first set BULKLOAD=YES.
Data source:	Greenplum
See:	BL_EXECUTE_CMD= data set option, BL_EXTERNAL_WEB= data set option, data set option, BULKLOAD= data set option

Syntax

BL_EXECUTE_LOCATION=ALL | MASTER
| HOST [segment-hostname], number-of-segments | SEGMENT <segmentID>

MASTER: specifies that the master segment instance runs the given command or script.

HOST [segment-hostname], number-of-segments: indicates that the specified number of segments on the specified host runs the given command or script.

SEGMENT <segmentID>: indicates that the specified segment instance runs the given command or script.

For more information about valid values for this option, see the Greenplum Database Administrator Guide.