Good thought.. I'll try it out
Simon --------------------------------- Simon Verona Director Dealer Management Services Ltd Sent from my iPhone On 28 Sep 2009, at 17:17, "David McGehee" <[email protected]> wrote: > > Consider using only the month not both month and year. The part files > can be precreated with no problem. If after a few years, the parts > approach 2Gb, then either create an archive and prune the older > records > into it or otherwise preserve/dispose of them. > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf > Of Simon Verona > Sent: Monday, September 28, 2009 10:00 AM > To: [email protected] > Subject: Dynamically created Distributed files > > 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 > > -- > =========================== > Simon Verona > Director > Dealer Management Services Ltd > > email: [email protected] > tel: 0845 686 2300 > > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
