Troy, You _can_ use 64-bit files on 32-bit Windows 2003 Server, NTFS is quite happy with files over 2GB.
I would describe multi-level files as an 'old' way of getting some of the same functionality as you get with UV Distributed files. You could have STOCK,HIST1 and STOCK,HIST2 ... if you wanted to keep more History. Or maybe STOCK,HIST06 STOCK,HIST07 STOCK,HIST08 for 2006, 2007 & 2008? If you want to use Distributed Files, I think you'll have to lose the multi-level concept. Regards Mike -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Buss, Troy (Logitek Systems) Sent: Tuesday, 14 October 2008 10:36 a.m. To: [email protected] Subject: [U2] [UV] using distributed files with multi level data files possible? Running Universe 10.0.17 on Windows Server 2003 32bit: Can I create a distributed file for a data file that is part of shared dictionary (ie a multi-level data file)? I can't seem to get the syntax right. Here is the scenario. We have a large stock file with current transactions called STOCK that contains about 2 years of transactions and a growing history file with data copied from STOCK,STOCK to STOCK,HIST on a semi-annual basis. We've had to limit this STOCK,HIST file to about 2 years because of the 2GB limit. We are on Windows Server 2003 32bit and cannot create 64bit files, so I'd like to implement a distributed file for this STOCK,HIST and copy in about 4 to 6gb of older (offline) history data into it. Since the records are pure numeric and sequential I was going to create 10 part files and use the partitioning algorithm as INTERNAL "@ID[LEN(@ID),1]+1". What would be my steps and syntax to do this? >From my research, I have been successful at using DEFINE.DF, etc to do this at the primary datafile level like STOCK (aka STOCK,STOCK) but not when I reference a sub data file off of STOCK (like STOCK,HIST) it blows up. Sample below using similar names: Creating the files work fine: :CREATE-FILE TEST.STOCK 1,1 101,1 :CREATE-FILE TEST.STOCK.HIST.PART1 1,1 101,1 Then using the following to associate TEST.STOCK,HIST with the first part file fails: :DEFINE.DF DATA TEST.STOCK,HIST ADDING TEST.STOCK.HIST.PART1 1 INTERNAL "@ID[LEN(@ID),1]+1" I get: DICT and PDICT are not legal keywords with multilevel DATA files. File not created. If I leave out 'DATA' above, no difference. All of the existing applications software and dictionaries reference STOCK (comma) HIST or I'd just rewrite this as a new data file like STOCK (DOT) HIST and be done. This may end up being the work-around if this just won't work. Either multi level data files are not supported or I'm not getting the syntax correct. Any help would be much appreciated! -Troy ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
