Re: use of Data Queues?

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Hi Alan

Happy to oblige - hope it is useful.

Here's something from the Access for i site - links to examples, mostly -

http://www-03.ibm.com/systems/power/software/i/access/windows/toolkit/data_queues.html

There is a Programmer's Toolkit option when you install Access for i on 
your PC - that has help text, but mostly for VB or C++ environments - 
not sure how it would apply to Crystal  Reports.

There is the Redbook described at

http://publib-b.boulder.ibm.com/Redbooks.nsf/RedbookAbstracts/sg245183.html

You might find this in Infocenter -

http://pic.dhe.ibm.com/infocenter/iseries/v7r1m0/topic/rzaik/rzaikoledbprovider.htm

I found that by searching for IBMDA400 there.

I don't know if any of this will tell how to do this in Crystal Reports 
- have never tried it. But it might give a start to an intrepid explorer!

HTH
Vern


On 5/26/2013 7:44 AM, aec wrote:
> Vernon,
>
> Could you post the link to the documentation that covers this general topic?
>
> THanks
> Alan
>
>
> On 5/25/13 10:39 AM, Vernon Hamberg wrote:
> > The OLE/DB provider lets you work with data queues. If CR can use OLE/DB
> > providers, it might work. Documentation says it is a destructive read -
> > that is, all entries are read. You can't do one at a time.
> >
> > Vern
> >
> > On 5/24/2013 9:56 AM, Alan Campin wrote:
> > > How would Crystal use a Data Queue? Requires programming logic to access.
> > > Just having a Stored Procedure return a result set works perfectly and is
> > > fast.
> > >
> > >
> > > On Fri, May 24, 2013 at 8:51 AM, Crystal Reports <
> > > crystalcleardecisions@xxxxxxxxx> wrote:
> > >
> > > > We have been discussing \changing from Logical files to Stored PRocs using
> > > > the IFS and Iseries Nav. to improve the processing time for the Crystal
> > > > Reports which access the AS400 data.
> > > >
> > > > What about the use of Data Que. these were always considered the fastest
> > > > way to send data out of the AS400?
> > > > --
> > > > 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.