topic Re: Replication support for Boolean data type for IBM DB2 11.5. in Qlik Replicate

Replication support for Boolean data type for IBM DB2 11.5.

FrankBosh — Sun, 19 Feb 2023 20:53:38 GMT

IBM introduced support for Booleans and we've discovered Replicate does not replicate them. If it is helpful, the support case number we opened is 00071411, but we were directed here to open a feature request.

Hopefully, this can find its way into a near-future update....

Re: Replication support for Boolean data type for IBM DB2 11.5.

john_wang — Mon, 20 Feb 2023 09:48:52 GMT

Hello @FrankBosh ,
Thanks for you reporting this. There is not workaround for this behavior at the moment.

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

1. Frank, This article

2. Frank, last week similar article

3. Frank , last year similar article

4. 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: Replication support for Boolean data type for IBM DB2 11.5.

FrankBosh — Sat, 25 Feb 2023 21:18:16 GMT

How long does PM Team approval typically take?

Re: Replication support for Boolean data type for IBM DB2 11.5.

john_wang — Sun, 26 Feb 2023 01:33:46 GMT

Hello @FrankBosh ,

Let me check internally and get back to you later.

Regards,

John.

Re: Replication support for Boolean data type for IBM DB2 11.5.

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