Stuart, I simply use DIVERT.OUT to divert the XML to a type 19 file. This seems to work with larger volumes of data.
e.g. I write a temporary paragraph to the VOC to say: PA DIVERT.OUT ON filename itemname.XML TTY.OFF SELECT * FROM somefile TOXML ELEMENTS; DIVERT.OUT OFF TTY.ON and then execute the paragraph. You may need to strip the first line of the itemname.XML on reading. Brian [EMAIL PROTECTED] wrote on 14.12.2004, 02:47:51: > I am sending XML from UniVerse to a webserver using callHttp. Currently > we're on UV10.0.7 and won't be upgrading to a version of UV with > XMLExecute() any time soon. > > > > The current technique is to "EXECUTE 'LIST CUSTOMERS ... TOXML' CAPTURING > postData". This works fine for relatively small amounts of data but it > doesn't take long for the amount of XML to blow the workspace when postData > gets a few thousand rows into it. > > > > I was just wondering if there was some technique someone has worked out to > get the 'next set' of records using an active select list. > > > > eg. > > SELECT CUSTOMERS > > LOOP WHILE ACTIVE.LIST DO > > EXECUTE 'LIST ... NEXT 5000 TOXML' CAPTURING postData > > REPEAT > > > > My next option is to issue a select and then manually build select lists > for each set of rows. This would be somewhat cumbersome and add overhead to > something that needs to be efficient. > > > > Or maybe there's some cute SQL syntax??? > > > > Any suggestions? > > > > -- > > Regards, > > Stuart Boydell > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ********************************************************************** > This email message and any files transmitted with it are confidential > and intended solely for the use of addressed recipient(s). If you have > received this email in error please notify the Spotless IS Support Centre (61 > 3 9269 7555) immediately who will advise further action. > > This footnote also confirms that this email message has been scanned > for the presence of computer viruses. > ********************************************************************** > ------- > u2-users mailing list > [EMAIL PROTECTED] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
