Previous Page | Next Page

Data Set Options for Relational Databases

BL_EXECUTE_LOCATION= Data Set Option



Specifies which segment instances runs the given command.
Default value: none
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS Support: Greenplum

Syntax
Syntax Description
Details
See Also

Syntax

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

Syntax Description

ALL

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

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.


Details

To specify this option, you must first set BULKLOAD=YES.

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


See Also

BL_EXECUTE_CMD= Data Set Option

BL_EXTERNAL_WEB= Data Set Option

BL_LOCATION= Data Set Option

BULKLOAD= Data Set Option

Previous Page | Next Page | Top of Page