RE: [SYSTEM21] JBA Reporting

[Bill Pinnington <BPinnington@xxxxxxxxxxxxx>]

Unfortunately not.  If you have two records which are identical, and you add
a column with INP95 in each record, your records will still be identical ;-)
We are stuck with using the RRN, and when we want to REORG INP95 we have to
refresh the table in order for it to be updated with the new RRNs.

Kind regards,
Bill



-----Original Message-----
From: welchj@xxxxxxxx [mailto:welchj@xxxxxxxx]
Sent: 07 July 2003 21:19
To: system21@xxxxxxxxxxxx
Subject: RE: [SYSTEM21] JBA Reporting


This message has been successfully virus checked by the Centura Foods Mail
system. 

I have not used  Transformation Server, but would it be possible
to include a Constant field that contained the file name (ie INP95)
when pushing the data out to Transformation Server tables?
You could then use this as part of unique key.

Just wondering,
  Jack

>
> We also suffer from a lack of unique key on all JBA files, INP95 and
> PMP09 being prime examples as you say.  You can work round this by using
> the Relative Record Number (RRN) which gives you a unique key.  It works
> well, but watch out after archiving when you reorg your files!!!
>
> Regards,
> Bill
>
>



_______________________________________________
This is the System 21 Users (SYSTEM21) mailing list
To post a message email: SYSTEM21@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/system21
or email: SYSTEM21-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/system21.


________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________


=======================================================
This email, its content and any files transmitted with it are confidential
and intended solely for the use of the individual(s) to whom it is 
addressed.
If you are not the intended recipient, be advised that you have received
this email in error and that any use, dissemination, forwarding, printing, 
or copying of this email is strictly prohibited.
This email, its contents and any files transmitted with it have been 
prepared using information believed by the author to be reliable and
accurate, but Centura Foods Ltd. makes no warranty as to accuracy or
completeness. In particular Centura Foods Ltd. does not accept 
responsibility for changes made to this email or related files after it was 
sent. Any opinions expressed in this email and any related documents
are those of the author and do not necessarily reflect the opinions of
Centura Foods Ltd. or its associated companies.

If you have received this email in error please notify the Centura Foods
IT Helpdesk by telephone on +44 (0) 1606 830 533.
=======================================================


________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________