Data Set Options for Relational Databases

BL_HOST= Data Set Option

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

Default value:	DBMS-specific
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	Aster nCluster, Greenplum

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.

To specify this option, you must first set BULKLOAD=YES.

Use this option to pass the IP address to the DBMS bulk-load facility. You must enclose the name in quotation marks.

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