<HTML >
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3086" name=GENERATOR></HEAD>
<BODY >
<DIV>
<DIV dir=ltr align=left><SPAN class=703335515-31052007><FONT face=Arial
color=#0000ff size=2>Hi Vamsi,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=703335515-31052007><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=703335515-31052007><FONT face=Arial
color=#0000ff size=2>I am unable to test this but try setting up a new
definition to point to the file but declare the file type as DIRECT
if</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=703335515-31052007><FONT face=Arial
color=#0000ff size=2>the version of PowerHouse you are using allows this. Then
use this file declaration to delete the records,</FONT></SPAN></DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-gb><FONT face=Arial size=2>Regards</FONT></SPAN> </P>
<P><SPAN lang=en-us><FONT face=Arial color=#000000 size=2>Erik A.
Hurworth<BR></FONT></SPAN></P><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B>
powerh-l-bounces+erik.hurworth=cognos.com@lists.sowder.com
[mailto:powerh-l-bounces+erik.hurworth=cognos.com@lists.sowder.com] <B>On Behalf
Of </B>vamsi krishna<BR><B>Sent:</B> 31 May 2007 16:27<BR><B>To:</B>
powerh-l@lists.sowder.com<BR><B>Subject:</B> Help-- Deleting from a SEQUENTIAL
FILE<BR></FONT><BR></DIV>
<DIV></DIV><SPAN class=gmail_quote><BR></SPAN>
<DIV>Hello All,</DIV>
<DIV> </DIV>
<DIV>I was just trying to delete from a sequential file and I got this
following error:</DIV>
<DIV>*E* OUTPUT action is incompatible with file organization
SEQUENTIAL.<BR> </DIV>
<DIV>If I need to do so, is there any way to do that..</DIV>
<DIV> </DIV>
<DIV>Please let me know the what can be done to delete records from a
SEQUENTIAL FILE.</DIV>
<DIV> </DIV>
<DIV>Thanks and Regards,</DIV>
<DIV>Vamsi<BR clear=all><BR>-- <BR>"Nothing is impossible as impossible itself
says i m possible" </DIV><BR clear=all><BR>-- <BR>"Nothing is impossible as
impossible itself says i m possible" </DIV>
<DIV> </DIV>
<DIV> This message may contain privileged and/or confidential information. If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so. Thank you. </DIV></BODY></HTML>