Help-- Deleting from a SEQUENTIAL FILE

[vamsi krishna]

Thanks a TON Joe. :-D

Vamsi


On 6/1/07, Joe Boyle <atla38 at dsl.pipex.com> wrote:
>
>  If you plan on 'deleting' regularly, it might be worth adding a second
> file and record structure to your dictionary based on the original file. You
> could then use qtp to transfer required records to file2, and then simply
> rename file2 to the original filename. You do not need to recompile the
> whole dictionary to add a file and record structure; details below.
>
>
>
> Open Qshow
>
> >set lang pdl
>
> >gen file orig_file
>
> >e
>
>
>
> Edit the qshogen file created from above, changing orig_file references to
> orig_file2 ( the elements are already in the dictionary so you won't need
> them )
>
>
>
> Open Pdl
>
> > paste in the file statement from above
>
> > paste in the record statement from above
>
> >load
>
> >exit
>
>
>
> Open Qutil
>
> >create file orig_file2
>
> >exit
>
>
>
> Keep a copy of the file created above – then you won't have to keep
> creating it - simply copy it when next required.
>
>
>  ------------------------------
>
> *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 *Joe
> Boyle
> *Sent:* 01 June 2007 10:21
> *To:* vamsi krishna
> *Cc:* powerh-l at lists.sowder.com
> *Subject:* Re: Help-- Deleting from a SEQUENTIAL FILE
>
>
>
> 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 <vamsi.coe at gmail.com>
>
> *To:* Joe Boyle <atla38 at dsl.pipex.com>
>
> *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.
>
>


-- 
"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/20070604/0d032624/attachment.html