BL_EXECUTE_CMD= Data Set Option

Specifies the operating system command for segment instances to run.

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

Syntax

Details

Syntax

BL_EXECUTE_CMD=command | script

Syntax Description

command: specifies the operating system command for segment instances to run.

script: specifies a script that contains one or more operating system commands for segment instances to run.

Details

Output is Web table data at the time of access. Web tables that you define with an EXECUTE clause run the specified script or shell command on the specified hosts. By default, all active segment instances on all segment hosts run the command. For example, if each segment host runs four primary segment instances, the command is executed four times per host. You can also limit the number of segment instances that execute the command.