SSIS Components for DB2

Build 24.0.9060

IgnoreCase

Whether to ignore case in identifiers.

Data Type

bool

Default Value

false

Remarks

When IgnoreCase is set to false (default), SQL identifiers are sent to DB2 in the same case as they appear in the query. For example, SELECT * FROM Table is sent as SELECT * FROM "Table".

When IgnoreCase is set to true, SQL identifiers are converted to uppercase before being sent to DB2. For example, SELECT * FROM Table is sent as SELECT * FROM "TABLE".

This property only takes effect when QueryPassThrough is set to false.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060