Data Set Options for Relational Databases

BL_CODEPAGE= Data Set Option

Identifies the codepage that the DBMS engine uses to convert SAS character data to the current database codepage during bulk load.

Default value:	the codepage ID of the current window
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	DB2 under UNIX and PC Hosts

Syntax
Syntax Description
Details
See Also

Syntax

BL_CODEPAGE=numeric-codepage-ID

Syntax Description

numeric-codepage-ID: is a numeric value that represents a character set that is used to interpret multibyte character data and determine the character values.

Details

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

The value for this option must never be 0. If you do not wish any codepage conversions to take place, use the BL_OPTIONS= option to specify 'FORCEIN'. Codepage conversions only occur for DB2 character data types.