Forum Discussion
Solved
DB2 IDAA
Please, does anybody know, whether and how you can enable the IBM DB2 Accelerator (IDAA) in the Advanced Editor of Power Query? I have the following: let Source = DB2.Database("Server", "Database",...
Our solution is to change the syntax in Power Query using Advanced Editor
= DB2.Database("server", "database", [HierarchicalNavigation=true, Implementation="Microsoft", Query="SET CURRENT QUERY ACCELERATION=ENABLE; SELECT * FROM database.table FOR READ ONLY;"])
Our solution is to change the syntax in Power Query using Advanced Editor
= DB2.Database("server", "database", [HierarchicalNavigation=true, Implementation="Microsoft", Query="SET CURRENT QUERY ACCELERATION=ENABLE; SELECT * FROM database.table FOR READ ONLY;"])