<!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=406325514-02102007><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 class=406325514-02102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406325514-02102007><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 class=406325514-02102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406325514-02102007><FONT face=Arial
color=#0000ff size=2>as in:</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406325514-02102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406325514-02102007><FONT face=Arial
color=#0000ff size=2>ACCESS *FileA</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406325514-02102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406325514-02102007><FONT face=Arial
color=#0000ff size=2>select out some stuff</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=406325514-02102007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=406325514-02102007><FONT face=Arial
color=#0000ff size=2>SUBFILE FileA alias newfile</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV><SPAN class=406325514-02102007></SPAN><FONT face=Arial><FONT
color=#0000ff><FONT size=2>K<SPAN
class=406325514-02102007>en</SPAN></FONT></FONT></FONT><BR></DIV>
<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 10:18
AM<BR><B>To:</B> Ken Langendock<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>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
href="mailto:Ken@langendock.com">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 class=e id=q_11560b678650d43b_1>
<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 link="blue" vlink="purple">
<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></BODY></HTML>