Hi Jerry, Actually, I know about multi-data files too... I used to use them on Pick R83, to simulate what Universe later implemented much more cleanly as distributed files.
Part numbers dont have to be sequential and dont have to start at 1 ( I didnt know that until I was told quite recently...), but cannot be zero. You could if you wanted to use the whole year as a part number if you wished, so you could have part numbers 2000, 2001, 2002 etc. However, how often are you going to be select just the year 2000 data? It would probably make sense to have a part file for each of the more recent years, and put the rest in a bucket. That way you retain all the advantages of using a distributed file, but minimise the disadvantages.... cheers, asvin "Jerry Banker" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 17/05/2006 15:24 Mail Size: 4382 Please respond to u2-users@listserver.u2ug.org To <u2-users@listserver.u2ug.org> cc Subject [U2] UV - Distributed files Entity Investment Banking Europe - IBEU Since you seem to know a little about distributed (as opposed to multi-data files), I have a question. What do you do with year 2000? I've recently gotten into distributed files and was wondering how others treat year 0 records. Can there be a part number 0? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, May 17, 2006 5:40 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Multiple Data Files I suspect that the Ron is talking about distributed files...... <a whole lot snipped> ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ************************************************************ HSBC Bank plc may be solicited in the course of its placement efforts for a new issue, by investment clients of the firm for whom the Bank as a firm already provides other services. It may equally decide to allocate to its own proprietary book or with an associate of HSBC Group. This represents a potential conflict of interest. HSBC Bank plc has internal arrangements designed to ensure that the firm would give unbiased and full advice to the corporate finance client about the valuation and pricing of the offering as well as internal systems, controls and procedures to identify and manage conflicts of interest. HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ, United Kingdom Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority. ************************************************************ ----------------------------------------- This transmission has been issued by a member of the HSBC Group "HSBC" for the information of the addressee only and should not be reproduced and/or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/