Specifies whether the external data set accesses a dynamic data source.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Categories: | Bulk Loading |
| Data Set Control | |
| Default: | NO |
| Requirement: | To specify this option, you must first specify BULKLOAD=YES. |
| Data source: | Greenplum, HAWQ |
| See: | Accessing Dynamic Data in Web Tables, BL_EXECUTE_CMD= data set option, BL_EXECUTE_LOCATION= data set option, BULKLOAD= data set option |
Table of Contents
specifies that the external data set is not a dynamic data source that resides on the web.
specifies that the external data set is a dynamic data source that resides on the web.
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 documentation for your database engine.
libname sasflt 'SAS-library';
libname mydblib greenplm user=myusr1 password=mypwd1 dsn=mysrv1;
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-library';
libname mydblib greenplm user=myusr1 password=mypwd1 dsn=mysrv1;
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;