I'm trying to use a keyed data queue on the AS/400. I can get ADO quite happily to read and write from a non-keyed queue and can even write a keyed entry. But whenever I try and just read entries with a particular key I get everything.
I have code like the following;
Set rs = cnAS400.Execute("OPEN DATAQUEUE mylib/file key(Key character(3)) FOR RECEIVE", Rcds, adCmdText)
But after that the recordset contains all entries in the data queue (and the queue is now empty). How can I specify that I only want to read entries that match the key I have, and leave all others untouched?
I have code like the following;
Set rs = cnAS400.Execute("OPEN DATAQUEUE mylib/file key(Key character(3)) FOR RECEIVE", Rcds, adCmdText)
But after that the recordset contains all entries in the data queue (and the queue is now empty). How can I specify that I only want to read entries that match the key I have, and leave all others untouched?
