Hello All,<br><br>Thanks for the feedback :-)<br>Well, its PowerHouse 8.43.D on UNIX platform.<br><span style="font-style: italic;"> </span>I am thinking of method advised by <span id="_user_John.Pickering@norbord.com" style="color: rgb(121, 6, 25);">
John Pickering.<br></span><ol><li>Access the sequential file</li><li>copy the required records in a subfile ( add the select condition here)<br></li><li>delete the original sequential file</li><li>copy from subfile to create a new sequential file
</li></ol>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<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 link="blue" vlink="purple" lang="EN-GB">
<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 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>vamsi krishna<span class="q"><br>
<b><span style="font-weight: bold;">Sent:</span></b> 31 May 2007 16:27<br>
<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><br>
<b><span style="font-weight: bold;">Subject:</span></b> Help-- Deleting from a
SEQUENTIAL FILE</span></span></font><span lang="EN-US"></span></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 class="e" id="q_112e36d38f3b5231_3">
<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>
</blockquote></div><br><br clear="all"><br>-- <br>"Nothing is impossible as impossible itself says i m possible"