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)
Categories: Bulk Loading
Data Set Control
Default: none
Requirement: To specify this option, you must first specify BULKLOAD=YES.
Data source: Greenplum, HAWQ
See: BL_EXECUTE_CMD= data set option, BL_EXTERNAL_WEB= data set option, BL_LOCATION= data set option, BULKLOAD= data set option

Table of Contents

Syntax

BL_EXECUTE_LOCATION=ALL
BL_EXECUTE_LOCATION=PRIMARY
BL_EXECUTE_LOCATION=SEGMENT segmentID

Syntax Description

ALL

specifies that all segment instances run the given command or script.

PRIMARY

specifies that the primary 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.

Details

For more information about valid values for this option, see the documentation for your database engine.

Last updated: February 3, 2026