Unable to perform data compare using Singlestore

Toad Data Point
1

hi,

I want to perform data compare between Singlestore tables and DB2 tables. However, when I launch the data compare wizard, I get an error "Feature WHERE clause in SHOW statements in not supported by Singlestore". Not sure what feature is being referred to here and why is it a blocker to support data compare.

Thanks!

2

Not sure either... is there anything unusual about your SingleStore table/s? e.g. using links, etc.?
If nothing unusual, you might want to take this one to Quest Support.

However, for a possible work-around, you might want to copy your SingleStore table/s to Local Storage, and then perform the Data Compare between DB2 and Local Storage.