I have thought of simply archiving at month end, but I would rather it did it "live" - less chance of problems potentially appearing at EOM.
--------------------------------- Simon Verona Director Dealer Management Services Ltd Sent from my iPhone On 28 Sep 2009, at 17:05, Charlie Noah <[email protected]> wrote: > > Simon, > > Do you run an EOM process? If so, have it create and verify the part > file creation for the next month, and send an email if the verify > fails. > If you don't do an EOM, set it up in whatever substitutes for cron in > Windows, or have someone do it manually each month (least preferable). > This way your normal transaction processing routines won't have to > spend > any time checking for the existence of the file. Make sure to set up a > "catch-all" part file so that you won't lose any data if for some > reason > the real part file doesn't get created. > > Regards, > Charlie Noah > Inland Truck Parts > > Simon Verona wrote, On 09/28/2009 09:59 AM: >> I have a transaction file which can get very large, and has the >> potential to blow through the 2gb file size limit (we are using jBase >> 3.4.10 on Windows platforms). >> >> The item id of the records in the file is [Internal Date].nn eg >> 15274.1 15274.2 etc. >> >> As such, I thought that I could split the file up into a distributed >> file with part files in the format TRANSACTION.FILE.MM.YY where >> MM is >> the calendar month, and YY is the calendar year and Part file >> numbers >> of MMYY >> >> Writing the algorithm for filing and retrieving the records is pretty >> straightforward (just an OCONV(INT(ID),'DM') and OCONV(INT >> (ID),'D2Y'). >> However, for each new month as the first record is written I will >> need >> to pre-create the data file before trying to retrieve any data from >> it. >> >> I'm therefore considering the best way of verifying whether the >> "Part" >> file actually exists and creating it if not. >> >> Is there a quicker way to do this than actually opening the file in >> the >> algorithm ? >> >> Is there a better way to achieve the same results? >> >> Thanks in advance. >> Simon >> >> > > > --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
