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.
Thx
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 */
END.
Now lets...
Hi
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.
e.g.
<?xml version="1.0" encoding="UTF-8"?>
<data...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.