Re: How can I speed up the copying of data using DDM and field selection.

We got around it on Cognos with the openquery type of processing.


Rob Berendt
-- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 2505 Dekko Drive Garrett, IN 46738 Ship to: Dock 108 6928N 400E Kendallville, IN 46755 http://www.dekko.com From: Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx> To: midrange-l@xxxxxxxxxxxx Date: 08/17/2017 11:36 PM Subject: Re: How can I speed up the copying of data using DDM and field selection. Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> Hi Rob This sounds like the way Crystal Reports - whatever the name is now - operated by default - it would pull the full data to the PC, then run the SELECT there. You had to use a special setting to make it run stuff on the server. I don't know Cognos - is it possible that this kind of thing is happening there? Regards Vern On 8/11/2017 11:31 AM, Rob Berendt wrote:

Then why, in our Cognos environment, were we getting abysmal performance
connecting from those servers to Db2 until we changed the statements to
openquery type things?


Rob Berendt

-- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l. Please contact support@xxxxxxxxxxxx for any subscription related questions. Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD
-- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l. Please contact support@xxxxxxxxxxxx for any subscription related questions. Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD