D.30 HS_KEEP_REMOTE_COLUMN_SIZE

HS_KEEP_REMOTE_COLUMN_SIZE initialization parameter for Oracle Database Gateway for SQL Server.

Property	Description
Default Value	OFF
Range of Values	OFF | LOCAL | REMOTE | ALL
Syntax	HS_KEEP_REMOTE_COLUMN_SIZE = OFF | LOCAL | REMOTE | ALL
Parameter type	String

HS_KEEP_REMOTE_COLUMN_SIZE specifies whether to suppress ratio expansion when computing the length of (VAR)CHAR data types during data conversion from the non-Oracle database to the gateway, and then to the Oracle database. When it is set to REMOTE, the expansion is suppressed between the non-Oracle database and the gateway. When it is set to LOCAL, the expansion is suppressed between the gateway and the Oracle database. When it is set to ALL, the expansion is suppressed from the non-Oracle database to the Oracle database.

When the parameter is set, the expansion is suppressed when reporting the remote column size, calculating the implicit resulting buffer size, and instantiating in the local Oracle database. This has effect only for remote column size from non-Oracle database to Oracle database. If the gateway runs on Windows and HS_LANGUAGE=AL32UTF8, then you must not specify this parameter, as it would influence other ratio related parameter operation. It has no effect for calculating ratio for data moving from Oracle database to non-Oracle database through gateway during INSERT, UPDATE, or DELETE.