Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tony G
Sent: 19 November 2008 21:51
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Counting records
COUNT is a "TCL2" Verb just like SELECT, LIST, SORT, LIST-LABEL, ETC.
So this is already a valid statement in Un
COUNT is a "TCL2" Verb just like SELECT, LIST, SORT, LIST-LABEL,
ETC.
So this is already a valid statement in Universe and Unidata:
COUNT CONTACT WITH @ID LIKE "2..."
T
> From: Dave Laansma
> One advantage of using my subroutine is I can pass in
> just the file name and get a count of all re
I'm reminded that D3 has ESTIMATE-COUNT which polls a static
counter in a file control block without searching through the
entire file. Since the counter is updated by all write
operations it's almost always accurate at the moment of the
request in a dynamic file. If Universe or Unidata don't hav
QLFreeStmt(@HSTMT, SQL.DROP)
RETURN(Counter)
Usage:
DEFFUN CountFile(fn)
Crt CountFile('VOC')
Brian
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of T Stokes
> Sent: 18 November 2008 22:59
> To: u2-users@listserve
: u2-users@listserver.u2ug.org
Subject: RE: [U2] Counting records
SIMPLE CODE FOR COUNTING RECORDS (IN UNIDATA)
:AE DAVID COUNT3
PROGRAM COUNT3
PERFORM "COUNT STUDENTS"
NUM.RECS = @SYSTEM.RETURN.CODE
PRINT ""
PRINT "NUMBER OF RECORDS: ":NUM.RECS
*--: FIBR
Filed "COUNT3"
asic: oisdir/david/COUNT3 in mode 'u'.
compilation finished
COUNT STUDENTS
39635 record(s) counted.
NUMBER OF RECORDS: 39635
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dave Laansma
Sent: Wednesday, November 19, 2008 10:24 AM
To: u2-users@list
vices, and Innovative Solutions"
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Anthony
Youngman
Sent: Wednesday, November 19, 2008 10:04 AM
To: 'u2-users@listserver.u2ug.org'
Subject: RE: [U2] Counting records
Several things look a
EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Laansma
Sent: 19 November 2008 14:05
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Counting records
I have written the following subroutine to count files:
SUBROUTINE HUB.COUNT.FILE (FILENAME,RCNT)
CMD = 'COUNT'
Or simply EXECUTE "COUNT file [selection_criteria]"
You could build your own function
Hth
Colin Alfke
Calgary, Canada
> -Original Message-
> From: Symeon Breen
>
> In udt there is a system function after you have done a select,
> system(11).
> E.g. EXECUTE "SELECT file" ; NUM.OF.REC
iginal Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen
Sent: Wednesday, November 19, 2008 8:34 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] Counting records
In udt there is a system function after you have done a select,
system(11).
E.g. EXECUTE "SELE
r.u2ug.org
Subject: [U2] Counting records
I am trying to remember a Universe function that returns the number of
records in a file.
Something like this.
OPEN 'SOMEFILE' TO SOMEFILE ELSE STOP 201,"SOMEFILE"
NUM.OF.RECORDS = UNKNOWNFUNCTION(SOMEFILE)
--
View this message in
I am trying to remember a Universe function that returns the number of
records in a file.
Something like this.
OPEN 'SOMEFILE' TO SOMEFILE ELSE STOP 201,"SOMEFILE"
NUM.OF.RECORDS = UNKNOWNFUNCTION(SOMEFILE)
--
View this message in context:
http://www.nabble.com/Counting-records-tp20569376p20569
12 matches
Mail list logo
