topic Re: Replicating Boolean data type from DB2 V11.5.7.0 in Qlik Replicate

Replicating Boolean data type from DB2 V11.5.7.0

FrankBosh — Mon, 13 Feb 2023 15:12:26 GMT

Around May 17, 2022, time frame, I requested a product enhancement to have Qlik Replicate support replicating Boolean data type from DB2 V11.5.7.0 to Azure SQL Server.

On the Qlik Replicate November 2022 release User Guide, I see replicating Boolean data type from DB2 is not supported. I was wondering when replicating Boolean data type from DB2 is supported?

Thank you and best regards,

Ken

Re: Replicating Boolean data type from DB2 V11.5.7.0

Steve_Nguyen — Mon, 13 Feb 2023 20:57:51 GMT

Support do not have Feature request availability.

however, you can submit FR again.

https://community.qlik.com/t5/Ideation/ct-p/qlik-product-insight

Re: Replicating Boolean data type from DB2 V11.5.7.0

john_wang — Wed, 15 Feb 2023 14:31:01 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, This article

2. Frank , last year similar article

3. Frank, 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 the FR article.

Regards,

John.

Re: Replicating Boolean data type from DB2 V11.5.7.0

john_wang — Wed, 01 Mar 2023 13:56:25 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.