idea Add Boolean data type to replicate from DB2 for LUW V11.5.7 in Suggest an Idea

Add Boolean data type to replicate from DB2 for LUW V11.5.7

FrankBosh — Thu, 12 May 2022 14:22:03 GMT

Please enhance Qlik Replicate November 2021 to replicate Boolean data type from DB2 for LUW V11.5.7 to Azure SQL Server. We’re getting “SQL invalid data type -7” error message on Qlik Replicate after upgrading to DB2 for LUW V11.5.7.

The link suggests IBM DB2 for LUW Boolean data type is not supported.

https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/IBM%20DB2%20for%20LUW/db2_db_data_types_source.htm?_ga=2.93359517.1607619055.1652207160-1609456532.1651150285

Re: Add Boolean data type to replicate from DB2 for LUW V11.5.7

john_wang — Wed, 15 Feb 2023 14:31:04 GMT

Hello @FrankBosh ,
Thanks for you reporting this.

There are several articles and FR requests, for easy to trace I'm summarizing them here:

1. Frank, new article

2. Frank , last year similar article

3. Frank, this FR article

IBM introduces BOOLEAN data type in newer DB2 LUW 11.5 and DB2i V7R5. let's wait for PM Team approval. We may trace the PM update in this article.

Regards,

John.

Re: Add Boolean data type to replicate from DB2 for LUW V11.5.7

john_wang — Wed, 01 Mar 2023 13:58:00 GMT

Hello @FrankBosh ,

Got information from PM team that BOOLEAN data type for IBM DB2 LUW is in R&D consideration, hopefully we get it verified in Q2/Q3 this year (this is not commitment yet). We will keep you posted of any new progress.

Hops this helps.

Regards,

John.

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Wed, 02 Aug 2023 14:56:28 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Add Boolean data type to replicate from DB2 for LUW V11.5.7 - Status changed to: Closed - Archived

Ideation — Wed, 02 Aug 2023 14:56:30 GMT