Data Set Options for Relational Databases

BL_EXTERNAL_WEB= Data Set Option

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

Syntax
Syntax Description
Details
Examples
See Also

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

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;