Help-- Deleting from a SEQUENTIAL FILE

[Joe Boyle]

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 <mailto:vamsi.coe at gmail.com>  

To: Joe Boyle <mailto: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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20070601/9bc63d4e/attachment.html