Data Set Options for Relational Databases

BL_EXECUTE_CMD= Data Set Option

Specifies the operating system command for segment instances to run.

Default value:	none
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Restriction:	Only for Web tables
DBMS Support:	Greenplum

Syntax
Syntax Description
Details
See Also

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

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

Output is Web table data at the time of access. Web tables that you define with an EXECUTE clause run the specified shell command or script 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.