Has anyone successfully handwritten a query that returns a stream? In order to improve the efficiency of the transfer of complex data between Cache and the client, we are trying to "bundle up" loads of property values into a character stream. This would then be parsed by the client, which requests the data by getting a resultset from the query.
The problem I am having is that a queryFetch() method appears to assemble the row data into a $list. Since my stream may be longer than 32K, I am assuming I have to include some sort of handle to the stream in the row data rather than the data itself. In fact, if I try and include the data, the OREF of the stream simply gets converted to a string and is therefore useless anyway. I can't find any examples of how to do this - I've already searched the archive without success, and combed the online docs. There is a passing reference in one code snippet (in the section "Using streams with SQL") to a %qstrhandle, which may be what I need, but I can't find any more information about it. Richard
