[U2] U2 Training - 1H2008 - Australia & New Zealand
IBM has posted the schedule for first half 2008 training on their web sites for Australia & New Zealand. Last year they did not schedule any U2 training; we made appropriate noises at U2 University in Sydney, and now they've scheduled some. Please, some of you, enrol and make it a success. Note, also, that the Administrator classes are NOT scheduled but will be run if enough (four?) request it. UV90AU - UniVerse Fundamentals Sydney 17-20 Mar 2008, Melbourne 02-06 Jun 2008 UD100AU - UniData Fundamentals Sydney 24-28 May 2008, Melbourne 09-12 Jun 2008 UD100NZ - UniData Fundamentals Auckland 21-25 Apr 2008, Wellington 30 Jun - 03 Jul 2008 U2125 - UniData and UniVerse Database Programming Sydney 31 Mar - 03 Apr 2008, Auckland 28 Apr - 01 May 2008, Melbourne 16-20 Jun 2008, Wellington 07-10 Jul 2008 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Deep and long indentations vs multiple exit points - AD NAUSEUM
Since AD takes the accusative case, it's AD NAUSEAM (I don't really want to argue JMP instructions, which is all there is once you get to the compiled code.) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] .net versus VS
I did a follow-up to Gerry's answer on my blog: remove.pleaseNebula-RnD.com /blog/tech/2007/12/crossbrowserdotnet1.html > From: gerry > Nothing runs 'ON' FireFox. > > From: Bill > Will .Net code run on FireFox? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Pick programmer needed contract or full time
If you don't find your "on-site" I can do all the support you need from my office as I have done for the City of Houston for over six years. Have a blessed day, Patrick 919 567-0042 Carol Carmen wrote: We are a mega church located in Tulsa, OK. We are looking for an on-site Pick/UniVerse programmer for a full time position or contract work. Please send resume to [EMAIL PROTECTED] Or, mail resume to: Church on the Move Attn: Carol Carmen 1003 N 129th E Ave Tulsa, OK 74116 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Need to partially hide a file
Look seriously at both Ray's SQL solution and Mark's Data-At-Rest-Encryption. The latter is a UV 10.2 enhancement. -Original Message- From: Ray Wurlod Sent: Thursday, November 29, 2007 1:59 PM If you were to convert the file into an SQL table, then you can grant SELECT privilege (or not) at the individual column level. And/or you can restrict the table entirely to a single SQL user (at least in UniVerse) and only access it via programs compiled with the AUTHORIZATION statement. My $0.02 worth. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Deep and long indentations vs multiple exit points - AD functionality not bugs
Clif, I appreciated your viewpoint and was glad to see it. I didn't take it that you were singling anyone out, but since I've not sallied forth into the fray, perhaps I was immune from such feelings. Thanks for your contributions as well as those who've made other constructive offerings! Sincerely Best Regards, Richard Lewis --- On Mon 12/03, Clifton Oliver < [EMAIL PROTECTED] > wrote: Apologies to any and all for offense given.--Regards,Clif ___ No banners. No pop-ups. No kidding. Make My Way your home on the Web - http://www.myway.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation
Aha! I see where you're going. I'll give that a go! Thanks to all for your input! Perry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony Youngman Sent: Monday, December 03, 2007 8:21 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation A second, far bigger adjustment (which will account for a lot of the underestimate), is to divide by 1600, not 2000 or 2048. A split factor of 80 means that your groups will, at maximum, be 80% full. 80% of 2048 is 1640 (near enough). That will give a second-cut (and rather more accurate) estimate 25% larger than the original "divide by 2048" estimate. And 20-25% (depending which way you're going) is quite a big error. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid Sent: 03 December 2007 10:08 To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation A first adjustment is to allow for the overhead that page and record headers and other administrative information uses e.g. divide by 2000 instead of 2048. Each page has d page header, each record as a record header there will be an 'end of item'-character at the end of each key and each record ( if not there will be pointers and/or lengths instead ) and there will be some unused characters where no record fits at the end of the page. I don't know the sizes of these things but I'd feel lucky if I had a file where they totalled less than 48bytes per page. -- mats Perry Taylor skrev: > That's approximately what I did when calculating how big I needed this > file, although I used the average record size rather than the total > bytes since the majority of the records are less than 75 bytes with a > few large records. > > Let's assume for argument's sake that I took the sum of the record and > ID sizes and divided by 2048. The problem is I came up way short. If I > query that data from the existing table here's what I get... > > >> SUM CLM.RUN.STRIP.PROVDATA EVAL "LEN(@ID)" AS "ID BYTES" FMT "10R" >> > EVAL "LEN(@RECORD)" AS "REC BYTES" FMT "10R" EVAL "LEN(@ID) + > LEN(@RECORD)" AS "BYTES" FMT "10R" > > CLM.RUN.STRIP.PROVDATA ID BYTES.. REC BYTES. BYTES. > > >== == == > TOTALS5035139 17035963 22071102 > > > 719305 records summed. > > >> DIVD 22071102 2048 >> > Decimal 10776 remainder 1854 > > See this is where I get into trouble. 10776 is still a far cry from > 19618. What is also confusing is why ANALYZE.FILE reports such larger > totals for the record and ID bytes than I get from my query. See the > confusion? > > Thanks. > > Perry > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald > Sent: Thursday, November 29, 2007 12:19 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation > > This is a very rough cut, but if you divide data+id bytes by 2048, > you'll be > in the ballpark. > > so... > > 46Mb + 5Mb = 51Mb/2048=24902 > > I'd pad that a bit (you don't need tightly packed files), possibly as > much as > 50% & maybe go up to a MIN MOD of a prime near 36K. I'm assuming that > disk > space isn't a constraint as we're dealing with a few Mb. > > If you don't know what the data size will be, my admittedly subjective > formula > would be to divide the anticipated number of records by 10 & go with a > number > in that range, assuming no other issues (like the # of id's is going to > be 40 > Billion & it's a 32-bit file). In this case, you'd end up with an > oversized > file (MIN MOD around 72K) , but you can always adjust that if it's a > problem. > I don't mind oversizing nearly as much as undersizing.> Subject: > [U2][UV] > Dynamic File MINIMUM.MODULUS Calculation> Date: Thu, 29 Nov 2007 > 10:13:53 > -0500> From: [EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org> > >> I >> > continue to struggle with accurate calculation of MINIMUM.MODULUS> > values for > dynamic files. Static hashed files do not seem to be such a> challenge > for me. > >>> Here is an example where, once again, I was woefully shy...> > >>> > ---> > File > name .. CLM.RUN.STRIP.PROVDATA> Pathname > ... > CLM.RUN.STRIP.PROVDATA> File type .. DYNAMIC> Hashing > Algorithm .. GENERAL> No. of groups (modulus) 19618 current > ( > minimum 7867, 0 empty,> 8869 overflowed, 4612 badly> )> Number of > records > .. 719305> Large record size .. 75 bytes> Number of > large > records 6614> Group size . 2048 bytes> Load factors > ... 80% (split), 50% (merge) and 80% (actual)> Total size > . 69978112 bytes> Total size of record data .. 46331730 > bytes> > Total size of record IDs ... 51
[U2] [Position Wanted] Programmer available
Programmer with over 20 years experience in Pick/Universe programming available for short or long term projects either remotely or onsite in the New York City area. Please contact [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Deep and long indentations vs multiple exit points - AD functionality not bugs
Sorry, Stuart. I should have completely trimmed the reply quote on my post so it didn't look (as it apparently did) that I was singling out you as the main target of my comments (after the part about guard clauses). It was more of a sociological musing as to how many times over the years we've seen these threads on style, constructs, etc. go on and on. I wonder how many people really change the way they label, or indent, or whatever based on them. I frequently hear comments in my travels from people to the effect of "how do people have time to write all that stuff during the work week; I don't have time to even read them!" I wasn't trying to censor you or anyone else, and I probably should keep such musings to myself. At the very least, I should have worded it better. Apologies to any and all for offense given. -- Regards, Clif On Dec 3, 2007, at 2:14 AM, Boydell, Stuart wrote: Apologies to anyone who thinks I was making unacceptable 'noise' - you're welcome to filter my posts. In my defence - I have always tried to put a guard clause in my posts asserting it's MY opinion - not - thou shalt. If I haven't - it's just a bug in my assertion. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Windows Printer Seperator Pages
I just got some Konica copiers and they don't seem to completely be compatable with my HP separator pages. I am looking for the control codes to run Port Norm, Port Compressed and landscape anything you have would be greatly appreciated. Thanks, Tony Caufield IS Manager Harbor Wholesale Grocery Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Windows Unidata Server
If the MFT is undersized does it affect the Unidata files sitting on it? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Haydon Bishop is out of the office.
I will be out of the office starting 03/12/2007 and will not return until 05/12/2007. I will respond to your message when I return. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] .net versus VS
Gerry > > VS.NET 2008, right click on page.aspx -> "Browse with ..." > Doh! Thanks - I must be getting old. It's there in the Solution window, but not if you right click on the page in the designer. That just goes straight into the default browser (Firefox, naturally). Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] .net versus VS
VS.NET 2008, right click on page.aspx -> "Browse with ..." -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: December 3, 2007 11:02 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] .net versus VS > Will .Net code run on FireFox? ASP.NET pages render largely the same on Firefox, but there are layout differences: in particular Firefox doesn't like applying widths to span elements, so ASP.NET labels won't pad out the same. Panels (implemented as fieldset) look different. Also some of the auto-position of elements using css are slightly different on IE6, IE7 and Firefox. So it's always worth testing your results on all three. Incidentally that seems to be something I can't do directly from the VS2008 IDE, unless I'm overlooking an option. There's no 'Run this page in...'. Silverlight works the same on both: but you want to wait for the full 1.1 release. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Brutzman, Bill > Sent: 03 December 2007 15:24 > To: 'u2-users@listserver.u2ug.org' > Subject: RE: [U2] .net versus VS > > I am glad to learn of Floss, Mono, Cygwin... I need to be on > some new spam lists. > > Will .Net code run on FireFox? > > --Bill > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] .net versus VS
Hmmm - strange question perhaps - Firefox is a browser and so will display most any html/xhtml pages and run some clever things like javascript,flash etc. It dows not care what produces those pages i.e. php/asp/asp.net/u2/notepad ... ASP.NET will dynamically produce web pages in html/xhtml that may or may not incorporate javascript and flash etc. So firefox does not run .net but will run the output of most asp.net web server applications. The actual .net code runs in the .net framework which runs on windows/mono etc not in a browser ! Clear ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: 03 December 2007 15:24 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] .net versus VS I am glad to learn of Floss, Mono, Cygwin... I need to be on some new spam lists. Will .Net code run on FireFox? --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] mv.net versus Web DE
Charles_Shaffer wrote: > Over the years MS has limited interoperability, corrupted standards, and generally tried to create the impression that Windows is the only OS in the world. And people buy it. Even IT people. Quite true in many ways, the only company in the world to beat Micrsoft on this would be Apple who have perpetuated myth after myth of their being the first and the best and the most conformant ... I am quite sure in 20 years time they will claim to have invented the mobile phone. As a fan of linux I still use client tools on my Windows PC (Unidebugger, wintegrate, VS etc) to develop, but of course deploy most of my applications on *nix. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] .net versus VS
> Will .Net code run on FireFox? ASP.NET pages render largely the same on Firefox, but there are layout differences: in particular Firefox doesn't like applying widths to span elements, so ASP.NET labels won't pad out the same. Panels (implemented as fieldset) look different. Also some of the auto-position of elements using css are slightly different on IE6, IE7 and Firefox. So it's always worth testing your results on all three. Incidentally that seems to be something I can't do directly from the VS2008 IDE, unless I'm overlooking an option. There's no 'Run this page in...'. Silverlight works the same on both: but you want to wait for the full 1.1 release. Brian > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of > Brutzman, Bill > Sent: 03 December 2007 15:24 > To: 'u2-users@listserver.u2ug.org' > Subject: RE: [U2] .net versus VS > > I am glad to learn of Floss, Mono, Cygwin... I need to be on > some new spam lists. > > Will .Net code run on FireFox? > > --Bill > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] .net versus VS
Nothing runs 'ON' FireFox. ASP.NET code running on a web server generates HTML that is requested and interpreted by client browsers. Its up to the programmer to ensure that the generated HTML renders properly on any particular client browser just the same as it is with any other type HTML service. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: December 3, 2007 10:24 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] .net versus VS I am glad to learn of Floss, Mono, Cygwin... I need to be on some new spam lists. Will .Net code run on FireFox? --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] .net versus VS
I am glad to learn of Floss, Mono, Cygwin... I need to be on some new spam lists. Will .Net code run on FireFox? --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] mv.net versus Web DE
Charles_Shaffer wrote: > Uniobjects is not strictly limited to Visual Studio. Tony G. wrote >I chuckle on the statement that Windows is 'very limiting'. Gosh, I guess >that explains why we can't get any software for these stupid things. Tony, I was talking about the limits of Uniobjects, not Windows, but now that it comes up. Windows is limiting BY DESIGN. Over the years MS has limited interoperability, corrupted standards, and generally tried to create the impression that Windows is the only OS in the world. And people buy it. Even IT people. Now I shouldn't complain. Supporting Windows has been a goldmine for IT people. Windows provides an endless stream of problems for people to pay us to fix. Bill Gates is a business genius. He took DOS and created an industry. That doesn't change the fact that Windows is a bloated version of DOS which was not networkable, not multiprocessing, and not re-entrant as opposed to most other OSes which were designed to be networked and multiprocessing from the bottom up. VS is a great IDE. I wish it would run on other platforms. And Windows is my second favorite OS. Everything else ties for first. Gotta go. I need to finish up this Windows app. Charles Shaffer Senior Analyst NTN-Bower Corporation --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: U2 SOAP Server
Thanks! Now I can at least start exploring. I've been making fair progress getting a small ruby script to talk to it, with an eye towards eventually hooking it up with some rails work a fellow programmer has been working on. -- Dave Walker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Hona, David S Sent: Monday, December 03, 2007 1:08 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: U2 SOAP Server Here's what I've managed to work out so far (it would be nice of IBM U2 Support) could confirm/deny... A) To invoke the SOAPServer without starting up U2WSD (on Wintel): X:\ibm\tools\RunSOAPServer.bat (See the "-classpath" for the plugs-in that are required to run the U2 UniSOAP server) B) If you wish to "migrate" to another server or environment, update the details in: (mostly self-explanatory): X:\ibm\tools\U2SOAP.config C) Log files created (if debug mode is on): SOAP server optional debug file: X:\ibm\u2soap\\.log UniObject sessions trace log file: X:\ibm\tools\uoj_trace.log D) Key directories with JAR files required: X:\ibm\tools\plugins\com.ibm.u2.unisoap_1.0.0\ X:\IBM\Tools\plugins\com.ibm.u2.uoj_1.0.0\ Regards, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of LeRoy Dreyfuss Sent: Saturday, December 01, 2007 11:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] RE: U2 SOAP Server Hey folks, Just thought I'd take a second to reply back to the recent posts... The SOAP Server included with U2WSD gets installed when you install the tool. There isn't an option (during install) to install the SOAP Server by itself or elsewhere. That doesn't mean you can't relocate the SOAP Server somewhere else when you are ready to deploy. If you have no GUI desktop (Gnome/KDE/etc.) on your Linux server, then it will be hard to install U2WSD on that platform (and as such, gain access to the SOAP Server). That wouldn't be an issue for Windows server users since Windows has a GUI desktop. At the end of the day, the SOAP Server is just a simple Jetty server enhanced to communicated only with U2 servers enabled for it. It is really light-weight. You don't have to fire up U2WSD to start/stop it, but I don't believe IBM includes that tidbit of info in there documentation. Regards, LeRoy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation
A second, far bigger adjustment (which will account for a lot of the underestimate), is to divide by 1600, not 2000 or 2048. A split factor of 80 means that your groups will, at maximum, be 80% full. 80% of 2048 is 1640 (near enough). That will give a second-cut (and rather more accurate) estimate 25% larger than the original "divide by 2048" estimate. And 20-25% (depending which way you're going) is quite a big error. Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mats Carlid Sent: 03 December 2007 10:08 To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation A first adjustment is to allow for the overhead that page and record headers and other administrative information uses e.g. divide by 2000 instead of 2048. Each page has d page header, each record as a record header there will be an 'end of item'-character at the end of each key and each record ( if not there will be pointers and/or lengths instead ) and there will be some unused characters where no record fits at the end of the page. I don't know the sizes of these things but I'd feel lucky if I had a file where they totalled less than 48bytes per page. -- mats Perry Taylor skrev: > That's approximately what I did when calculating how big I needed this > file, although I used the average record size rather than the total > bytes since the majority of the records are less than 75 bytes with a > few large records. > > Let's assume for argument's sake that I took the sum of the record and > ID sizes and divided by 2048. The problem is I came up way short. If I > query that data from the existing table here's what I get... > > >> SUM CLM.RUN.STRIP.PROVDATA EVAL "LEN(@ID)" AS "ID BYTES" FMT "10R" >> > EVAL "LEN(@RECORD)" AS "REC BYTES" FMT "10R" EVAL "LEN(@ID) + > LEN(@RECORD)" AS "BYTES" FMT "10R" > > CLM.RUN.STRIP.PROVDATA ID BYTES.. REC BYTES. BYTES. > > >== == == > TOTALS5035139 17035963 22071102 > > > 719305 records summed. > > >> DIVD 22071102 2048 >> > Decimal 10776 remainder 1854 > > See this is where I get into trouble. 10776 is still a far cry from > 19618. What is also confusing is why ANALYZE.FILE reports such larger > totals for the record and ID bytes than I get from my query. See the > confusion? > > Thanks. > > Perry > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald > Sent: Thursday, November 29, 2007 12:19 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation > > This is a very rough cut, but if you divide data+id bytes by 2048, > you'll be > in the ballpark. > > so... > > 46Mb + 5Mb = 51Mb/2048=24902 > > I'd pad that a bit (you don't need tightly packed files), possibly as > much as > 50% & maybe go up to a MIN MOD of a prime near 36K. I'm assuming that > disk > space isn't a constraint as we're dealing with a few Mb. > > If you don't know what the data size will be, my admittedly subjective > formula > would be to divide the anticipated number of records by 10 & go with a > number > in that range, assuming no other issues (like the # of id's is going to > be 40 > Billion & it's a 32-bit file). In this case, you'd end up with an > oversized > file (MIN MOD around 72K) , but you can always adjust that if it's a > problem. > I don't mind oversizing nearly as much as undersizing.> Subject: > [U2][UV] > Dynamic File MINIMUM.MODULUS Calculation> Date: Thu, 29 Nov 2007 > 10:13:53 > -0500> From: [EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org> > >> I >> > continue to struggle with accurate calculation of MINIMUM.MODULUS> > values for > dynamic files. Static hashed files do not seem to be such a> challenge > for me. > >>> Here is an example where, once again, I was woefully shy...> > >>> > ---> > File > name .. CLM.RUN.STRIP.PROVDATA> Pathname > ... > CLM.RUN.STRIP.PROVDATA> File type .. DYNAMIC> Hashing > Algorithm .. GENERAL> No. of groups (modulus) 19618 current > ( > minimum 7867, 0 empty,> 8869 overflowed, 4612 badly> )> Number of > records > .. 719305> Large record size .. 75 bytes> Number of > large > records 6614> Group size . 2048 bytes> Load factors > ... 80% (split), 50% (merge) and 80% (actual)> Total size > . 69978112 bytes> Total size of record data .. 46331730 > bytes> > Total size of record IDs ... 5114218 bytes> Unused space ... > 18528068 bytes> Total space for records 69974016 bytes> > File name > .. CLM.RUN.STRIP.PROVDATA> Number per group ( total of > 19618 > groups> )> Average Minimum Maximum StdDev> Group buffers .. > 1.74 1 > 15 1.19> Records 36.67 10 68 12.
Re: [U2] Deep and long indentations vs multiple exit points - AD NAUSEUM
Couple of thoughts. 1. Yes, the 'style' debates tend to be self-serving. 2. I do end up with either feeling good about my techniques or finding out another good technique. 3. By expressing my preferred techniques, others may may experience #2 above. By keeping an open mind, each of us knows how these techniques, both new to us and our own favorites, can weave into our own environments. Many participants seem to manage large shops with 100's of users so every cycle counts. But I'm sure others manage 10-20 users shops. Some have 4GL-style systems with implied rules and requirements. Others may have home-grown systems from the Jurrasic Pick era. Without comparisons, we all function in a vacuum. My 1 cent Mark Johnson - Original Message - From: "Clifton Oliver" <[EMAIL PROTECTED]> To: Sent: Sunday, December 02, 2007 10:55 PM Subject: Re: [U2] Deep and long indentations vs multiple exit points - AD NAUSEUM > Perhaps you might want to expand your search criteria to include "the > last ten years" and examine the use of Guard Clauses. > > Does anyone else on the list find these discussions of "style," "good > practice," etc. to be both out-of-date and an exercise in wasted > bandwidth (not to mention having too much time on one's hands)? > > People being what they are, these discussions always boil down to, > "I'm going to do it my way because I'm right and you are wrong." > > Wouldn't the time be best spent retesting that A/R modification you > plan to push to Production tomorrow night? > > > -- > > Regards, > > Clif > > On Dec 2, 2007, at 5:12 PM, Boydell, Stuart wrote: > > > I'm in complete agreement with the "one way in/out" (OWI-OWO ) > > rule. Out > > of interest, I have searched the net and of the many articles I found > > which cited OWI-OWO, all cited it in the scope of being good > > practice. I > > found one which cites "one way in, multiple|many ways out" with a > > scathing comment. > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] mv.net versus Web DE
partner.microsft.com/webresourcekit My apologies - you actually need an MAP subscription for this - this is relevantly inexpensive tho and certainly much cheaper than VS. + you get lots of other software for free for use within your company. Also as someone else said the express edition for VB and web developer is free. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of phil walker Sent: 03 December 2007 09:02 To: u2-users@listserver.u2ug.org Subject: RE: [U2] mv.net versus Web DE Is there a link for this somewhere? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Monday, 3 December 2007 10:00 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] mv.net versus Web DE If you want visual studio for free then become a Microsoft registered member and pass one of the web development exams - (30 minutes course + 10 minute exam - very very easy) and then join the web development group and you get it + expression studio for free ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Canale, Jr. Sent: 30 November 2007 23:30 To: u2-users@listserver.u2ug.org Subject: RE: [U2] mv.net versus Web DE Tony Gravagno wrote: > If you don't want to pay for Visual Studio [Ad - kind of] There may be another way for people on Long Island to get the brand new Visual Studio 2008 Professional for free. Next week (Dec. 6th), the LI.NET Developers Group will be hosting a meeting and at that meeting Microsoft will be giving away some copies of VS2008 Pro. If you live on Long Island and are interested in attending (you must register for the meeting), please shoot me an email off-list. I also know of a few other .NET developer groups where they will be doing the same thing (NYC, NJ) so you may want to check into that if you belong to any of those groups. [/ad] Best regards, Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] mv.net versus Web DE
You can download a free version of Visual Studio Basic called express. It is a slimmed down version, but should do most of what U2 developers would use. http://www.microsoft.com/express/download/default.aspx Regards David Jordan --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Deep and long indentations vs multiple exit points
That was an over simplified example. The additional IF tests usually occur in situations where you can neither AND them together nor put them in a CASE structure. For example: PROCESS.ID: READ RECORD1 FROM FILE1, ID ELSE RETURN IF RECORD1 NE COND1 THEN RETURN * Some processing to derive NEXT.ID based on RECORD1 * Initialise some variables here READ RECORD2 FROM FILE2, NEXT.ID ELSE RETURN IF RECORD2 NE RECORD1 THEN RETURN * Some processing to derive NEXT.ID based on RECORD1 and RECORD2 * Initialise some more variables here READ RECORD3 FROM FILE3, NEXT.ID ELSE RETURN COND3 = RECORD1 : RECORD2 IF RECORD3 NE COND3 THEN RETURN * We passed the tests lets do the processing using RECORD1, 2 and 3 and the * the iniatialised variables ... RETURN The final processing block would end up indented a minimum 6 levels without the early RETURNs. Granted you can put the final part in a GOSUB but even that GOSUB is still deeply indented. If you restructure this into SUBs (which I dont oppose per se) you end up with six SUBs that become more difficult to comprehend as you go further down. You would have to scroll up and down to find out at what point some variables came into being. - Original Message From: David A Barrett <[EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org Sent: Friday, 30 November, 2007 4:03:16 PM Subject: Re: [U2] Deep and long indentations vs multiple exit points Curious, I would have done: LOOP WHILE READNEXT ID READ RECORD FROM FILE,ID THEN IF ((RECORD EQ COND1) AND (RECORD EQ COND2) AND (RECORD EQ COND3)) THEN RECORD = 'PROCESSED' END END REPEAT If I was worried about the IF statement getting too long, then I'd do this: LOOP WHILE READNEXT ID READ RECORD FROM FILE,ID THEN ANS1 = (RECORD EQ COND1) ANS2 = (RECORD EQ COND2) ANS3 = (RECORD EQ COND3) IF (ANS1 AND ANS2 AND ANS3) THEN RECORD = 'PROCESSED' END END REPEAT While I'm on it, I probably wouldn't do the looping like that either, I'd do this: MORE = @TRUE LOOP READNEXT ID ELSE MORE = @FALSE WHILE (MORE = @TRUE) DO READ RECORD FROM FILE,ID THEN IF ((RECORD EQ COND1) AND (RECORD EQ COND2) AND (RECORD EQ COND3)) THEN RECORD = 'PROCESSED' END END REPEAT Not that I actually think there's anything wrong with the original way it was done... >I use CONTINUE all the time when processing >records that must meet multiple conditions in a loop. This way my code doesnt >look like 'flying geese'. I will write: > >LOOP WHILE READNEXT ID > READ RECORD >FROM FILE, ID ELSE CONTINUE > IF RECORD NE COND1 THEN CONTINUE > IF >RECORD NE COND2 THEN CONTINUE > IF RECORD NE COND3 THEN >CONTINUE > RECORD = 'PROCESSED' > WRITE RECORD TO FILE, ID >REPEAT >instead of: > >LOOP WHILE READNEXT ID > READ RECORD FROM FILE,ID THEN > IF >RECORD EQ COND1 THEN >IF RECORD EQ COND2 THEN >IF RECORD EQ COND3 THEN > RECORD = 'PROCESSED' >WRITE RECORD TO FILE, ID >END > END > END > END >REPEAT Dave Barrett, Lawyers' Professional Indemnity Company --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Sent from Yahoo! - the World's favourite mail http://uk.mail.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation
A first adjustment is to allow for the overhead that page and record headers and other administrative information uses e.g. divide by 2000 instead of 2048. Each page has d page header, each record as a record header there will be an 'end of item'-character at the end of each key and each record ( if not there will be pointers and/or lengths instead ) and there will be some unused characters where no record fits at the end of the page. I don't know the sizes of these things but I'd feel lucky if I had a file where they totalled less than 48bytes per page. -- mats Perry Taylor skrev: > That's approximately what I did when calculating how big I needed this > file, although I used the average record size rather than the total > bytes since the majority of the records are less than 75 bytes with a > few large records. > > Let's assume for argument's sake that I took the sum of the record and > ID sizes and divided by 2048. The problem is I came up way short. If I > query that data from the existing table here's what I get... > > >> SUM CLM.RUN.STRIP.PROVDATA EVAL "LEN(@ID)" AS "ID BYTES" FMT "10R" >> > EVAL "LEN(@RECORD)" AS "REC BYTES" FMT "10R" EVAL "LEN(@ID) + > LEN(@RECORD)" AS "BYTES" FMT "10R" > > CLM.RUN.STRIP.PROVDATA ID BYTES.. REC BYTES. BYTES. > > >== == == > TOTALS5035139 17035963 22071102 > > > 719305 records summed. > > >> DIVD 22071102 2048 >> > Decimal 10776 remainder 1854 > > See this is where I get into trouble. 10776 is still a far cry from > 19618. What is also confusing is why ANALYZE.FILE reports such larger > totals for the record and ID bytes than I get from my query. See the > confusion? > > Thanks. > > Perry > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald > Sent: Thursday, November 29, 2007 12:19 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2][UV] Dynamic File MINIMUM.MODULUS Calculation > > This is a very rough cut, but if you divide data+id bytes by 2048, > you'll be > in the ballpark. > > so... > > 46Mb + 5Mb = 51Mb/2048=24902 > > I'd pad that a bit (you don't need tightly packed files), possibly as > much as > 50% & maybe go up to a MIN MOD of a prime near 36K. I'm assuming that > disk > space isn't a constraint as we're dealing with a few Mb. > > If you don't know what the data size will be, my admittedly subjective > formula > would be to divide the anticipated number of records by 10 & go with a > number > in that range, assuming no other issues (like the # of id's is going to > be 40 > Billion & it's a 32-bit file). In this case, you'd end up with an > oversized > file (MIN MOD around 72K) , but you can always adjust that if it's a > problem. > I don't mind oversizing nearly as much as undersizing.> Subject: > [U2][UV] > Dynamic File MINIMUM.MODULUS Calculation> Date: Thu, 29 Nov 2007 > 10:13:53 > -0500> From: [EMAIL PROTECTED]> To: u2-users@listserver.u2ug.org> > >> I >> > continue to struggle with accurate calculation of MINIMUM.MODULUS> > values for > dynamic files. Static hashed files do not seem to be such a> challenge > for me. > >>> Here is an example where, once again, I was woefully shy...> > >>> > ---> > File > name .. CLM.RUN.STRIP.PROVDATA> Pathname > ... > CLM.RUN.STRIP.PROVDATA> File type .. DYNAMIC> Hashing > Algorithm .. GENERAL> No. of groups (modulus) 19618 current > ( > minimum 7867, 0 empty,> 8869 overflowed, 4612 badly> )> Number of > records > .. 719305> Large record size .. 75 bytes> Number of > large > records 6614> Group size . 2048 bytes> Load factors > ... 80% (split), 50% (merge) and 80% (actual)> Total size > . 69978112 bytes> Total size of record data .. 46331730 > bytes> > Total size of record IDs ... 5114218 bytes> Unused space ... > 18528068 bytes> Total space for records 69974016 bytes> > File name > .. CLM.RUN.STRIP.PROVDATA> Number per group ( total of > 19618 > groups> )> Average Minimum Maximum StdDev> Group buffers .. > 1.74 1 > 15 1.19> Records 36.67 10 68 12.15> Large records > .. 0.34 1 4 0.58> Data bytes . 2361.69 350 > 30359 > 2270.12> Record ID bytes 260.69 70 491 86.71> Unused bytes > ... 944.44 24 2068 650.69> Total bytes > 3566.83 > 2048 30720 0.00> > > Number per record ( total of 719305> records )> > Average > Minimum Maximum StdDev> Data bytes . 64.41 34 28700 > 353.25> > Record ID bytes 7.11 2 20 1.14> Total bytes > > 71.52 36 28720 354.13> > ---> > >> I >> > cannot seem to figure ou
RE: [U2] mv.net versus Web DE
Is there a link for this somewhere? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: Monday, 3 December 2007 10:00 p.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] mv.net versus Web DE If you want visual studio for free then become a Microsoft registered member and pass one of the web development exams - (30 minutes course + 10 minute exam - very very easy) and then join the web development group and you get it + expression studio for free ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Canale, Jr. Sent: 30 November 2007 23:30 To: u2-users@listserver.u2ug.org Subject: RE: [U2] mv.net versus Web DE Tony Gravagno wrote: > If you don't want to pay for Visual Studio [Ad - kind of] There may be another way for people on Long Island to get the brand new Visual Studio 2008 Professional for free. Next week (Dec. 6th), the LI.NET Developers Group will be hosting a meeting and at that meeting Microsoft will be giving away some copies of VS2008 Pro. If you live on Long Island and are interested in attending (you must register for the meeting), please shoot me an email off-list. I also know of a few other .NET developer groups where they will be doing the same thing (NYC, NJ) so you may want to check into that if you belong to any of those groups. [/ad] Best regards, Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] NEW ADO.NET ?
No -I would love to, but it is someway down the list of things I would love to do. If anyone has - a little story of how they get on would be very welcome ... Symeon -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Horacio Pellegrino Sent: 01 December 2007 01:03 To: u2-users@listserver.u2ug.org Subject: [U2] NEW ADO.NET ? Has anyone tried out the new ADO.NET provider for .NET IBM ? Horacio Pellegrino --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] mv.net versus Web DE
If you want visual studio for free then become a Microsoft registered member and pass one of the web development exams - (30 minutes course + 10 minute exam - very very easy) and then join the web development group and you get it + expression studio for free ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Canale, Jr. Sent: 30 November 2007 23:30 To: u2-users@listserver.u2ug.org Subject: RE: [U2] mv.net versus Web DE Tony Gravagno wrote: > If you don't want to pay for Visual Studio [Ad - kind of] There may be another way for people on Long Island to get the brand new Visual Studio 2008 Professional for free. Next week (Dec. 6th), the LI.NET Developers Group will be hosting a meeting and at that meeting Microsoft will be giving away some copies of VS2008 Pro. If you live on Long Island and are interested in attending (you must register for the meeting), please shoot me an email off-list. I also know of a few other .NET developer groups where they will be doing the same thing (NYC, NJ) so you may want to check into that if you belong to any of those groups. [/ad] Best regards, Jim --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Deep and long indentations vs multiple exit points - AD functionality not bugs
One of the reasons I'm subscribed to the list because I'm interested to see how other people do it their way. I've learnt some valuable stuff here. I think contribution to this topic is valid under the banner of technical discussion. But hey if I'm out of line or if the topic is not applicable here then I'm sure the moderator will advise. Apologies to anyone who thinks I was making unacceptable 'noise' - you're welcome to filter my posts. In my defence - I have always tried to put a guard clause in my posts asserting it's MY opinion - not - thou shalt. If I haven't - it's just a bug in my assertion. Peas be with you, Stuart >-Original Message- >Perhaps you might want to expand your search criteria to include "the >last ten years" and examine the use of Guard Clauses. > >Does anyone else on the list find these discussions of "style," "good >practice," etc. to be both out-of-date and an exercise in wasted >bandwidth (not to mention having too much time on one's hands)? > >People being what they are, these discussions always boil down to, >"I'm going to do it my way because I'm right and you are wrong." ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/