<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="MSHTML 6.00.6000.16441" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff>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.</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=vamsi.coe@gmail.com href="mailto:vamsi.coe@gmail.com">vamsi
krishna</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=atla38@dsl.pipex.com
href="mailto:atla38@dsl.pipex.com">Joe Boyle</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Cc:</B> <A title=powerh-l@lists.sowder.com
href="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, June 01, 2007 7:56 AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: Help-- Deleting from a
SEQUENTIAL FILE</DIV>
<DIV><BR></DIV>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>copy the required records in a subfile ( add the select condition
here)<BR>
<LI>delete the original sequential file
<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="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<DIV lang=EN-GB vlink="purple" link="blue">
<DIV>
<P><FONT face=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial">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=Arial color=blue size=3><SPAN
style="FONT-SIZE: 12pt; COLOR: blue; FONT-FAMILY: Arial"></SPAN></FONT> </P>
<DIV>
<DIV style="TEXT-ALIGN: center" align=center><FONT face="Times New Roman"
size=3><SPAN lang=EN-US style="FONT-SIZE: 12pt">
<HR align=center width="100%" SIZE=2>
</SPAN></FONT></DIV>
<P><B><FONT face=Tahoma size=2><SPAN lang=EN-US
style="FONT-WEIGHT: bold; FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</SPAN></FONT></B><FONT
face=Tahoma size=2><SPAN lang=EN-US
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"> powerh-l-bounces+atla38=<A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:dsl.pipex.com@lists.sowder.com"
target=_blank>dsl.pipex.com@lists.sowder.com</A> [mailto:<A
onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:powerh-l-bounces+atla38=dsl.pipex.com@lists.sowder.com"
target=_blank>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
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">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"
<P>
<HR>
<P></P>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = = = =
=<BR>Mailing list: powerh-l@lists.sowder.com<BR>Subscribe:
&quot;subscribe&quot; in message body to
powerh-l-request@lists.sowder.com<BR>Unsubscribe: &quot;unsubscribe
&lt;password&gt;&quot; in message body to
powerh-l-request@lists.sowder.com<BR>http://lists.sowder.com/mailman/listinfo/powerh-l<BR>This
list is closed, thus to post to the list you must be a subscriber.<BR>Add
'site:lists.sowder.com powerh-l' to your search terms to search the list
archive at Google.</BLOCKQUOTE></BODY></HTML>