Help-- Deleting from a SEQUENTIAL FILE

[vamsi krishna]

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