Focal Point
Flushing Hold file's data

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7391087212

February 12, 2007, 06:26 AM
Code Digger
Flushing Hold file's data
Is there any command to flush/clear a focus hold file.
I am using a particular hold file many a time for some looping logic.
When I am reading second time from that hold its reading the old data also.
February 12, 2007, 06:39 AM
FrankDutch
If you create a hold file it is normally overwritten unless you put the command (append, so the flush/clear is done automatically.

when you read from a hold file by the command
-READ you should add the command NOCLOSE to let the programm the second time read the next line.

I hope this helps

Frank




Frank

prod: WF 7.6.10 platform Windows,
databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7
test: WF 7.6.10 on the same platform and databases,IE7

February 12, 2007, 09:57 AM
BlueZone
CD, this topic has been discussed here before. Here are a couple of those threads, but you would find more if you did a "Search the Technical Documentation Libarary" from the link above.

https://forums.informationbuilders.com/eve/forums/a/tpc/...1057331/m/7411064202
https://forums.informationbuilders.com/eve/forums/a/tpc/...1057331/m/6971028551

Hope that helps to get you started.
Goooooooooooooood day !!
Sandeep Mamidenna.


-------------------------------------------------------------------------------------------------
Blue Cross & Blue Shield of MS
WF.76-10 on (WS2003 + WebSphere) / EDA on z/OS + DB2 + MS-SQL
MRE, BID, Dev. Studio, Self-Service apps & a dash of fun !! Music
February 12, 2007, 09:58 AM
susannah
very good idea, CD
-REPEAT end.loop 10 TIMES
TABLE FILE CAR
..do something
ON TABLE HOLD
END
-RUN
..do something with that hold file
..now you're done so clear it
CMD ERASE HOLD.*
or DOS ERASE HOLD.*
-end.loop
If some part of your loop fails for some reason, you don't want to be re-processing the same hold file.
but CD you still need to edit your profile to tell us what system you're on




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID