<html><DIV>
I think I have a suggestion to getting around this problem. You can probably create a trigger for your custom file that counts the updated records and stores the last count on another custom table. The trigger would only run whenever the table gets updated. This way, your UBE would need not count those records but would only look at your custom file containing the last count. Again, I haven't tested this so you may want to try if it is indeed possible. </P></DIV>----Original Message Follows----
From: gng_ca <
[email protected]>
Reply-To:
[email protected]
To:
[email protected]
Subject: RDA Help (AS400 Co-existence, B7332) ~~0:3349
Date: Wed, 3 Jan 2001 14:43:54 -0800 (PST)
Received: from [216.122.12.105] by hotmail.com (3.2) with ESMTP id MHotMailBC1CFE740028D820F3ADD87A0C69FC600; Wed Jan 03 15:19:19 2001
Received: by jdelist.com (8.9.3/8.9.3) id OAA05420for jdeowdevml-30618286; Wed, 3 Jan 2001 14:44:01 -0800 (P!
ST)
Received: from shell.tsoft.com (
[email protected] [198.144.192.5])by jdelist.com (8.9.3/8.9.3) with ESMTP id OAA05416for <
[email protected]>; Wed, 3 Jan 2001 14:43:58 -0800 (PST)
Received: (from eric@localhost)by shell.tsoft.com (8.8.7/8.8.7) id OAA16196;Wed, 3 Jan 2001 14:43:54 -0800 (PST)
From
[email protected] Wed Jan 03 15:19:44 2001
Message-Id: <
[email protected]>
X-Mailer: Mailer::1.0 (
http://www.gossamer-threads.com/scripts/)
Sender:
[email protected]
Precedence: bulk
Hi,
Is there an efficient way to do record counts in RDA?
I am creating a UBE, which update a field on a custom
file. At the end of the program, users would like to
see total many records pdated by this UBE on a report.
Currently, I am doing a Select and Fetch Next to
accumulate the counts, but found it very inefficient.
Is there a way to do something like 'Select Count(*) <BR!
>from F55511 where QTBKTR = 'A' in RDA.
Thank you in advance,
Gordon
__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/
--------------------------
To view this thread, visit the JDEList forum at:
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Number=3349
*************************************************************
This is the JDEList One World / XE Developers Mailing List.
Archives and information on how to SUBSCRIBE, and
UNSUBSCRIBE can be found at
http://www.JDELIST.com
*************************************************************
<br clear=all><hr>Get your FREE download of MSN Explorer at
http://explorer.msn.com
</p></html>