A couple of options ...
Subfiles can be indexed files if that helps. I have always found indexed subfiles to be quite slow and try to avoid them but sometimes they may be the right solution.
A second method could involve reading the 2 listf files and appending them to the same subile - include the account and the filename. Read the combined file and define 2 variables, one for each account. Sort the file by filename and write a report or subfile at the filename plus the 2 account variables with the maximum function on them. This will flatten the combined file into one record for each filename with a pair of account variables with either the account name or spaces. Let me know if this isn't clear!
Regards,
JWP
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of John Sommer
Sent: Wednesday, September 20, 2017 11:22 AM
To: [log in to unmask]
Subject: [HP3000-L] Quiz Subfile to Subfile
Hi All,
Being inQuizitive today.
Does anyone know of a trick to link one Quiz subfile to another subfile?
I've spent 2 hours this morning doing experiment after experiment and so far, all I get are error messages.
Project:
Pipe LISTF data from two different accounts into text files.
Import the LISTF text files into a Quiz subfile.
Compare subfiles to determine which files do not exist in on or the other accounts and differences in file sizes.
I have it working with the exception of linking the subfiles.
I can also do this via Excel, but I would rather automate the process on the HP3000.
Thanks for any thoughts,
John
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
________________________________
Email Disclaimer:
This message, including any attachments, may contain information that is proprietary, privileged and/or confidential and is intended exclusively for the person(s) to whom it is addressed. If you are not the intended recipient or have received this message in error, please notify the sender immediately by reply email and permanently delete the original transmission from the sender, including any attachments, without making a copy.
Avertissement:
Ce message, y compris tous fichiers joints, peut contenir des renseignements qui sont de nature privée, privilégiée et/ou confidentielle et vise exclusivement la(les) personne(s) à qui il est adressé. Si vous n’êtes pas le destinataire visé ou si vous avez reçu ce message par erreur, veuillez en aviser immédiatement l’expéditeur en répondant au courriel et supprimer de façon permanente la transmission originale de l’expéditeur, y compris tous fichiers joints, sans en avoir fait de copie.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
