Output Update & Subfile

[Merol Newman]

or this... (again, pseudo and untested)

 access era link to dupe-ksam opt
 select if value of era = value of dupe-ksam or not record dupe-ksam exists
   (because I think you said you could not link to the exact record by the key -
    you must be using something else to match them, so value is just an example)

 def dupe-assigned cha*1 = "Y" if assigned of dupe-ksam = "Y" (or whatever)

 output dupe-ksam update if record dupe-ksam exists and assigned ne "Y"
 item assigned final "Y"

 subfile erabad keep append if not record dupe-ksam exists &
   or assigned of dupe-ksam = "Y" &
   incl era, dupe-assigned

Then you will have a record of both errors and be able to tell the difference.

 
Merol Newman
E-mail: meroln@specialist.co.uk <mailto:meroln@specialist.co.uk>


> -----Original Message-----
> From: owner-powerh-l@sphere.swau.edu
> [mailto:owner-powerh-l@sphere.swau.edu]On Behalf Of Chris Sharman
> Sent: 05 April 2000 15:27
> To: balddaddyray@yahoo.com
> Cc: Chris.Sharman@ccagroup.co.uk; powerh-l@lists.swau.edu
> Subject: Re: Output Update & Subfile
>
>
>
> >It's not that simple. I would like to write the
> >records that would be reported by an "ON ERRORS
> >REPORT" message to a subfile. Essentially any records
> >from ERA that I cannot apply to an existing record in
> >DUPE-KSAM, either because they are non-existing or
> >because all matching records in DUPE-KSAM have been
> >already assigned, I would like to write to the ERABAD
> >subfile.
>
> Like this (pseudo-qtp) ?
>
> access era link to dupe-ksam opt
> select dupe-ksam if not already assigned
>
> output dupe-ksam update if record dupe-ksam exists
> subfile erabad keep append if not record dupe-ksam exists incl era
>
> Chris
> _______________________________________________________________________
> Chris.Sharman@CCAgroup.co.uk		http://www.ccastat.demon.co.uk/
> CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
> = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
> Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
> This list is closed, thus to post to the list, you must be a subscriber.
>

= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
This list is closed, thus to post to the list, you must be a subscriber.