Quiz example
Using INDEX'd SUBFILE.
Access items
Define company char*2 = item[1:2]
DEFINE KOUNT NUM*9 = 1
SELECT IF CLASS = "99"
Report sum company kount sub
Set subfile name AT COMPANY COMPKOUN INDEX COMPANY
SET REPORT LIMIT 100
GO
ACCESS ITEMS
REPORT SUM COMPANY ITEM AMT-OFSALE SUB
SELECT IF CLASS <> "99"
SET SUBFILE NAME AT CLASS NAME ITCLASS
GO
ACCESS *ITCLASS LIN COMPANY TO COMPANY OF *COMPKOUN
REPORT ITEM CLASS COMPANY KOUNT
GO
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of HP3000-L automatic digest system
Sent: Wednesday, September 20, 2017 11:08 PM
To: [log in to unmask]
Subject: HP3000-L Digest - 19 Sep 2017 to 20 Sep 2017 (#2017-93)
There are 5 messages totaling 218 lines in this issue.
Topics of the day:
1. Quiz Subfile to Subfile (4)
2. QSK
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
----------------------------------------------------------------------
Date: Wed, 20 Sep 2017 11:21:53 -0400
From: John Sommer <[log in to unmask]>
Subject: 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 *
------------------------------
Date: Wed, 20 Sep 2017 15:32:01 +0000
From: "Pickering, John" <[log in to unmask]>
Subject: Re: Quiz Subfile to Subfile
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 *
------------------------------
Date: Wed, 20 Sep 2017 16:21:41 +0000
From: "Johnson, Tracy" <[log in to unmask]>
Subject: Re: Quiz Subfile to Subfile
Keep one of the subfiles with INDEX {sortfield}
Where sortfield was an item you had done a sort on.
They you can link to it from some other subfile.
The sorted subfile behaves like KSAM.
Tracy Johnson
+00 1 757 766-4318 tel
+00 1 757 755-6470 mobile
Hampton, Virginia, U.S.
[log in to unmask]
> -----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
>
> The following message was sent from an external e-mail address. Be
> cautious when clicking on links, opening attachments or providing
> sensitive information.
>
> ________________________________
>
> 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 *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
------------------------------
Date: Wed, 20 Sep 2017 16:23:51 +0000
From: "Johnson, Tracy" <[log in to unmask]>
Subject: Re: Quiz Subfile to Subfile
Typo: change "They" to "Then" on my third sentence.
Tracy Johnson
+00 1 757 766-4318 tel
+00 1 757 755-6470 mobile
Hampton, Virginia, U.S.
[log in to unmask]
> -----Original Message-----
> From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
> Behalf Of Johnson, Tracy
> Sent: Wednesday, September 20, 2017 12:22 PM
> To: [log in to unmask]
> Subject: Re: [HP3000-L] Quiz Subfile to Subfile
>
> [This sender failed our fraud detection checks and may not be who they
> appear to be. Learn about spoofing at
> http://aka.ms/LearnAboutSpoofing]
>
> Keep one of the subfiles with INDEX {sortfield}
>
> Where sortfield was an item you had done a sort on.
>
> They you can link to it from some other subfile.
>
> The sorted subfile behaves like KSAM.
>
>
> Tracy Johnson
> +00 1 757 766-4318 tel
> +00 1 757 755-6470 mobile
> Hampton, Virginia, U.S.
> [log in to unmask]
>
> > -----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
> >
> > The following message was sent from an external e-mail address. Be
> > cautious when clicking on links, opening attachments or providing
> > sensitive information.
> >
> > ________________________________
> >
> > 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 *
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
------------------------------
Date: Thu, 21 Sep 2017 02:51:30 +0000
From: "Stanfield, Randy (Carrollton, TX)" <[log in to unmask]>
Subject: QSK
Anyone have experience with QSK in the HP3000 and Webservice calls? Needing a little trouble shooting advise.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
------------------------------
End of HP3000-L Digest - 19 Sep 2017 to 20 Sep 2017 (#2017-93)
**************************************************************
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|