Valid in: | DATA and PROC steps (when accessing DBMS data using |
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 |
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;