<div>Ok, another thing to revise in the migration process... the list is getting too long... I'm starting to miss the old HP3000 ;-)</div>
<div> </div>
<div>Thanks,</div>
<div> </div>
<div>Dani<br><br> </div>
<div><span class="gmail_quote">2007/10/2, Ken Langendock <<a href="mailto:Ken@langendock.com">Ken@langendock.com</a>>:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">HP is very forgiving in it's files. splitting the programs into two will be your fastest approach</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">Another thing to watch out for, if you have any requests that read and overwrite to the same sub file, change it.!</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">as in:</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">ACCESS *FileA</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">select out some stuff</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">SUBFILE FileA alias newfile</font></span></div>
<div> </div>
<div><span></span><font face="Arial"><font color="#0000ff"><font size="2">K<span>en</span></font></font></font><br> </div>
<div lang="en-us" dir="ltr" align="left">
<hr>
<font face="Tahoma" size="2"><span class="q"><b>From:</b> powerh-l-bounces+ken.langendock=<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:rogers.com@lists.sowder.com" target="_blank">rogers.com@lists.sowder.com
</a> [mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com" target="_blank">powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com</a>
] <b>On Behalf Of </b>Daniel Rodríguez<br></span><b>Sent:</b> October 2, 2007 10:18 AM<br><b>To:</b> Ken Langendock
<div><span class="e" id="q_115613933b5b6062_3"><br><b>Cc:</b> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a><br><b>Subject:
</b> Re: Too many files declared for this run. QTP ending.<br></span></div></font><br> </div>
<div><span class="e" id="q_115613933b5b6062_5">
<div></div>Hi Ken,<br><br>We were told that QTP was not very fast without creating alternative index so we have created many search keys in Oracle. We are converting to the new enviroment our first QTP's now I realize that the performance it's not so bad without indexes...
<br><br>We will study more carefully the creation of indexes in the future... Thank you very much!<br><br>But, my problem with the number of files still exists. I've removed all the viaindex, replaced a 3 file access statement with one cursor and the problem continues... I'm going slightly mad... I think we will split in 2 all those big QTP's... but it's a little bit annoying...
<br><br>Best regards,<br><br>Daniel Rodriguez.<br><br><br>
<div><span class="gmail_quote">2007/10/2, Ken Langendock <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:Ken@langendock.com" target="_blank">Ken@langendock.com</a>>:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">Daniel, why did you use VIAINDEX statements when using Oracle? My rule of thumb is to have only one Primary/Unique index in a file and allow Oracle to control the access method itself. It is smart enough to know the fastest way of retrieving the results you want without being told what index to use.
</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">LINK a, b to a,b in mytable is all you need to do.</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">Adding Cursors will definitely speed it up 10 fold.</font></span></div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2"></font></span> </div>
<div dir="ltr" align="left"><span><font face="Arial" color="#0000ff" size="2">Ken</font></span></div><br>
<div lang="en-us" dir="ltr" align="left">
<hr>
<font face="Tahoma" size="2"><b>From:</b> powerh-l-bounces+ken.langendock=<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:rogers.com@lists.sowder.com" target="_blank">rogers.com@lists.sowder.com</a>
[mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com" target="_blank">powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com</a>]
<b>On Behalf Of </b>Daniel Rodríguez<br><b>Sent:</b> October 2, 2007 5:45 AM<br><b>To:</b> Franck LERAY<br><b>Cc:</b> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com" target="_blank">
powerh-l@lists.sowder.com</a><br><b>Subject:</b> Re: Too many files declared for this run. QTP ending.<br></font><br> </div>
<div><span>
<div></div>Ok, I will try to replace some lines of code with SQL statements and we'll see...<br><br>Thanks,<br><br>Dani<br><br>
<div><span class="gmail_quote">2007/10/2, Franck LERAY <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:franck.leray@cheops.fr" target="_blank">franck.leray@cheops.fr </a>>:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<div lang="FR" vlink="purple" link="blue">
<div>
<p><font face="Arial" color="navy" size="2"><span lang="EN-GB" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Hi Daniel,</span></font></p>
<p><font face="Arial" color="navy" size="2"><span lang="EN-GB" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></span></font> </p>
<p><font face="Arial" color="navy" size="2"><span lang="EN-GB" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Mmm, I think there's a difference of one file between HP3000 and UNIX. Oh, I can't explain why!!!
</span></font></p>
<p><font face="Arial" color="navy" size="2"><span lang="EN-GB" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></span></font> </p>
<p><font face="Arial" color="navy" size="2"><span lang="EN-GB" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Regards,</span></font></p>
<p><font face="Arial" color="navy" size="2"><span lang="EN-GB" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial"></span></font> </p>
<p><font face="Arial" color="navy" size="2"><span lang="EN-GB" style="FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Franck.</span></font></p>
<div>
<p><font face="Times New Roman" size="3"><span lang="EN-GB" style="FONT-SIZE: 12pt"></span></font> </p></div>
<div>
<div style="TEXT-ALIGN: center" align="center"><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">
<hr align="center" width="100%" size="2">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">De :</span></font></b><font face="Tahoma" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> powerh-l-bounces+franck.leray=
<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:cheops.fr@lists.sowder.com" target="_blank">cheops.fr@lists.sowder.com</a> [mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l-bounces+franck.leray=cheops.fr@lists.sowder.com" target="_blank">
powerh-l-bounces+franck.leray=cheops.fr@lists.sowder.com</a>] <b><span style="FONT-WEIGHT: bold">De la part de</span></b> Daniel Rodríguez<br><b><span style="FONT-WEIGHT: bold">Envoyé :</span></b> mardi 2 octobre 2007 10:02
<br><b><span style="FONT-WEIGHT: bold">À :</span></b> <a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:powerh-l@lists.sowder.com" target="_blank">powerh-l@lists.sowder.com</a><br><b><span style="FONT-WEIGHT: bold">
Objet :</span></b> Too many files declared for this run. QTP ending.</span></font></p></div>
<div><span>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt"></span></font> </p>
<p><font face="Times New Roman" size="3"><span style="FONT-SIZE: 12pt">Hi all,<br><br>When compiling a big QTP migrated from HP3000/MPE/TurboImage/Powerhouse 7.29 to HP9000/Hp-UX/Oracle 10.2/Powerhouse 8.43.D1 we get the following error: "Too many files declared for this run. QTP ending." and it exits from QTP.
<br><br>We haven't added any file to the QTP in the migration process. We have only added the VIAINDEX keyword in the access statement.<br><br>Has the file limit been decreased in the new version? Or, QTP counts files and subfiles in a different way in this version?
<br><br>Regards,<br><br>Daniel Rodriguez Olías</span></font></p></span></div></div></div></blockquote></div><br></span></div></div></blockquote></div><br></span></div></div></blockquote></div><br>