<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16525" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=281430512-02102007><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 class=281430512-02102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=281430512-02102007><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 class=281430512-02102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=281430512-02102007><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 class=281430512-02102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=281430512-02102007><FONT face=Arial
color=#0000ff size=2>Ken</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com@lists.sowder.com] <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>
powerh-l@lists.sowder.com<BR><B>Subject:</B> Re: Too many files declared for
this run. QTP ending.<BR></FONT><BR></DIV>
<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
href="mailto:franck.leray@cheops.fr">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 class=e id=q_1155ffefa8bc0bf9_1>
<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></BODY></HTML>