In order for this site to work correctly, and for us to improve the site, we need to store a small file (called a cookie) on your computer.
By continuing to use this website, you agree to our cookies and privacy policy.
Home page Home page Home page Home page
Pixel Header R1 C1 Pixel
Pixel Header R2 C1 Pixel
Pixel Header R3 C1 Pixel

QTIPS - Btree.Extract

When using BTREE.EXTRACT it can be useful to get at all those records WITHOUT a value in a field. For example, you may wish to extract all employees for whom the date of birth is not on file. Or conversely you may wish to get at all those employees who have been to University.

Calling BTREE.EXTRACT with XREF.PARAMS set to ="" or #"" does not work. Instead, the syntax <="" and >"" must be used. E.G.

0001     PARAM ="DOB":@VM:"<=' ' ": @FM


0001     PARAM = "UNI":@VM:">' ' ":@FM

(Volume 1, Issue 4, Page 3)
Pixel Footer R1 C1 Pixel