BL_EXTERNAL_WEB= Data Set Option

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)
Default: NO
Requirement: To specify this option, you must first set BULKLOAD=YES.
Data source: Greenplum
See: Accessing Dynamic Data in Web Tables, BL_EXECUTE_CMD= data set option, BL_EXECUTE_LOCATION= data set option, BULKLOAD= data set option

Syntax

BL_EXTERNAL_WEB=YES | NO

Syntax Description

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.

Details

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.

Example

libname sasflt 'SAS-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-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;