<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.3086" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=508211216-31052007><FONT face=Arial color=#0000ff size=2>Be
careful doing this!</FONT></SPAN></DIV>
<DIV><SPAN class=508211216-31052007><FONT face=Arial color=#0000ff size=2>This
may be platform dependent, but I'm pretty sure that in Unix a sequential file is
<STRONG>physically different</STRONG> from a direct file.</FONT></SPAN></DIV>
<DIV><SPAN class=508211216-31052007><FONT face=Arial color=#0000ff size=2>A
sequential file is 'byte-stream' - there are no physical record
separators. When you read you just read 'x' bytes at a time and move
logically within the file.</FONT></SPAN></DIV>
<DIV><SPAN class=508211216-31052007><FONT face=Arial color=#0000ff size=2>A
direct file generally has a carriage return at the end of each record, the
records are physically separated; direct files may be variable length, with the
carriage return signalling the end of a record.</FONT></SPAN></DIV>
<DIV><SPAN class=508211216-31052007><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=508211216-31052007><FONT face=Arial color=#0000ff size=2>What
you could probably do (I'm doing this from memory and have not done it for a
long time) is use the 'dd' utility to re-organize the file: change it from
sequential to direct format, THEN use Erik's method.</FONT></SPAN></DIV>
<DIV><SPAN class=508211216-31052007><FONT size=2><FONT face=Arial
color=#0000ff></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=508211216-31052007><FONT size=2><FONT face=Arial
color=#0000ff>Guy L. Werry<BR>Senior Systems Analyst<BR>Hudson Bay Mining &
Smelting Co., Limited.</FONT> </FONT></DIV></SPAN>
<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>
powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com
[mailto:powerh-l-bounces+guy.werry=hbms.ca@lists.sowder.com]<B>On Behalf Of
</B>Hurworth, Erik<BR><B>Sent:</B> Thursday, May 31, 2007 10:57
AM<BR><B>To:</B> vamsi krishna; powerh-l@lists.sowder.com<BR><B>Subject:</B>
RE: Help-- Deleting from a SEQUENTIAL FILE<BR><BR></FONT></DIV>
<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></BLOCKQUOTE>The information in this e-mail and any attachments is confidential and may be subject to legal professional privilege. It is intended solely for the attention and use of the named addressee(s). If you are not the intended recipient, or person responsible for delivering this information to the intended recipient, please notify the sender immediately. Unless you are the intended recipient or his/her representative you are not authorised to, and must not, read, copy, distribute, use or retain this message or any part of it.
</BODY></HTML>