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)
Categories: Bulk Loading
Data Set Control
Default: DBMS-specific; SERVER= value, if SERVER= is set; otherwise, none [Impala]
Requirements: To specify this option, you must first specify BULKLOAD=YES.
You must enclose the name in quotation marks.
Data source: Aster, Greenplum, HAWQ, Impala
See: BL_DBNAME= data set option, BL_PATH= data set option, BULKLOAD= data set option

Table of Contents

Syntax

BL_HOST='hostname' [Aster, Impala]
BL_HOST='localhost' [Greenplum, HAWQ]

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.

Last updated: February 3, 2026