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
Pixel Header R1 C1 Pixel
Pixel Header R2 C1 Pixel
Pixel Header R3 C1 Pixel
Pixel

QTIPS - File Variable of File In SELECT Statement

In issue 8 of Volume 3 a symbolic called GAS_BAR was referred to which displays progress through a file on a SELECT statement. In the pseudo code it was suggested that the record count for the file be obtained using GET.RECCOUNT. Bear in mind that @PRI.FILE will contain the file variable for the file currently being selected; thus avoiding the need for parsing @SENTENCE. The syntax would be REC_CNT = Get.Reccount(@PRI.FILE, Valid, "").

(Volume 3, Issue 10, Page 5)
Pixel
Pixel Footer R1 C1 Pixel
Pixel
Pixel
Pixel