Help-- Deleting from a SEQUENTIAL FILE

[Guy Werry]

Be careful doing this!
This may be platform dependent, but I'm pretty sure that in Unix a sequential file is physically different from a direct file.
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.
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.
 
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.
 
Guy L. Werry
Senior Systems Analyst
Hudson Bay Mining & Smelting Co., Limited. 

-----Original Message-----
From: powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com [mailto:powerh-l-bounces+guy.werry=hbms.ca at lists.sowder.com]On Behalf Of Hurworth, Erik
Sent: Thursday, May 31, 2007 10:57 AM
To: vamsi krishna; powerh-l at lists.sowder.com
Subject: RE: Help-- Deleting from a SEQUENTIAL FILE


Hi Vamsi,
 
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
the version of PowerHouse you are using allows this. Then use this file declaration to delete the records,

Regards 

Erik A. Hurworth



  _____  

From: powerh-l-bounces+erik.hurworth=cognos.com at lists.sowder.com [mailto:powerh-l-bounces+erik.hurworth=cognos.com at lists.sowder.com] On Behalf Of vamsi krishna
Sent: 31 May 2007 16:27
To: powerh-l at lists.sowder.com
Subject: Help-- Deleting from a SEQUENTIAL FILE




Hello All,
 
I was just trying to delete from a sequential file and I got this following error:
*E* OUTPUT action is incompatible with file organization SEQUENTIAL.
 
If I need to do so, is there any way to do that..
 
Please let me know the what can be done to delete records from a  SEQUENTIAL FILE.
 
Thanks and Regards,
Vamsi

-- 
"Nothing is impossible as impossible itself says i m possible" 


-- 
"Nothing is impossible as impossible itself says i m possible" 
 
       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. 


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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070531/ce9cdfbd/attachment-0001.html