Data Set Options for Relational Databases |
Default value: | NO |
Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
DBMS Support: | Greenplum |
Syntax | |
Syntax Description | |
Details | |
Examples | |
See Also |
Syntax |
BL_EXTERNAL_WEB=YES | NO |
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.
Details |
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.
Examples |
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;
See Also |
Accessing Dynamic Data in Web Tables
BL_EXECUTE_CMD= Data Set Option
BL_EXECUTE_LOCATION= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.