Forum Discussion
DB2, Incremental Refresh, Query Folding Basics
Hello, I am querying a DB2 db but fails every so often due to a time out error. I've never used incremental refresh but understand that this would probably be a solution and that query folding is r...
Hi troyhimes
Thanks for your quick reply, based on the picture you have offered,
You need to enter the database first, you can refer to the step I offered above.
Then you don't need to use " " for the database name, try this.
Value.NativeQuery(FXXD,"select * from jdeview",null,[EnableFolding=true])
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yolo ( Anonymous ),
1. One difference on the 'Source' step betwen mine (Db2) and your example (SQL) is that the database name is required in the first step for Db2 source vs a SQL source.
2. With that in mind, here's how it goes down for me.... tried it a couple different ways, but it ends with an error either way
Try #1
Try #2