The u0065 user exit returns the estimated number of items in the most recently referenced file.
result = oconv("", ’u0065’)
This user exit returns an immediate estimate of the number of items in the file. This estimate is automatically updated by any simple AQL count or select that traverses the entire file, or by the TCL file-save command. Normal insert and delete statement executions also update this estimate, although complete accuracy is not assured because this update is not done under lock.
If the internal estimate has never been updated, then a -1 is returned.
To use this user exit, a file reference to the desired file must be created. A dummy read accomplishes this.
open "myfile"
.
.
* just reference file
read xx from ""
print oconv("","u65")