<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Message</TITLE>
<META content="MSHTML 6.00.2800.1523" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=211035718-09122005><FONT face=Arial color=#0000ff
size=2>Cool. Can you explain why this would make a
process faster, if every record has a mandatory link? There are
cascading links as well, can this be handled using this
method?</FONT></SPAN></DIV>
<DIV><SPAN class=211035718-09122005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Ken Langendock
[mailto:Ken@Langendock.com]<BR><B>Sent:</B> 2005 December 9 10:52
AM<BR><B>To:</B> Johnson, Harold A EDUC:EX;
powerh-l@lists.sowder.com<BR><B>Subject:</B> RE: [Bulk] set file
command<BR><BR></FONT></DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff
size=2>Harold. the file that you are trying to access as Read Only. Is it
required in the access statement to filter something? Or is it used to
populate something in the output phase?</FONT></SPAN></DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff size=2>If
you are only using it to populate fields in the output phase you can open the
file in the output phase, this is much faster.</FONT></SPAN></DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff size=2>As
in</FONT></SPAN></DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff
size=2>OUTPUT readonlyfile &</FONT></SPAN></DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff
size=2>
ADD & ; this doesn't really add the record but it gets the buffers to read
once for every record complex.</FONT></SPAN></DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff
size=2>
UPDATE & ; this allows the record to be optional</FONT></SPAN></DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff
size=2>
VIA &</FONT></SPAN></DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff
size=2>
USING &</FONT></SPAN></DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff
size=2>
NOITEMS & ; don't initialize anything</FONT></SPAN></DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff
size=2>
IF 1 EQ 2 ; this stops the record from ever being updated</FONT></SPAN></DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff size=2>This
allows you to have a much smaller record complex in the input phase, thereby
speeding up the Input and Sort phases.</FONT></SPAN></DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff
size=2>Ken</FONT></SPAN></DIV>
<DIV><SPAN class=706464718-09122005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><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>Johnson, Harold A EDUC:EX<BR><B>Sent:</B> December 9, 2005 12:32
PM<BR><B>To:</B> powerh-l@lists.sowder.com<BR><B>Subject:</B> [Bulk] set file
command<BR><BR></FONT></DIV>
<DIV><SPAN class=326182817-09122005><FONT face=Arial color=#0000ff size=2>A
question regarding the "set file" command in QTP. Recently, we were
running a new process in QTP which had a large number of links, but each file
was meantioned in a "set file xxx open read" statement. However, during
the run, this process caused a lock on a table! Is this syntax not
applicable anymore? If so, what syntax should we be
using? ie: "set file xxx open 1" ??</FONT></SPAN></DIV>
<DIV><SPAN class=326182817-09122005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=326182817-09122005><FONT face=Arial color=#0000ff
size=2>thnx</FONT></SPAN></DIV>
<DIV><SPAN class=326182817-09122005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=326182817-09122005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=326182817-09122005><FONT face=Arial color=#0000ff
size=2>OpenVMS v7.3-2 RDB
v7.1-241 PH v7.10.G1</FONT></SPAN></DIV>
<DIV><SPAN class=326182817-09122005><FONT face=Arial color=#0000ff
size=2> </FONT></SPAN></DIV>
<DIV><SPAN class=326182817-09122005><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV></BLOCKQUOTE></BODY></HTML>