Help-- Deleting from a SEQUENTIAL FILE

[Joe Boyle]

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.
  ----- Original Message ----- 
  From: vamsi krishna 
  To: Joe Boyle 
  Cc: powerh-l at lists.sowder.com 
  Sent: Friday, June 01, 2007 7:56 AM
  Subject: Re: Help-- Deleting from a SEQUENTIAL FILE


  Hello All,

  Thanks for the feedback :-)
  Well, its PowerHouse  8.43.D on UNIX platform.
   I am thinking of method advised by John Pickering.

    1.. Access the sequential file
    2.. copy the required records in a subfile ( add the select condition here)

    3.. delete the original sequential file
    4.. copy from subfile to create a  new  sequential file 
  I  can't change the file organization of original file as that would mean re-compiling a massive dictionary for a small enhancement.
  Please confirm whether i can go ahead with this kind of change.

  Thanks and Regards,
  Vamsi Krishna


  On 6/1/07, Joe Boyle <atla38 at dsl.pipex.com> wrote:
    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 ?




----------------------------------------------------------------------------

    From: powerh-l-bounces+atla38=dsl.pipex.com at lists.sowder.com [mailto:powerh-l-bounces+atla38=dsl.pipex.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" 




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


------------------------------------------------------------------------------


  -- 
  = = = = = = = = = = = = = = = = = = = = = = = = = = = =
  Mailing list: powerh-l at lists.sowder.com
  Subscribe: &quot;subscribe&quot; in message body to powerh-l-request at lists.sowder.com
  Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to powerh-l-request at lists.sowder.com
  http://lists.sowder.com/mailman/listinfo/powerh-l
  This list is closed, thus to post to the list you must be a subscriber.
  Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070601/ae9edc2f/attachment-0001.htm