<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; line-break: after-white-space;" class="">I’m at a loss. If what Pierre suggests doesn’t work, then try this. Mainly to try something.<div class=""><div class=""><br class=""></div><div class="">Remove the ALIAS from the ACCESS statement.</div><div class=""><br class=""></div><div class="">Don’t use the AT STUDENT_NUM option on the SUBFILE statement.</div><div class=""><br class=""></div><div class="">Bob</div><div class=""><br class=""></div><div class=""><br class=""></div><div><br class=""><blockquote type="cite" class=""><div class="">On Aug 21, 2020, at 1:11 PM, Pierre Bouthillette <<a href="mailto:pierre.bouthillette@gmail.com" class="">pierre.bouthillette@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class=""><div class="gmail_default" style="font-family:comic sans ms,sans-serif;font-size:large;color:#000099">Try delete the filess, .dat, .idx etc before compiling</div></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" class=""><br class="">
<table style="border-top:1px solid #d3d4de" class="">
<tbody class=""><tr class="">
<td style="width:55px;padding-top:13px" class=""><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank" class=""><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;" class=""></a></td>
<td style="width:470px;padding-top:12px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px" class="">Virus-free. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank" style="color:#4453ea" class="">www.avast.com</a>
</td>
</tr>
</tbody></table><a href="x-msg://5/#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1" class=""></a></div><br class=""><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Fri, Aug 21, 2020 at 12:50 PM Helen Wellcome <<a href="mailto:HWellcom@wsboces.org" class="">HWellcom@wsboces.org</a>> wrote:<br class=""></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">
<div lang="EN-US" class="">
<div class="gmail-m_-4991836374173151837WordSection1"><p class="MsoNormal">Nope<u class=""></u><u class=""></u></p><p class="MsoNormal">So strange<u class=""></u><u class=""></u></p><p class="MsoNormal">E* Item specified for index/segment not part of subfile include list.<u class=""></u><u class=""></u></p><p class="MsoNormal">> go<u class=""></u><u class=""></u></p><p class="MsoNormal"><u class=""></u> <u class=""></u></p><p class="MsoNormal">We are on AIX version 5 , am I to look somewhere else for a version<u class=""></u><u class=""></u></p><p class="MsoNormal">helen<u class=""></u><u class=""></u></p><p class="MsoNormal"><u class=""></u> <u class=""></u></p>
<div class="">
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in" class=""><p class="MsoNormal"><b class="">From:</b> Robert Deskin <<a href="mailto:bob.deskin@me.com" target="_blank" class="">bob.deskin@me.com</a>> <br class="">
<b class="">Sent:</b> Friday, August 21, 2020 12:25 PM<br class="">
<b class="">To:</b> Helen Wellcome <<a href="mailto:HWellcom@wsboces.org" target="_blank" class="">HWellcom@wsboces.org</a>><br class="">
<b class="">Cc:</b> Murray Scholz <<a href="mailto:murray.scholz@abri.une.edu.au" target="_blank" class="">murray.scholz@abri.une.edu.au</a>>; PowerHouse List <<a href="mailto:powerh-l@lists.sowder.com" target="_blank" class="">powerh-l@lists.sowder.com</a>><br class="">
<b class="">Subject:</b> [EXTERNAL] Re: [EXTERNAL] having issues using index for a file<u class=""></u><u class=""></u></p>
</div>
</div><p class="MsoNormal"><u class=""></u> <u class=""></u></p><p style="background:fuchsia" class=""><b class="">** Warning! External Email! ** <u class=""></u><u class=""></u></b></p>
<div class=""><p class="MsoNormal">Try adding the segment option <u class=""></u><u class=""></u></p>
<div class=""><p class="MsoNormal"><u class=""></u> <u class=""></u></p>
</div>
<div class="">
<blockquote style="margin-top:5pt;margin-bottom:5pt" class="">
<div class=""><p class="MsoNormal" style="background:white"><span style="background:yellow" class="">> subfile xsthelentestgoogle keep at student_num include student_num, xemail1, xemail2 index student_num segment student_num</span><u class=""></u><u class=""></u></p>
</div>
</blockquote>
<div class=""><p class="MsoNormal"><u class=""></u> <u class=""></u></p>
</div>
<div class=""><p class="MsoNormal">No promises. I don’t see why what you have wouldn’t work. What version are you using?<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal"><u class=""></u> <u class=""></u></p>
</div>
<div class=""><p class="MsoNormal">Bob<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal"><br class="">
<br class="">
<u class=""></u><u class=""></u></p>
<blockquote style="margin-top:5pt;margin-bottom:5pt" class="">
<div class=""><p class="MsoNormal">On Aug 21, 2020, at 12:05 PM, Helen Wellcome <<a href="mailto:HWellcom@wsboces.org" target="_blank" class="">HWellcom@wsboces.org</a>> wrote:<u class=""></u><u class=""></u></p>
</div><p class="MsoNormal"><u class=""></u> <u class=""></u></p>
<div class="">
<div class=""><p class="MsoNormal" style="background:white">Didn’t work<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">I believe I had tried that before. But I re-tried<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">I would have thought it would have worked. Don’t know why its being so picky<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"> <u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"><span style="background:yellow" class="">set process nolimit</span><u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"><span style="background:yellow" class="">> access google_students_201920 alias xwork</span><u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"><span style="background:yellow" class="">> sort on student_num</span><u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"><span style="background:yellow" class="">> define xemail1 char*45 = email</span><u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"><span style="background:yellow" class="">> define xemail2 char*45 = " "</span><u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"><span style="background:yellow" class="">> subfile xsthelentestgoogle keep at student_num include student_num, xemail1, xemail2 index student_num</span><u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"><span style="background:yellow" class="">*E* Item specified for index/segment not part of subfile include list.</span><u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"><span style="background:yellow" class="">> go</span><u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"> <u class=""></u><u class=""></u></p>
</div>
<div class="">
<div style="border-right:none;border-bottom:none;border-left:none;border-top:1pt solid rgb(225,225,225);padding:3pt 0in 0in" class="">
<div class=""><p class="MsoNormal" style="background:white"><b class="">From:</b><span class="gmail-m_-4991836374173151837apple-converted-space"> </span>Murray Scholz <<a href="mailto:murray.scholz@abri.une.edu.au" target="_blank" class=""><span style="color:purple" class="">murray.scholz@abri.une.edu.au</span></a>><span class="gmail-m_-4991836374173151837apple-converted-space"> </span><br class="">
<b class="">Sent:</b><span class="gmail-m_-4991836374173151837apple-converted-space"> </span>Thursday, August 20, 2020 8:15 PM<br class="">
<b class="">To:</b><span class="gmail-m_-4991836374173151837apple-converted-space"> </span><a href="mailto:powerh-l@lists.sowder.com" target="_blank" class=""><span style="color:purple" class="">powerh-l@lists.sowder.com</span></a>; Helen Wellcome <<a href="mailto:HWellcom@wsboces.org" target="_blank" class=""><span style="color:purple" class="">HWellcom@wsboces.org</span></a>><br class="">
<b class="">Subject:</b><span class="gmail-m_-4991836374173151837apple-converted-space"> </span>[EXTERNAL] Re: having issues using index for a file<u class=""></u><u class=""></u></p>
</div>
</div>
</div>
<div class=""><p class="MsoNormal" style="background:white"> <u class=""></u><u class=""></u></p>
</div><p class="MsoNormal" style="background:fuchsia">
<b class=""><span style="font-size:12pt;font-family:LucidaGrande,serif" class="">** Warning! External Email! **<span class="gmail-m_-4991836374173151837apple-converted-space"> </span></span></b><span style="font-size:12pt;font-family:LucidaGrande,serif" class=""><u class=""></u><u class=""></u></span></p>
<div class=""><p class="MsoNormal" style="background:white">
<span style="font-size:12pt;font-family:LucidaGrande,serif" class="">Hello Helen,<br class="">
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.<br class="">
eg.<br class="">
> access parameters<br class="">
> sort on file-type<br class="">
> define a1 char*60 = param-descript<br class="">
> define a2 char*60 = " "<br class="">
> subfile xxxyyyzzz keep at file-type include file-type,a1,a2 index file-type<br class="">
> go<br class="">
<br class="">
Executing request 1 ...<br class="">
<br class="">
Records read:<br class="">
PARAMETERS 110<br class="">
<br class="">
Transactions processed: 110<br class="">
<br class="">
Records processed: Added Updated Unchanged Deleted<br class="">
XXXYYYZZZ 27 0 0 0<br class="">
<br class="">
Finished.<u class=""></u><u class=""></u></span></p><p class="MsoNormal" style="background:white">
<span style="font-size:12pt;font-family:LucidaGrande,serif" class="">>>>>>>>>>>>>>>>>>>>>>>> <u class=""></u><u class=""></u></span></p><p class="MsoNormal" style="background:white">
<span style="font-size:12pt;font-family:LucidaGrande,serif" class="">Hope that helps.<u class=""></u><u class=""></u></span></p><p class="MsoNormal" style="background:white">
<span style="font-size:12pt;font-family:LucidaGrande,serif" class="">Regards<br class="">
Murray Scholz<span class="gmail-m_-4991836374173151837apple-converted-space"> </span><u class=""></u><u class=""></u></span></p>
<pre style="background:white" class="">Agricultural Business Research Institute<u class=""></u><u class=""></u></pre>
<pre style="background:white" class="">University of New England<u class=""></u><u class=""></u></pre>
<pre style="background:white" class="">Armidale NSW 2351 Australia<u class=""></u><u class=""></u></pre>
<pre style="background:white" class="">Email <a href="mailto:murray.scholz@abri.une.edu.au" target="_blank" class=""><span style="color:purple" class="">murray.scholz@abri.une.edu.au</span></a> <u class=""></u><u class=""></u></pre>
<div class="">
<div class=""><p class="MsoNormal" style="background:white">On 21/08/20 10:00 am, Helen Wellcome wrote:<u class=""></u><u class=""></u></p>
</div>
</div>
<blockquote style="margin-top:5pt;margin-bottom:5pt" class="">
<div class=""><p class="MsoNormal" style="background:white">I have been coding with qtp for many years but am having a brain-lock.<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"> <u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">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.<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">I wanted to take this file and create a file with student_num email1 email2 (one record for the student)<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"> <u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"> <u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">set process nolimit<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">> access google_students_201920 alias xwork<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">> sort on student_num<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">> define xemail1 char*45 = email<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">> define xemail2 char*45 = " "<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">> subfile xsthelnetestgoogle at student_num index student_num keep include student_num, xemail1, xemail2<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"> ^^^^^<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">*E* Expected: . OF PORTABLE FORMAT <eol> ALIAS AT IF ON APPEND<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"> NOAPPEND KEEP TEMPORARY DICTIONARY NODICTIONARY INCLUDE<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"> <u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">If there was no error I then had setup:<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">Access google_students_201920 alias xwork &<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">Link student_num of xwork to student_num of *xsthelentestgoogle alias xtemp<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">Select if email of xwork <> xemail1 of xtemp<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">Output *xsthelentestgoogle update<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">Item xemail2 of *xsthelentestgoogle final email<u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white"> <u class=""></u><u class=""></u></p>
</div>
<div class=""><p class="MsoNormal" style="background:white">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.<span class="gmail-m_-4991836374173151837apple-converted-space"> </span><br class="">
<br class="">
<br class="">
<u class=""></u><u class=""></u></p>
</div>
</blockquote>
</div><p class="MsoNormal"><span style="font-size:12pt;font-family:LucidaGrande,serif;background:white" class="">--<span class="gmail-m_-4991836374173151837apple-converted-space"> </span></span><span style="font-size:12pt;font-family:LucidaGrande,serif" class=""><br class="">
<span style="background:white" class="">= = = = = = = = = = = = = = = = = = = = = = = = = = = =</span><br class="">
<span style="background:white" class="">Mailing list:<span class="gmail-m_-4991836374173151837apple-converted-space"> </span></span></span><a href="mailto:powerh-l@lists.sowder.com" target="_blank" class=""><span style="font-size:12pt;font-family:LucidaGrande,serif;color:purple;background:white" class="">powerh-l@lists.sowder.com</span></a><span style="font-size:12pt;font-family:LucidaGrande,serif" class=""><br class="">
<span style="background:white" class="">Subscribe: 'subscribe' in message body to<span class="gmail-m_-4991836374173151837apple-converted-space"> </span></span></span><a href="mailto:powerh-l-request@lists.sowder.com" target="_blank" class=""><span style="font-size:12pt;font-family:LucidaGrande,serif;color:purple;background:white" class="">powerh-l-request@lists.sowder.com</span></a><span style="font-size:12pt;font-family:LucidaGrande,serif" class=""><br class="">
<span style="background:white" class="">Unsubscribe: 'unsubscribe <password>' in message body to<span class="gmail-m_-4991836374173151837apple-converted-space"> </span></span></span><a href="mailto:powerh-l-request@lists.sowder.com" target="_blank" class=""><span style="font-size:12pt;font-family:LucidaGrande,serif;color:purple;background:white" class="">powerh-l-request@lists.sowder.com</span></a><span style="font-size:12pt;font-family:LucidaGrande,serif" class=""><br class="">
</span><a href="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" target="_blank" class=""><span style="font-size:12pt;font-family:LucidaGrande,serif;color:purple;background:white" class="">https://lists.sowder.com/mailman/listinfo/powerh-l</span></a><span style="font-size:12pt;font-family:LucidaGrande,serif" class=""><br class="">
<span style="background:white" class="">This list is closed, thus to post to the list you must be a subscriber.</span><br class="">
<span style="background:white" class="">Add 'site:</span></span><a href="https://linkprotect.cudasvc.com/url?a=http%3a%2f%2flists.sowder.com%2f&c=E,1,YoAzsi-8URLBZXhA1fW1w32db6iLZMRuI544lmfVeGkoOylgRJlmk6AxuNDbPrS4ENMU6R3uuFuAfgwwbDOJ82JiLBDjKHfJHxDK0Nyu&typo=1" target="_blank" class=""><span style="font-size:12pt;font-family:LucidaGrande,serif;color:purple;background:white" class="">lists.sowder.com</span></a><span class="gmail-m_-4991836374173151837apple-converted-space"><span style="font-size:12pt;font-family:LucidaGrande,serif;background:white" class=""> </span></span><span style="font-size:12pt;font-family:LucidaGrande,serif;background:white" class="">powerh-l'
to your search terms to search the list archive at Google.</span><u class=""></u><u class=""></u></p>
</div>
</blockquote>
</div><p class="MsoNormal"><u class=""></u> <u class=""></u></p>
</div>
</div>
</div>
</div>
-- <br class="">
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br class="">
Mailing list: <a href="mailto:powerh-l@lists.sowder.com" target="_blank" class="">powerh-l@lists.sowder.com</a><br class="">
Subscribe: 'subscribe' in message body to <a href="mailto:powerh-l-request@lists.sowder.com" target="_blank" class="">powerh-l-request@lists.sowder.com</a><br class="">
Unsubscribe: 'unsubscribe <password>' in message body to <a href="mailto:powerh-l-request@lists.sowder.com" target="_blank" class="">powerh-l-request@lists.sowder.com</a><br class="">
<a href="https://lists.sowder.com/mailman/listinfo/powerh-l" rel="noreferrer" target="_blank" class="">https://lists.sowder.com/mailman/listinfo/powerh-l</a><br class="">
This list is closed, thus to post to the list you must be a subscriber.<br class="">
Add 'site:<a href="http://lists.sowder.com/" rel="noreferrer" target="_blank" class="">lists.sowder.com</a> powerh-l' to your search terms to search the list archive at Google.</blockquote></div><div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" class=""><br class="">
<table style="border-top:1px solid #d3d4de" class="">
<tbody class=""><tr class="">
<td style="width:55px;padding-top:13px" class=""><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank" class=""><img src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" alt="" width="46" height="29" style="width: 46px; height: 29px;" class=""></a></td>
<td style="width:470px;padding-top:12px;color:#41424e;font-size:13px;font-family:Arial,Helvetica,sans-serif;line-height:18px" class="">Virus-free. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank" style="color:#4453ea" class="">www.avast.com</a>
</td>
</tr>
</tbody></table><a href="x-msg://5/#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2" width="1" height="1" class=""></a></div>
</div></blockquote></div><br class=""></div></body></html>