Okay thanks that's helped. It was the point about the index keys for required records being read one at a time, retrieve the record, next index key etc .
As opposed to read all the index keys first and now start retrieving one record after the other.
So on iteration 2 of the for each loop, in this example, it implies that the index blocks still have to be examined for all the other records in the match.....
Is that correct?
And at this point on iteration 2, the only records that have been requested to be available in the buffer pool are...
Hi this is a very basic question and I should know this, but I can't see the clear answer in any manual I have read.
Take a fairly simple static query in the 4GL. This was from the sports2000 db.
FOR EACH Customer
WHERE comments CONTAINS "hold" NO-LOCK:
/* Point A */
Using 10.2B06, I am using a ProDataset to build up my data, then using WRITE-XML to write the file.
The customer wants the XML to have an attribute on the outermost tag, but this is my ProDataset so not sure how I can do that.
<?xml version="1.0" encoding="UTF-8"?>