Data Set Options for Relational Databases |
Specifies whether the external data set accesses a dynamic
data
source.
Default value: |
NO
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS Support: |
Greenplum
|
- YES
-
specifies that the external data set is not a dynamic data
source that resides on the Web.
- NO
-
specifies that the external data set is a dynamic data source
that resides on the Web.
To specify this option, you must first set BULKLOAD=YES.
The external data set can access a dynamic data source on the Web, or
it can run an operating system command or script. For more information about
external Web tables, see the Greenplum Database Administrator Guide.
libname sasflt 'SAS-data-library';
libname mydblib sasiogpl user=iqusr1 password=iqpwd1 dsn=greenplum;
proc sql;
create table mydblib.flights98
(bulkload=yes
bl_external_web='yes'
bl_execute_cmd='/var/load_scripts/get_flight_data.sh'
bl_execute_location='HOST'
bl_format='TEXT'
bl_delimiter='|')
as select * from _NULL_;
quit;
libname sasflt 'SAS-data-library';
libname mydblib sasiogpl user=iqusr1 password=iqpwd1 dsn=greenplum;
proc sql;
create table mydblib.flights98
(bulkload=yes
bl_external_web='yes'
bl_location_protocol='http'
bl_datafile='intranet.company.com/expense/sales/file.csv'
bl_format='CSV')
as select * from _NULL_;
quit;
Accessing Dynamic Data in Web Tables
BL_EXECUTE_CMD= Data Set Option
BL_EXECUTE_LOCATION= Data Set Option
BULKLOAD= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.