Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Replicating columns defined as Boolean failed after upgrading source endpoint from DB2 for LUW V11.1.4.6 to V11.5.7.0. The error message is "<column> has unknown SQL data type -7" and forces the Task to terminate. I tried a workaround with source_lookup function to transform the Boolean column and get the same error message.
I thought upgrading DB2 Client to V11.5.7.0 may help, but I read on this forum that I should not upgrade DB2 Client to V11.5.7.0 as it is not certified for use.
Does anyone have a solution or workaround?
Our environment:
Qlik Replicate 2021.11.0.165
Source end point is DB2 for LUW V11.5.7.0
Target end point is Azure SQL Server
DB2 Client is V11.1
Source_lookup function: Source_lookup(3, <tabschema>, <tabname>, <Boolean colname>, <primary key colname> =?, $< primary key colname>)
The work around is not effective with DB2 driver version 11.1.4.
I'm waiting on another department to install DB2 driver 11.5.6. I will re-test the Boolean data type and the work around once it's installed and post the results.
Best regards,
Ken
Hi Dana,
Driver 11.5.6 was installed on our non-prod server last week. In Table Settings, Transform, Output, set column to Type Boolean it did not work. Now, Type is set to string(1) and waiting to get data from the application. If this doesn't work I will try setting Type to Int1, then I will try the work around with source_lookup.
source_lookup(3,'<tabschema>','<tabname>','<columnname>','<uniqueidentier=?>','<$uniqeridentier>)
I will post the test results.
Best regards,
Ken
Hi Dana,
Testing with DB2 driver V11.5.6 did not work. In Table Settings, Transform, Output, Column type was set to string(1), int(1), unit1, bytes(1) and source _lookup(3,’<tabschema>’,’<tabname>’,’<colname>’,’uniqueidentifer=?>’,’<$uniqueidentifer>) these data types failed on invalid SQL data type -7. Any thing else I can try will be appreciated.
Hi Dana,
I'll open a support case.
Thanks,
Ken
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.
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.