Thanks a TON Joe. :-D<br><br>Vamsi <br><br><br><div><span class="gmail_quote">On 6/1/07, <b class="gmail_sendername">Joe Boyle</b> <<a href="mailto:atla38@dsl.pipex.com">atla38@dsl.pipex.com</a>> wrote:</span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="white" link="blue" vlink="blue" lang="EN-GB">
<div>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">If you plan on 'deleting'
regularly, it might be worth adding a second file and record structure to your
dictionary based on the original file. You could then use qtp to transfer
required records to file2, and then simply rename file2 to the original
filename. You do not need to recompile the whole dictionary to add a file and
record structure; details below.</span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;"> </span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">Open Qshow</span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">>set lang pdl</span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">>gen file orig_file</span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">>e</span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;"> </span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">Edit the qshogen file created from above,
changing orig_file references to orig_file2 ( the elements are already in the
dictionary so you won't need them )</span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;"> </span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">Open Pdl</span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">> paste in the file statement from
above</span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">> paste in the record statement from
above</span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">>load</span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">>exit</span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;"> </span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">Open Qutil</span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">>create file orig_file2</span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">>exit</span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;"> </span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">Keep a copy of the file created above –
then you won't have to keep creating it - simply copy it when next
required.</span></font></p>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;"> </span></font></p>
<div>
<div style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;" lang="EN-US">
<hr align="center" size="2" width="100%">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;" lang="EN-US">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;" lang="EN-US">
powerh-l-bounces+atla38=<a href="mailto:dsl.pipex.com@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">dsl.pipex.com@lists.sowder.com</a>
[mailto:<a href="mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com</a>] <b><span style="font-weight: bold;">
On Behalf Of </span></b>Joe Boyle<br>
<b><span style="font-weight: bold;">Sent:</span></b> 01 June 2007 10:21<br>
<b><span style="font-weight: bold;">To:</span></b> vamsi krishna<span class="q"><br>
<b><span style="font-weight: bold;">Cc:</span></b> <a href="mailto:powerh-l@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l@lists.sowder.com</a><br></span><div><span class="e" id="q_112e79f5b9fe7b6f_2">
<b><span style="font-weight: bold;">Subject:</span></b> Re: Help-- Deleting from
a SEQUENTIAL FILE</span></div></span></font><span lang="EN-US"></span></p>
</div><div><span class="e" id="q_112e79f5b9fe7b6f_4">
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<div>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">there may be subtle differences between a
sequential file and the data part of a subfile. I would use qtp to reload the
data after first recreating the new empty file using qutil. Also, I
would simply rename the original file in case I needed to restore it
later.</span></font></p>
</div>
<blockquote style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color blue; border-width: medium medium medium 1.5pt; margin: 5pt 0cm 5pt 3.75pt; padding: 0cm 0cm 0cm 4pt;">
<div>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">----- Original Message ----- </span></font></p>
</div>
<div>
<p style="background: rgb(228, 228, 228) none repeat scroll 0% 50%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><b><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; font-weight: bold;">
From:</span></font></b><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> <a href="mailto:vamsi.coe@gmail.com" title="vamsi.coe@gmail.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
vamsi krishna</a>
</span></font></p>
</div>
<div>
<p><b><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; font-weight: bold;">To:</span></font></b><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> <a href="mailto:atla38@dsl.pipex.com" title="atla38@dsl.pipex.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
Joe Boyle</a> </span></font></p>
</div>
<div>
<p><b><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; font-weight: bold;">Cc:</span></font></b><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> <a href="mailto:powerh-l@lists.sowder.com" title="powerh-l@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
powerh-l@lists.sowder.com</a>
</span></font></p>
</div>
<div>
<p><b><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; font-weight: bold;">Sent:</span></font></b><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> Friday, June 01,
2007 7:56 AM</span></font></p>
</div>
<div>
<p><b><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; font-weight: bold;">Subject:</span></font></b><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> Re: Help--
Deleting from a SEQUENTIAL FILE</span></font></p>
</div>
<div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
</div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Hello All,<br>
<br>
Thanks for the feedback :-)<br>
Well, its PowerHouse 8.43.D on UNIX platform.<br>
<i><span style="font-style: italic;"> </span></i>I am thinking of method
advised by <font color="#790619"><span style="color: rgb(121, 6, 25);"><span>John Pickering.<br>
<br>
</span></span></font></span></font></p>
<ol start="1" type="1">
<li><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Access the sequential file </span></font></li>
<li><font face="Times New Roman" size="3"><span style="font-size: 12pt;">copy the required records in a subfile ( add the
select condition here)</span></font></li>
<li><font face="Times New Roman" size="3"><span style="font-size: 12pt;">delete the original sequential file </span></font></li>
<li><font face="Times New Roman" size="3"><span style="font-size: 12pt;">copy from subfile to create a new sequential
file </span></font></li>
</ol>
<p style="margin-bottom: 12pt;"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">I can't change the
file organization of original file as that would mean re-compiling a massive
dictionary for a small enhancement.<br>
Please confirm whether i can go ahead with this kind of change.<br>
<br>
Thanks and Regards,<br>
Vamsi Krishna</span></font></p>
<div>
<p><span><font face="Times New Roman" size="3"><span style="font-size: 12pt;">On 6/1/07, <b><span style="font-weight: bold;">Joe Boyle</span></b>
<<a href="mailto:atla38@dsl.pipex.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">atla38@dsl.pipex.com</a>> wrote:</span></font></span>
</p>
<div vlink="purple" link="blue">
<div>
<p><font color="blue" face="Arial" size="3"><span style="font-size: 12pt; font-family: Arial; color: blue;">You cannot usually delete rows from a sequential file but you
can often rewrite them, for that reason they often have a deleted field which
is used to unselect records when the file is rebuilt – which file system
and OS platform are you on ?</span></font></p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
<div>
<div style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;" lang="EN-US">
<hr align="center" size="2" width="100%">
</span></font></div>
<p><b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma; font-weight: bold;" lang="EN-US">From:</span></font></b><font face="Tahoma" size="2"><span style="font-size: 10pt; font-family: Tahoma;" lang="EN-US">
powerh-l-bounces+atla38=<a href="mailto:dsl.pipex.com@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">dsl.pipex.com@lists.sowder.com</a> [mailto:<a href="mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com</a>] <b><span style="font-weight: bold;">On Behalf Of </span></b>vamsi krishna<br>
<span><b><span style="font-weight: bold;">Sent:</span></b> 31 May 2007
16:27</span><br>
<span><b><span style="font-weight: bold;">To:</span></b> <a href="mailto:powerh-l@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l@lists.sowder.com</a></span><br>
<span><b><span style="font-weight: bold;">Subject:</span></b> Help--
Deleting from a SEQUENTIAL FILE</span></span></font></p>
</div>
<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;"> </span></font></p>
<div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Hello
All,</span></font></p>
</div>
<div><span>
<div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
</div>
<div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">I was
just trying to delete from a sequential file and I got this following
error:</span></font></p>
</div>
<div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">*E*
OUTPUT action is incompatible with file organization SEQUENTIAL.<br>
</span></font></p>
</div>
<div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">If I need
to do so, is there any way to do that..</span></font></p>
</div>
<div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
</div>
<div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Please
let me know the what can be done to delete records from a SEQUENTIAL
FILE.</span></font></p>
</div>
<div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> </span></font></p>
</div>
<div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Thanks
and Regards,</span></font></p>
</div>
<div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Vamsi<br clear="all">
<br>
-- <br>
"Nothing is impossible as impossible itself says i m possible" </span></font></p>
</div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"><br clear="all">
<br>
-- <br>
"Nothing is impossible as impossible itself says i m possible" </span></font></p>
</span></div>
</div>
</div>
</div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"><br>
<br clear="all">
<br>
-- <br>
"Nothing is impossible as impossible itself says i m possible" </span></font></p>
<div style="text-align: center;" align="center"><font face="Times New Roman" size="3"><span style="font-size: 12pt;">
<hr align="center" size="2" width="100%">
</span></font></div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">-- <br>
= = = = = = = = = = = = = = = = = = = = = = = = = = = =<br>
Mailing list: <a href="mailto:powerh-l@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l@lists.sowder.com</a><br>
Subscribe: &quot;subscribe&quot; in message body to
<a href="mailto:powerh-l-request@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l-request@lists.sowder.com</a><br>
Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in
message body to <a href="mailto:powerh-l-request@lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">powerh-l-request@lists.sowder.com</a><br>
<a href="http://lists.sowder.com/mailman/listinfo/powerh-l" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://lists.sowder.com/mailman/listinfo/powerh-l</a><br>
This list is closed, thus to post to the list you must be a subscriber.<br>
Add 'site:<a href="http://lists.sowder.com" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">lists.sowder.com</a> powerh-l' to your search terms to search the list
archive at Google.</span></font></p>
</blockquote>
</span></div></div>
</div>
</blockquote></div><br><br clear="all"><br>-- <br>"Nothing is impossible as impossible itself says i m possible"