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]

Syntax Description

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

Details

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.