BL_HOST= Data Set Option

Specifies the host name or IP address of the server where the external data file is stored.

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default:	DBMS-specific
Requirements:	To specify this option, you must first set BULKLOAD=YES. You must enclose the name in quotation marks.
Data source:	Aster nCluster, Greenplum
See:	BL_DBNAME= data set option, BL_PATH= data set option, BULKLOAD= data set option

Syntax

BL_HOST='hostname' [Aster nCluster]

BL_HOST='localhost' [Greenplum]

localhost: specifies the IP address of the server where the external data file is stored.

Use this option to pass the IP address to the DBMS bulk-load facility.

Greenplum: The default is 127.0.0.1. You can use the GPLOAD_HOST environment variable to override the default.