Re: unified purge of data -- RPG400-L


     Wow, its amazing how a phrase like "unified purge of data" sounds 
     technical, but doesn't really mean anything without the proper 
     context.
     
     If I had to assume what was meant by this, I'd say they want to 
     purge data from their database without violating any referential 
     constraints (explicit and implicit). Depending on the quality of 
     the applications, there may be data dependencies that make purging 
     data a little like russian roulette. One false move and your 
     database is dead (or at least disabled). Well designed databases 
     with explicitely defined database constraints will be much easier 
     to purge since the DBMS won't let you make too many mistakes.
     
     If that's not what they mean by "unified purge of data", then 
     please disregard my comments.... :)
     
     hth
     eric.delong@pmsi-services.com
     
     


______________________________ Reply Separator _________________________________
Subject: unified purge of data 
Author:  <RPG400-L@midrange.com> at INET_WACO
Date:    9/21/00 3:49 AM


Hi all,
   can anyone please explain what is means by unified purge of data, my 
client has asked me to do so. any comments or details on this are welcome.
     
Thanks,
  Farozan
     
>From: Gary Guthrie <GaryGuthrie@home.com> 
>Reply-To: RPG400-L@midrange.com
>To: RPG400-L@midrange.com
>Subject: Re: page n of x
>Date: Wed, 13 Sep 2000 16:32:35 -0500 
>MIME-Version: 1.0
>Received: from [192.160.127.90] by hotmail.com (3.2) with ESMTP id 
>MHotMailBB8948FF0064D820F3DBC0A07F5A07AE0; Wed Sep 13 15:21:51 2000 
>Received: (from 66@localhost)by uucphost.mcs.net (8.9.3/8.9.3) with UUCP id 
>RAA04190;Wed, 13 Sep 2000 17:20:05 -0500 (CDT)(envelope-from 
>rpg400-l-owner)
>Received: (from majordom@localhost)by linux.midrange.com (8.9.3/8.8.7) id 
>QAA12394for rpg400-l-outgoing; Wed, 13 Sep 2000 16:35:13 -0500
>Received: (from uucp@localhost)by linux.midrange.com (8.9.3/8.8.7) with 
>UUCP id QAA12371for RPG400-L@midrange.com; Wed, 13 Sep 2000 16:35:11 -0500 
>Received: from lh2.rdc1.tx.home.com (ioracle@ha2.rdc1.tx.home.com 
>[24.4.0.67])by uucphost.mcs.net (8.9.3/8.9.3) with ESMTP id QAA97133for 
><RPG400-L@midrange.com>; Wed, 13 Sep 2000 16:32:46 -0500 
>(CDT)(envelope-from GaryGuthrie@home.com)
>Received: from home.com ([24.8.244.213]) by lh2.rdc1.tx.home.com          
>(InterMail vM.4.01.02.00 201-229-116) with ESMTP          id 
><20000913213245.TSRO22866.lh2.rdc1.tx.home.com@home.com>          for 
><RPG400-L@midrange.com>; Wed, 13 Sep 2000 14:32:45 -0700
>From rpg400-l-owner@uucphost.mcs.net Wed Sep 13 15:23:56 2000 
>X-Authentication-Warning: Kitten.mcs.net: 66 set sender to rpg400-l-owner 
>using -f
>Message-ID: <39BFF273.BED6B03D@home.com> 
>X-Mailer: Mozilla 4.7 [en] (Win98; I) 
>X-Accept-Language: en
>References: <Pine.LNX.4.21.0009131435510.6634-100000@orion.hq.dans.com> 
>Sender: owner-rpg400-l@midrange.com
>X-List-Name: RPG/400 Discussion Mailing List (RPG400-L@midrange.com) 
>
>I guess I'm not understanding. I don't see why you have to pass the 
>number of pages. See if I've got the scenario correct.
>
>You spool a 3 page report so that you have 
>
>Page 1 of ~~~~
>.
>.
>.
>
>Page 2 of ~~~~
>.
>.
>.
>
>Page 3 of ~~~~
>
>
>You then use the utility to get the total number of pages - now, 
>TotPages = 3
>
>You then have a program that scans for ~~~~ and replaces it with 
>TotPages
>
>Here's some pseudocode...
>
>
>Do While NbrPagesReplaced < TotPages 
>   Scan and replace
>   Add 1 to NbrPagesReplaced
>End Do
>
>After the third replacement, your loop ends. In other words, on page 3 
>you replace and your counter is equal so you quit. You don't go past the 
>total pages.
>
>Gary Guthrie
>REAL Solutions Technical Support
>NEWS/400 Technical Editor
>
>
>
> > On Wed, 13 Sep 2000, Gary Guthrie wrote: 
> >
> > > Rather than worry about the size of the user space, why not increment 
>a
> > > counter each time you make a replacment (increment after the
> > > replacement) and compare the counter to the number of pages. When 
> > > they're equal, you're finished.
> > >
> > > Will that be suitable?
>
>
>James David Rich wrote:
> >
> > I want to detect when I am at the end of the report without having to 
>pass
> > the number of pages.  But I guess I could use something like
> > GetSpoolFileAttributes() and find out how many pages there are. 
>+---
>| This is the RPG/400 Mailing List!
>| To submit a new message, send your mail to RPG400-L@midrange.com. 
>| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com. 
>| Questions should be directed to the list owner/operator: 
>david@midrange.com
>+---
     
_________________________________________________________________________ 
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
     
Share information about yourself, create your own public profile at 
http://profiles.msn.com.
     
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com. 
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com 
+---
     


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---