Data Set Options for Relational Databases |
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
|
BL_EXECUTE_CMD=command | script
|
- 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.
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.
BL_EXECUTE_LOCATION= Data Set Option
BL_EXTERNAL_WEB= Data Set Option
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.