powerh-l Digest, Vol 152, Issue 6 Re:[EXTERNAL] [EXTERNAL] having issues using index for a file

Fri Aug 21 15:29:29 CDT 2020

 Hi 

Try to shorten your subfile name.
Thanks,Krikor

    On Friday, August 21, 2020, 1:16:20 PM EDT, <powerh-l-request at lists.sowder.com> wrote:  

 Send powerh-l mailing list submissions to
    powerh-l at lists.sowder.com

To subscribe or unsubscribe via the World Wide Web, visit
    https://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
    powerh-l-request at lists.sowder.com

You can reach the person managing the list at
    powerh-l-owner at lists.sowder.com

When replying, please edit your Subject line so it is more specific
than "Re: Contents of powerh-l digest..."

Today's Topics:

  1. Re:[EXTERNAL] [EXTERNAL] having issues using index for a file
      (Robert Deskin)

----------------------------------------------------------------------

Message: 1
Date: Fri, 21 Aug 2020 13:14:50 -0400
From: Robert Deskin <bob.deskin at me.com>
To: Pierre Bouthillette <pierre.bouthillette at gmail.com>, 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: Re: [EXTERNAL] [EXTERNAL] having issues using index for a
    file
Message-ID: <EF556E88-7575-42A7-838A-0682887952B2 at me.com>
Content-Type: text/plain; charset="utf-8"

I’m at a loss. If what Pierre suggests doesn’t work, then try this. Mainly to try something.

Remove the ALIAS from the ACCESS statement.

Don’t use the AT STUDENT_NUM option on the SUBFILE statement.

Bob

> On Aug 21, 2020, at 1:11 PM, Pierre Bouthillette <pierre.bouthillette at gmail.com> wrote:
> 
> 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> <x-msg://5/#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
> On Fri, Aug 21, 2020 at 12:50 PM Helen Wellcome <HWellcom at wsboces.org <mailto: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 <mailto:bob.deskin at me.com>> 
> Sent: Friday, August 21, 2020 12:25 PM
> To: Helen Wellcome <HWellcom at wsboces.org <mailto:HWellcom at wsboces.org>>
> Cc: Murray Scholz <murray.scholz at abri.une.edu.au <mailto:murray.scholz at abri.une.edu.au>>; PowerHouse List <powerh-l at lists.sowder.com <mailto: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 <mailto: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 <mailto:murray.scholz at abri.une.edu.au>> 
> Sent: Thursday, August 20, 2020 8:15 PM
> To: powerh-l at lists.sowder.com <mailto:powerh-l at lists.sowder.com>; Helen Wellcome <HWellcom at wsboces.org <mailto: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 <mailto: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 <mailto:powerh-l at lists.sowder.com>
> Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com <mailto:powerh-l-request at lists.sowder.com>
> Unsubscribe: 'unsubscribe <password>' in message body to powerh-l-request at lists.sowder.com <mailto: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 <mailto:powerh-l at lists.sowder.com>
> Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com <mailto:powerh-l-request at lists.sowder.com>
> Unsubscribe: 'unsubscribe <password>' in message body to powerh-l-request at lists.sowder.com <mailto:powerh-l-request at lists.sowder.com>
> https://lists.sowder.com/mailman/listinfo/powerh-l <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 <http://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> <x-msg://5/#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20200821/f6978287/attachment.html>

------------------------------

Subject: Digest Footer

-- 
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.

------------------------------

End of powerh-l Digest, Vol 152, Issue 6
****************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.sowder.com/pipermail/powerh-l/attachments/20200821/8ffbb350/attachment-0001.html>