RDA Help (AS400 Co-existence, B7332)

gng_ca

Member
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(*)
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/
 
Hi Gordon,

Can you make report variable “Counter”, increment it every time you update record on a custom file and print it on the end?

Regards,

Bojan.
 
<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>
 
Hi,

I tried, but it didn't work the way we update records.

One Update call could update more than one record
based on the set key value.

Thanks for the thought.
Gordon


--- vbojan <[email protected]> wrote:
> Hi Gordon,
>
> Can you make report variable “Counter”, increment it
> every time you update record on a custom file and
> print it on the end?
>
> Regards,
>
> Bojan.
>
>
>
> --------------------------
> Visit the forum to view this thread at:
>
http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Number=3350
>
>
*************************************************************
> 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
>
*************************************************************
>


__________________________________________________
Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online!
http://photos.yahoo.com/
 
Hi
One Solution is put a counter add one when you update.

Second If you run this process once a day and have time stamp field in a file which you are updating. Then you can add a Section in UBE putting selection on Date and count at end how many records are get updated or added.


Alok

January 2001, gng_ca wrote:

>
> Hi,
>
> I tried, but it didn't work the way we update records.
>
> One Update call could update more than one record
> based on the set key value.
>
> Thanks for the thought.
> Gordon
>
>
> --- vbojan <[email protected]> wrote:
> > Hi Gordon,
> >
> > Can you make report variable “Counter”, increment it
> > every time you update record on a custom file and
> > print it on the end?
> >
> > Regards,
> >
> > Bojan.
> >
> >
> >
> > --------------------------
> > Visit the forum to view this thread at:
> >
> http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OWDEV&Number=3350
> >
> >
> *************************************************************
> > 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
> >
> *************************************************************
> >
>
>
> __________________________________________________
> 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=3451
> *************************************************************
> 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
> *************************************************************


______________________________________________________
123India.com - India's Premier Portal
Get your Free Email Account at http://www.123india.com
 
Back
Top