[EXTERNAL] Re: [EXTERNAL] having issues using index for a file
Pierre Bouthillette
pierre.bouthillette at gmail.com
Fri Aug 21 12:11:13 CDT 2020
Try delete the filess, .dat, .idx etc before compiling
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
On Fri, Aug 21, 2020 at 12:50 PM Helen Wellcome <HWellcom at wsboces.org>
wrote:
> Nope
>
> So strange
>
> E* Item specified for index/segment not part of subfile include list.
>
> > go
>
>
>
> We are on AIX version 5 , am I to look somewhere else for a version
>
> helen
>
>
>
> *From:* Robert Deskin <bob.deskin at me.com>
> *Sent:* Friday, August 21, 2020 12:25 PM
> *To:* Helen Wellcome <HWellcom at wsboces.org>
> *Cc:* Murray Scholz <murray.scholz at abri.une.edu.au>; PowerHouse List <
> powerh-l at lists.sowder.com>
> *Subject:* [EXTERNAL] Re: [EXTERNAL] having issues using index for a file
>
>
>
> *** Warning! External Email! ** *
>
> Try adding the segment option
>
>
>
> > subfile xsthelentestgoogle keep at student_num include student_num,
> xemail1, xemail2 index student_num segment student_num
>
>
>
> No promises. I don’t see why what you have wouldn’t work. What version are
> you using?
>
>
>
> Bob
>
>
>
> On Aug 21, 2020, at 12:05 PM, Helen Wellcome <HWellcom at wsboces.org> wrote:
>
>
>
> Didn’t work
>
> I believe I had tried that before. But I re-tried
>
> I would have thought it would have worked. Don’t know why its being so
> picky
>
>
>
> set process nolimit
>
> > access google_students_201920 alias xwork
>
> > sort on student_num
>
> > define xemail1 char*45 = email
>
> > define xemail2 char*45 = " "
>
> > subfile xsthelentestgoogle keep at student_num include student_num,
> xemail1, xemail2 index student_num
>
> *E* Item specified for index/segment not part of subfile include list.
>
> > go
>
>
>
> *From:* Murray Scholz <murray.scholz at abri.une.edu.au>
> *Sent:* Thursday, August 20, 2020 8:15 PM
> *To:* powerh-l at lists.sowder.com; Helen Wellcome <HWellcom at wsboces.org>
> *Subject:* [EXTERNAL] Re: having issues using index for a file
>
>
>
> *** Warning! External Email! ** *
>
> Hello Helen,
> I think it's just complaining about the syntax of your subfile statement.
> Put the "index student_num" at the end, after your list of items.
> eg.
> > access parameters
> > sort on file-type
> > define a1 char*60 = param-descript
> > define a2 char*60 = " "
> > subfile xxxyyyzzz keep at file-type include file-type,a1,a2 index
> file-type
> > go
>
> Executing request 1 ...
>
> Records read:
> PARAMETERS 110
>
> Transactions processed: 110
>
> Records processed: Added Updated Unchanged
> Deleted
> XXXYYYZZZ 27 0
> 0 0
>
> Finished.
>
> >>>>>>>>>>>>>>>>>>>>>>>
>
> Hope that helps.
>
> Regards
> Murray Scholz
>
> Agricultural Business Research Institute
>
> University of New England
>
> Armidale NSW 2351 Australia
>
> Email murray.scholz at abri.une.edu.au
>
> On 21/08/20 10:00 am, Helen Wellcome wrote:
>
> I have been coding with qtp for many years but am having a brain-lock.
>
>
>
> I have a file of students with emails. There are some students with 2
> records and has caused problems on one of the reports , by listing a course
> twice.
>
> I wanted to take this file and create a file with student_num
> email1 email2 (one record for the student)
>
>
>
>
>
> set process nolimit
>
> > access google_students_201920 alias xwork
>
> > sort on student_num
>
> > define xemail1 char*45 = email
>
> > define xemail2 char*45 = " "
>
> > subfile xsthelnetestgoogle at student_num index student_num keep include
> student_num, xemail1, xemail2
>
> ^^^^^
>
> *E* Expected: . OF PORTABLE FORMAT <eol> ALIAS AT IF ON APPEND
>
> NOAPPEND KEEP TEMPORARY DICTIONARY NODICTIONARY INCLUDE
>
>
>
> If there was no error I then had setup:
>
> Access google_students_201920 alias xwork &
>
> Link student_num of xwork to student_num of *xsthelentestgoogle alias xtemp
>
> Select if email of xwork <> xemail1 of xtemp
>
> Output *xsthelentestgoogle update
>
> Item xemail2 of *xsthelentestgoogle final email
>
>
>
> CONFIDENTIALITY NOTICE: The information contained in this message is
> confidential, and is intended only for the addressee. If the reader of this
> message is not the intended recipient, or employee or agent responsible for
> delivering it to the intended recipient, you are hereby notified that
> dissemination, distribution, or copying of this communication or any of its
> content is strictly prohibited and may be unlawful. If you have received
> this communication in error, please notify us promptly at (631) 549-4900
> and destroy the email and any copies.
>
>
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: 'subscribe' in message body to
> powerh-l-request at lists.sowder.com
> Unsubscribe: 'unsubscribe <password>' in message body to
> powerh-l-request at lists.sowder.com
> https://lists.sowder.com/mailman/listinfo/powerh-l
> <https://linkprotect.cudasvc.com/url?a=https%3a%2f%2flists.sowder.com%2fmailman%2flistinfo%2fpowerh-l&c=E,1,UZU647bIRdQ4f6FlzykmFqz_wBBZyV9ZaKGInPvFAMgfZy8UNrATIZedOsLYgkejB-cRlpD3QkQW_S2PeqFfCwFTFrtEqLCsOyMTsiDC&typo=1>
> This list is closed, thus to post to the list you must be a subscriber.
> Add 'site:lists.sowder.com
> <https://linkprotect.cudasvc.com/url?a=http%3a%2f%2flists.sowder.com%2f&c=E,1,YoAzsi-8URLBZXhA1fW1w32db6iLZMRuI544lmfVeGkoOylgRJlmk6AxuNDbPrS4ENMU6R3uuFuAfgwwbDOJ82JiLBDjKHfJHxDK0Nyu&typo=1>
> powerh-l' to your search terms to search the list archive at Google.
>
>
> --
> = = = = = = = = = = = = = = = = = = = = = = = = = = = =
> Mailing list: powerh-l at lists.sowder.com
> Subscribe: 'subscribe' in message body to
> powerh-l-request at lists.sowder.com
> Unsubscribe: 'unsubscribe <password>' in message body to
> powerh-l-request at lists.sowder.com
> https://lists.sowder.com/mailman/listinfo/powerh-l
> This list is closed, thus to post to the list you must be a subscriber.
> Add 'site:lists.sowder.com powerh-l' to your search terms to search the
> list archive at Google.
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
Virus-free.
www.avast.com
<https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail>
<#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20200821/1f488d42/attachment-0001.html>
More information about the powerh-l
mailing list