TargetHasMixedData

Indicates whether the DB2 access service allows character strings returned in the sp_columns catalog stored procedure (CSP) result set to contain a mixture of SBCS and DBCS characters. For information about sp_columns, see sp_columns.

Syntax

TargetHasMixedData=[no | yes]

Default

no

Values

no indicates that character strings returned by sp_columns cannot contain a mixture of SBCS and DBCS characters.

yes indicates that character strings returned by sp_columns can contain a mixture of SBCS and DBCS characters.

Comments

The TargetHasMixedData property value must match the MIXED DATA option on the target database.