Re: [U2] mvToolbox--digression about why anyone would want telnet-based tools
Long live telnetwe use a full screen editor for Universe, written in house of course, being used by about 80 developers as I type. Les Sherlock Hewkin Senior Project Manager Finance Systems, I.T. Department T 01604 592289, M 07917 856195 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Sent: 20 February 2012 13:41 To: U2 Users List Subject: Re: [U2] mvToolbox--digression about why anyone would want telnet-based tools --- On Sat, 18/2/12, Symeon Breen syme...@gmail.com wrote: I seriously believe most MV people are not programming in ED on telnet (or ssh) and that they are using some form of GUI editor. With respect, I disagree. I work alongside dozens of UniVerse developers and I am in a very small minority who use a GUI based editor. The vast majority use our own custom editor, which runs on a ubiquitous 'green-screen' terminal emulator. Even those like myself who favour editing in a GUI still do all other tasks through command line. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ViaDuct problem
Hi, in the UK it used to be ANJEC that supported ViaDuct, there used to be a nice man called Dick Chatter who knew it inside out, don't know if he's still there or if they still support it but it could be worth an Email. There web site is www.anjec.co.uk. How do I know this? I worked there for a short time... Cheers Les Sherlock Hewkin Senior Project Manager Finance HR Systems, I.T. Department T 01604 592289, M 07917 856195 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: 28 December 2010 19:47 To: U2 Users List Subject: Re: [U2] ViaDuct problem Tony, thanks for your insights. Thanks to others too. My end users are criminal justice folks, so indeed a pretty focused audience. Based on that and several other considerations, I'm going to take a hard look at AccuTerm. Thanks- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, December 28, 2010 10:10 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] ViaDuct problem It's sort of weird to see AccuTerm being investigated like it's a newcomer to be compared to SecureCRT. I hope this review will be helpful, by someone who has used them all. Back in the late 80's to early 90's I was a ViaDuct fan. Around 1994 I was introduced to wIntegrate and found it more capable. Around 1995 I was introduced to AccuTerm and I found a permanent home. AccuTerm is quite simply (IMHO) the best terminal emulator in the MV industry. It has a ton of features that every MV developer can appreciate. Just get it and start using it and you'll see what I mean. There is a helpful user forum, a lot of people who know it very well, excellent product support with rapid code changes if required, and you can get AccuTerm GUI training. No matter what you do, you're going to have to get away from ViaDuct, and if you go to anything else there is going to be a lot of conversion effort. This is the price that's paid for building so heavily into a specific product. For better or worse you'd do the same thing with AccuTerm but if you're going to get in deep with any product, this is a reasonable one. While I recommend AccuTerm GUI for a Pick developer who doesn't like to use mainstream tools, I personally don't think it's right business approach for a diverse end-user base. It's thick-client only and connects via Telnet or SSH. That is a fine solution for focused audiences. If you have any interest in an extranet or internet audience where a browser is used, then you may want to invest your time in mainstream tools. Personally I use AccuTerm all the time to get into all MV environments while I'm building browser GUI - these things are not in conflict. AccuTerm does have AccuTerm for Internet Explorer which is a plugin to allow browser users to access your system, but when people say they want a browser UI this isn't what they have in mind. Try it for yourself. I should also mention that the AnzioWin terminal emulator from Rasmussen Software (anzio.com) seems to be a more apples to apples competitor for SecureCRT. I wish I could take all the mainstream features of AnzioWin and mash them up with the MV-specific features of AccuTerm. I actually use both of these products, having used SecureCRT, Putty, and other mainstream options in the past. If you go to PickWiki you'll see other emulators documented, including Winnix which deserves a fair evaluation: http://www.pickwiki.com/cgi-bin/wiki.pl?TerminalEmulators HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET worldwide and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno From: Harold.Oaks I've always considered AccuTerm the 'other' main player in the MV terminal emulator market, and thought about going to them but conversion of the programs to use their forms would be a lot of workwheras the code to run Viaduct forms is embedding subroutine calls in the Basic code. That is, they are quite different. Do others have an opinion of AccuTerm versus SecureCRT? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received
Re: [U2] AUTO: Haydon Bishop is out of the office. (returning16/04/2010)
WHAT? He was at Liverpool and I missed him Damm and blast...to have met the legendary Haydon Bishop...oh wellanother one of those things to do before I'm 50 that seems to have slipped by me Les Sherlock Hewkin Project Manager, Group Financial Systems, I.T. Department T 01604 592289, M 07917 856195 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 18 April 2010 10:10 To: U2 Users List Subject: Re: [U2] AUTO: Haydon Bishop is out of the office. (returning16/04/2010) Sorry Karl, but Haydon is a real person, I saw him at U2U in Liverpool last year. I actually thought about asking him if he let everybody know then too, but I never talked to him. At that time I was out of the office too, but I didn't think it was important enough to let everybody in the group know. Obviously he just needs another email address that doesn't send out out-of-office replies automatically but doesn't seem to get the message. Nudge, nudge, you know what I mean... Mecki Karl Pearson wrote: I'm reminded of the famous Captain Tuttle of M.A.S.H. created by Hawkeye Pierce to provide money for Sister Teresa's orphanage. When the heat was on to find and give him an award, Hawkeye announced to everyone that Captain Tuttle had jumped from a helicopter without a parachute, perishing in the process. So my point? Maybe Hayden Bishop isn't a real person. Perhaps someone at Adserve has made him up to provide money for a deserving charity and the Out Of Office autoreplies are part of the ploy... I'm just saying. KLP On Fri, April 16, 2010 1:15 pm, Tony Gravagno wrote: Life wouldn't be the same without a few of these notices from Haydon per year. I have a collection of them going back a decade now. I live vicariously through his exploits, imagining what it would be like to actually ever get out of the office. I dream of a day when I too can broadcast an announcement to public forums that I have something else to do beyond the confines and concerns of their troubled little lives... Rock on Haydon! Maybe we need a Where's Haydon Bishop? Book... or perhaps we should form a Find Haydon Bishop group on Facebook I'm beginning to think Hayden Bishop doesn't actually have an office... He's never in it from all appearances. Haydon Bishop I am out of the office until 16/04/2010. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Karl Pearson ka...@ourldsfamily.com Owner/Administrator of the sites at http://ourldsfamily.com --- To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- Democracy is two wolves and a lamb voting on what to have for lunch. Liberty is a well-armed lamb contesting the vote. --Benjamin Franklin --- Children seldom misquote you. In fact, they usually repeat word for word what you shouldn't have said. --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML ___ U2-Users mailing
Re: [U2] SELECTs on FILEs
Hi, a good trick to speed selects like this up is to add an index to the IDtry it and see what happens to your selects Cheers Les Sherlock Hewkin Project Manager, Group Financial Systems, I.T. Department T 01604 592289, M 07917 856195 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Whitehorn Sent: 14 December 2009 00:33 To: 'U2 Users List' Subject: Re: [U2] SELECTs on FILEs Not sure about UD, but on UV this would result in a filescan: SELECT CUSTOMER WITH @ID = AAA] EXPLAIN Optimizing query block 0 Tuple restriction: F0 MATCHES ''AAA'...' Driver source: CUSTOMER Access method: file scan UniVerse/SQL: Press any key to continue or 'Q' to quit 0 record(s) selected to SELECT list #0. HTH, Regards, Brian. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Monday, 14 December 2009 11:15 AM To: U2 Users List Subject: [U2] SELECTs on FILEs Hi all, Just a quick question on SELECTs for UD. I was under the impression that performing a wildcard SELECT with @ID would only result the key section of a FILE been read. Eg, SELECT MYFILE WITH @ID = prefix] Is this incorrect? Does it actually result in the entire FILE being read into memory to complete this SELECT? Regards, Dan ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1ySixwy6Eo/3i2V58ugRT0g7JgXdX3Hyi/ 8.65 3 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Microdata Conversion
Hi, we did Reality to Universe years ago. The reality flavour supports PQN and 10 item dicts, and most of the nice reality features. Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Ryehill House Ryehill Close, Lodge Way Industrial Estate, Northampton. NN5 7UA T 01604 592289 M 07917 856195 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of MAJ Programming Sent: 03 November 2009 15:10 To: u2-users@listserver.u2ug.org Subject: [U2] Microdata Conversion To All: The day is finally approaching. One of my Microdata clients is now wanting to switch to a contemporary platform. Because of being a Microdata, I have a fork in the road: 1) Do I pursue a system that can run in Microdata Flavor, ie Unidata or 2) do I endeavour on the path of either programatically or manually changing the true-PQN procs to more traditional PQ procs to end up on a D3 system. Also, I recall one of my other clients having switched from MCD to UD before me and there must have been a dictionary converter to go from the 10 line items to the 7 line items. That converter put the original 10 line dict (attributed) on line 10 of the new dict item, replacing @am with @vm's. I would like to gather opinions from anyone who has done such a conversion as well as from VAR's that could facilitate either the specific sale and/or the conversion. You may contact me directly at m.john...@jaydeetrucking.com Thanks Mark Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Rocket Software + U2
It was a Europe webcast. Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Ryehill House Ryehill Close, Lodge Way Industrial Estate, Northampton. NN5 7UA T 01604 592289 M 07917 856195 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 30 September 2009 13:43 To: U2 Users List Subject: Re: [U2] Rocket Software + U2 Link did not work. John Israel Senior Programmer/Analyst Dayton Superior Corporation 721 Richard St. Miamisburg, OH 45342 937-866-0711 x44380 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of BraDav Sent: Tuesday, September 29, 2009 8:34 PM To: U2 Users List Subject: [U2] Rocket Software + U2 Webinar today with Rocket Software. Very postitive outlook for U2. Looks like their the right-size player to help grow the U2 market space For more information, please visit http://www.rocketsoftware.com/u2. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Software Test
Hi, we used an automated tester called Testpro a few years ago. You can set it up to run through your system using data in a file as input or you can load the script with the data. It works by recording what you do and capturing the screen output. It works..BUT it takes longer to maintain the scripts then do the changes. The overhead proved to much, we had about 30 developers at the time. We produce test plans for everything we do. It is the standard of the test plan and the quality of the person doing the testing that counts. Good luck Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Ryehill House Ryehill Close, Lodge Way Industrial Estate, Northampton. NN5 7UA T 01604 592289 M 07917 856195 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Lee Leitner Sent: 22 September 2009 23:25 To: U2 Users List Subject: Re: [U2] Software Test Bill: One strategy that improves testing results is to correctly define what a successful test is. A successful test is one that *finds* errors in the code. If no errors are found, then either there aren't any (and that's highly unlikely,) or the tests aren't good enough to trigger the problems. Ideally, you get a hold of someone who knows the application very well, and has a demonic streak. Have that person follow the strategy Ken Hall suggested in the earlier post. If they are immediately successful (i.e. finding errors,) track the rate of error discovery. When the rate falls below, say one per day, you might be at a cutoff point. Get a second opinion from another destructive expert if you can, particularly if the first fails (i.e. finds no errors.) Basically, nothing beats an application expert bent on breaking the software for finding bugs the fastest. What your boss is proposing to do is to kill several hundred bacteria by boiling the ocean. Managing test case coverage for a typical application is a huge task. And when you'll get a positive ROI is unclear: At what point will the test system have enough critical mass (test coverage) to actually demonstrably improve reliability and user satisfaction? Lee On Tue, 22 Sep 2009, Brutzman, Bill wrote: My boss has a new grand scheme for software testing. To test each program revision, he wants scripts to inject sample data into user apps and then another (big) program looks at EVERYTHING that comes out, comparing it to a baseline. To me, the scope of this project is huge, perhaps bigger that our ERP system. So far, I have been unable to talk him out of it. Thus, I am wondering what other people are doing in the way of software test. Virtually all of the source code that we have is in UniBasic. I do not know what jargon to use to describe the test that I do now. On a spreadsheet, I layout the various possiblities and then try each scenario... One-by-one... Fixing bugs as I find them and then starting the batch of tests from scratch. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Lee J. Leitner, Ph.D. leitn...@acm.org http://www.leitner.org/~leitnerl The world can only be grasped by action, not by contemplation. The hand is the cutting edge of the mind. -- Jacob Bronowski V.13.0 --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt;
Re: [U2] U2 being sold!
This news should make the U2 Universities interesting.. I will be in the bar in Liverpool if anyone want to buy me a drink...:-) Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Ryehill House Ryehill Close, Lodge Way Industrial Estate, Northampton. NN5 7UA T 01604 592289 M 07917 856195 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: 16 September 2009 09:35 To: 'U2 Users List' Subject: Re: [U2] U2 being sold! Well what a fine thing to wake up to this morning, I agree with many statements here - the IBM name gave it a lot of credibility, tho I persisted with u2 because of (in my opinion) superior functionality compared to other mv databases. The IBM name was even something i could hide behind when asked what database do you run on, (you can see them expecting oracle or sql server) and i just say IBM, that was fine. Rocket ? never heard of them personally - i will have to do some research, it would be interesting to know their structure in terms of funding to purchase u2, what they see is in it for them, how they managed other acquisitions etc. Good to see the management team are still in place, it gives a continuity, as to will they be more successful in driving through what they want to achieve with the rocket board remains to be seen tho ... Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Strange paragraph IF behaviour
You could try the tried and trusted method of deleting the line and retyping it. This has worked for me before Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Ryehill House Ryehill Close, Lodge Way Industrial Estate, Northampton. NN5 7UA T 01604 592289 M 07917 856195 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ron Hutchings Sent: 16 September 2009 13:46 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Strange paragraph IF behaviour While making wild guesses, does it want double quotes? Date: Wed, 16 Sep 2009 17:29:38 +1000 From: stuart.boyd...@spotless.com.au To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Strange paragraph IF behaviour Hi , Can anyone see anything wrong with the following IF statement - fails on Linux - but works okay on AIX - I can't think of anything more to try? CT VOC ONE.OFF 0001 PA 0002 IF S2,Check = 'BLAH' THEN GO THE.END: 0003 DISPLAY NOT BLAH 0004 THE.END: 0005 DISPLAY THE END It's producing the following results: ONE.OFF Check=BLAH Illegal IF statement. NOT BLAH THE END ONE.OFF Check=jgfjhf Illegal IF statement. NOT BLAH THE END UV RELLEVEL 0001 X 0002 10.2.0 0003 PICK 0004 PICK.FORMAT 0005 10.2.0 ** 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 http://listserver.u2ug.org/mailman/listinfo/u2-users _ Bing brings you health info from trusted sources. http://www.bing.com/search?q=pet+allergyform=MHEINApubl=WLHMTAGcrea=T XT_MHEINA_Health_Health_PetAllergy_1x1 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mixed Case UV Basic Programming Standards.
Does anyone else remember the days when there was only UPPER case on terminals and line printers? Our internal standard says use upper case only, we have twenty year old programs. When switching from an old program to a new one written in wobbly case you tend to miss read the code. We do have someone who is very techy that loves wobbly case, but he is just a bit strange, you know who you are.. Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Ryehill House Ryehill Close, Lodge Way Industrial Estate, Northampton. NN5 7UA T 01604 592289 M 07917 856195 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: 25 June 2009 07:29 To: U2 Users List Subject: Re: [U2] Mixed Case UV Basic Programming Standards. Same Also leading capital letter for SubroutineLabels: No underscores, dots or other extraneous characters. File handle variables are just another variable so follow the camelCase rule but I prefix them with fv: open 'MY.FILE.NAME' to fvMyFileName Cheers, Stuart Boydell From: u2-users-boun...@listserver.u2ug.org on behalf of Larry Hiscock Sent: Thu 25/06/2009 05:05 To: 'U2 Users List' Subject: Re: [U2] Mixed Case UV Basic Programming Standards. I tend to use all lower case for verbs (e.g. read, for, loop, etc), all upper case for constants (i.e. equates -- equ TAB lit char(9)), and camel case for variables (e.g. orderMaster, customerName, etc) One advantage is that I can tell at a glance the difference between a variable and a constant. Just my $.02 Larry Hiscock Western Computer Services ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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 http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
RE: [U2] Employment disaster
RubbishI have worked for the same couple for more then 10 years. In that time I have gone from only knowing Universe to developing systems in VB6, JAVA, dot.net. It's not the developers that become dinosaurs it's the PHB's that think anything new is better then anything that's gone before, and only some one young can understand this new world. Have you spotted that most new ideas are old ideas with lots of big words wrapped round them?? End of rant...boy am I glad it's Friday Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Ryehill House Ryehill Close, Lodge Way Industrial Estate, Northampton. NN5 7UA T 01604 592289 M 07917 856195 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: 23 April 2009 17:42 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Employment disaster That may be right, but smart companies don't hire someone, who got stuck somewhere and only knows that little niche, even if he knows it inside out. Smart employers hire people who bring new ideas, new skills and show the ability to adapt to a new environment quickly. Smart companies train their employees and let them constantly learn new skills (and pay them decent salaries as well). Dinosaurs became extinct, because they couldn't adapt to a rapidly changing world. That's why you call some people 'dinosaurs', not because they are over 55 like myself. If you work for an end user company for more than 5 years, you most likely already lost touch with what is going on in rest of the world. After 20 years with the same outfit (probably also still running the same software as 20 years ago) you become unemployable. And in today's climate, no job is save. jpb-u2ug wrote: I wouldn't say that too loudly there's a lot of potential employers on this list. Most smart companies like to have someone that is willing to stick around long enough to learn their business logic. Jerry Banker -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Wednesday, April 22, 2009 5:54 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV to SAP migration disaster jpb-u2ug wrote: snip Oh and one of these days you are going to be sitting in the same seat talking about the good old days too, and someone is going to be telling you that you're a dinosaur. It's not easy trying to keep up with the technology and if your company isn't using it you tend to gravitate toward what they do use. Jerry Banker Not me Jerry, I usually don't stay long enough for that to happen. If there's nothing new to learn I move on. --- 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/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV Timed INPUT
Hi, the simple answer is no..but there is a way...on UNIX. You can open the device using OPENSEQ and read the input using READBLK, this allows you to use the TIMEOUT command. We have a very clever man that did this and it works without killing the machine. Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Rye Hill House T 01604 592289 M 07917 856195 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 12 March 2009 06:05 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV Timed INPUT Does UV support the WAITING clause on the INPUT statement? In UD you can do: INPUT VAR WAITING 30 ELSE ... END Larry Hiscock Western Computer Services -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Norman, David (Health) Sent: Wednesday, March 11, 2009 8:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV Timed INPUT I'm sure I've seen something about this recently, but I've searched the past 2 years with no luck. I want to do a timed INPUT in UV - if after n seconds the Enter key hasn't been pressed, do something. Anyone got any clever ways of doing this ? Thanks, David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * norman.da...@saambulance.com.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. --- 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/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Requirements for UO.NET connection?
Tony, check to see if there is a VOCLIB in the accounts that don't workWe had this problem with UO and VB6. Cheers Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Rye Hill House T 01604 592289 M 07917 856195 -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Tony G Sent: 13 January 2009 08:55 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Requirements for UO.NET connection? We have a client trying to connect to UV10.2/Win32 via UniObjects.NET. The connection works with some accounts and not with others. The error reported is 39125, The directory does not exist or is not a database account. This is absolutely not correct. The user/password is correct in that it works with some accounts. And using telnet all accounts are accessible via the same user/password. I've been increasingly convinced that the issue is permissions but it's looking like this may not be the case. The UniRPC service is running as System and we've ensured (for better or worse) that the path to the account directories and all subdirectories have full access for System. (This is a test system so it doesn't matter here but I'll be happy to take comments on whether that's a secure solution.) It seems that accounts that have been updated with Update.Account may not be working while those that have not been updated are working. Does any of this ring any bells? Thank you kindly for any insight. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development and training services (See nospamNebula-RnD.com /blog and /forum for latest updates) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Automatic Invoice - PO Matching Software
Forgot to mention we use 1mage for our image storage. Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Rye Hill House T 01604 592289 M 07917 856195 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Dodds Sent: 17 November 2008 19:38 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Automatic Invoice - PO Matching Software You might want to check out 1mage at http://www.1mage.com/. They can do the whole nine yards of paperless office all in UniVerse. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Morawa, Hans Sent: Monday, November 17, 2008 4:28 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Automatic Invoice - PO Matching Software Hi Tony, To put my enquiry into perspective I simply looking for a electronic invoice processing system. The product needs to able to scan invoices regardless how they are delivered, whether they arrive electronically, or by fax or by email or mail, and then automatically match them to purchase orders based on captured information. This product needs to be able to integrate seamlessly with UniVerse. Regardless of how invoices are delivered they all need to be handled in the same way. There are products out there servicing the SAP and Oracle systems of the world and I'm looking for similar functionality without having a massive issue of integrating it with UniVerse. Hence my question to our fellow list members. Cheers, Hans -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: Monday, 17 November 2008 6:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Automatic Invoice - PO Matching Software From: Hans Morawa We are looking for a electronic invoice processing system that matches invoice with purchase orders automatically and works on/or with a UniVerse platform and is available in Australia. ( Really hoping I'm not missing something obvious. *gulp* ) Hans, I don't understand the request. Are you looking for bar coding or image processing so that you can scan documents and have them match up with other documents? Can you give us an example of your business flow so that we can recommend something that fits? Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development and training services --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ This e-mail has been scanned for viruses by MessageLabs. --- This email and any files transmitted with it are confidential to the intended recipient and may be privileged. If you have received this email inadvertently or you are not the intended recipient, you may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender immediately and delete the email from your computer. Whilst we have taken precautions to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from such viruses. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3617 (20081117) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt;
RE: [U2] Automatic Invoice - PO Matching Software
Hi we use an OCR product called Invoices from Readsoft. This looks for the data you want and captures it. It then remembers the format for the supplier. The best thing is it works. We do 1.5 million invoices a year like this. It produces a csv file containing the captured data and details of where to find the image. We capture the line item details as well as the header details. Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Rye Hill House T 01604 592289 M 07917 856195 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 17 November 2008 15:24 To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Subject: RE: [U2] Automatic Invoice - PO Matching Software I am very interested in the data capture part of this. The Universe integration should be doable with UniObjects. PO/Invoice matching will be application specific, but doable. Capturing data from electronic documents should be doable as well, Being able to capture data off of paper documents is something we have done some work on here. The ICR product we use will only capture data on a strictly formatted document. We would be interested in an application that could recognize a variety of formats especially if hand written information is included. I am interested in how others have approached this. Charles Shaffer Senior Analyst NTN-Bower Corporation Morawa, Hans [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/17/2008 04:28 AM Please respond to u2-users To: u2-users@listserver.u2ug.org cc: Subject:RE: [U2] Automatic Invoice - PO Matching Software Hi Tony, To put my enquiry into perspective I simply looking for a electronic invoice processing system. The product needs to able to scan invoices regardless how they are delivered, whether they arrive electronically, or by fax or by email or mail, and then automatically match them to purchase orders based on captured information. This product needs to be able to integrate seamlessly with UniVerse. Regardless of how invoices are delivered they all need to be handled in the same way. There are products out there servicing the SAP and Oracle systems of the world and I'm looking for similar functionality without having a massive issue of integrating it with UniVerse. Hence my question to our fellow list members. Cheers, Hans -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tony G Sent: Monday, 17 November 2008 6:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Automatic Invoice - PO Matching Software From: Hans Morawa We are looking for a electronic invoice processing system that matches invoice with purchase orders automatically and works on/or with a UniVerse platform and is available in Australia. ( Really hoping I'm not missing something obvious. *gulp* ) Hans, I don't understand the request. Are you looking for bar coding or image processing so that you can scan documents and have them match up with other documents? Can you give us an example of your business flow so that we can recommend something that fits? Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development and training services --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ This e-mail has been scanned for viruses by MessageLabs. --- This email and any files transmitted with it are confidential to the intended recipient and may be privileged. If you have received this email inadvertently or you are not the intended recipient, you may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender immediately and delete the email from your computer. Whilst we have taken precautions to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from such viruses. --- 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/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is
RE: [U2] UV objects question
We found the best way is to have all the logic in databasic. Call a subroutine to return the data you want. This can be tested before it is used within VB. Les Sherlock Hewkin Project Manager Group Financial Systems I.T. Department Rye Hill House T 01604 592289 M 07917 856195 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brenda Price Sent: 02 June 2008 22:44 To: u2-users@listserver.u2ug.org Subject: [U2] UV objects question We have a VB process that looks for a record in a set of files PRINT.TODAY (today's file), PRINT.HIST.0508, PRINT.HIST.0408 etc. If the record is not in those files it reads a file called INTERIM.LETTERS. Once the data is found a IE html document is displayed to screen. We keep the date in the record id, so a record written today would first try the PRINT.TODAY file, then the PRINT.HIST.0608 (which does not get created until after 5 pm on the first business day of the month), then the INTERIM.LETTERS file. Each night after 5 pm all data in the file PRINT.TODAY is moved to current month year file. Tonight it would be the PRIINT.HIST.0608 file, normally it would find that the file isn't there and create it. On the first business day of the month, this file has not yet been created and when the process gets to that file something is happening that causes the next file INTERIM.LETTERS to be skipped. When they decided the problem must be that the file is not there yet and had me create the file, the problem went away. Our VB programmers say they have checked every error they can think of and the process is not returning an error that they can recognize. What error would be returned when a program tries via UV Objects to read a file that does not exist? Brenda Price Affiliated Acceptance Corporation Sunrise Beach, MO --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PORT.STSTUS ?
I have written a wrapper around listu, port.status, list.readu vlist. You enter the user ID you want to look at or '?' to do a listu, you can then drill down into one of the user sessions. You then get the results of a port.status with layer.stack, a vlist and a list.readu. After the vlist I extract the correct line of the program to display. Les Sherlock Hewkin Project Manager - Financial Systems 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of doug chanco Sent: 20 December 2007 15:54 To: u2-users@listserver.u2ug.org Subject: Re: [U2] PORT.STSTUS ? thanks! dougc Brian Leach wrote: Doug You're on the right lines - it's a human readable form of the pcode that UniVerse creates when it compiles the program : basically each of the operations that the code will perform. If VLIST can't find the source code (or it's out of step) you'll only see those instructions. But it's still pretty readable. So: Move 0 into the variable LINE.CNT increment LINE.CNT by 1 testing against LINE.NO or jump to address 87C (which will be the point after the NEXT). Brian Hey all, I am trying to replace the PORT.STATUS command with one that would replace [ BUILD.TR.TAG @ 0x178 ] With [BUILD.TR.TAG] 178 FOR LINE.CNT = 1 TO LINE.NO From the VLIST command I assume that the above 0x178 refers to one of the below (the first I assume) I am just curious as to what the two lines following mean 00178: FOR LINE.CNT = 1 TO LINE.NO 00178 00760 : 0F8 move 0 = LINE.CNT 00178 00766 : 098 forincrLINE.CNT LINE.NO 1 0087C: It look kind of like assembly instructions --- 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/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2U London
Brian, I am booked in at this hotel50 quid a night if you book three days in advance. The bar looks really good... BW Master Robert Hotel 366, Great West Road Hounslow Middlesex TW5 0BD GB Tel. 020 8570 6261 Fax. 020 8569 4016 Email [EMAIL PROTECTED] Les Sherlock Hewkin Project Manager - Financial Systems 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Leach Sent: 26 September 2007 14:11 To: u2-users@listserver.u2ug.org Subject: [U2] U2U London Fellow Brits Since we don't get the convenience of a hotel location for the 'London' U2U sessions, does anyone know of a convenient hotel in lurching distance from IBM? Thanks Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Forms printing
We use a big Xerox for this type of thing, but we are printing over 20,000 pages a day. I believe they have smaller printers that can do the same thing. Les Sherlock Hewkin Project Manager - Financial Systems 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Andrea Charles Sent: 28 August 2007 14:35 To: u2-users@listserver.u2ug.org Subject: [U2] Forms printing I was wondering if anyone could suggest a method or product they have used to take reports normally spooled to a line printer with preprinted forms, and print them on alaser printer using a stored form and logo, with the data overlaid. Ideally it should be transparent in that the UniVerse report program does not have to be modified, with only the output sent to a special uv print queue. This needs to run on AIX. Thanks in advance. Andrea Access Manager: This email is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. Dissemination, distribution or copying of this e-mail or the information herein by anyone other than the intended recipient, or an employee or agent responsible for delivering the message to the intended recipient, is prohibited. If you have received this e-mail in error, please immediately notify us by calling the Help Desk at (212) 999-9911 or email us at [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Large-scale scanner / OCR devices and interfaces to UniVerse {Unclassified}
Hi, we to use the Readsoft product. We scan and OCR 1.25 million invoices a year. I don't know if the product is available in NZ but if it is I would recommend it. Les Sherlock Hewkin Project Manager - Financial Systems 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 09 August 2007 11:45 To: u2-users@listserver.u2ug.org Subject: SV: [U2] Large-scale scanner / OCR devices and interfaces to UniVerse {Unclassified} We have a product from Readsoft (www.readsoft.se) that scans invoices and converts these into a predefined file interface. Bjvrn Eklund -Ursprungligt meddelande- Fren: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] HENDERSON MIKE, MR Skickat: den 9 augusti 2007 11:15 Till: u2-users@listserver.u2ug.org Dmne: [U2] Large-scale scanner / OCR devices and interfaces to UniVerse {Unclassified} Folks, We have some process improvement people who are keen to reduce manual key-boarding effort by setting up some large-scale scanner / OCR devices and interfacing them to our UniVerse systems. [I'd rather avoid the paper forms altogether and get XML streams from the document originators, but ...] Anyone got any experience on this kind of gear? I'm clueless about this (Google next, I guess), so ideas on brand names etc would be helpful. Thanks Mike 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 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/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] : Cleaner Case Statement
Coming from somewhere with over 40 developers the first thing that comes to mind is KISS. Why or why would you want to change a very simple easy to read case statement for something more contrived? We train developers to write clean easy to maintain code. When I say we what I mean is we get Martin in for two weeks and then I introduce them to our standards. Must nip upstairs and see how Martin is getting on..bye.. Les Sherlock Hewkin Project Manager - Financial Systems 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brutzman, Bill Sent: 25 July 2007 18:55 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] : Cleaner Case Statement Martin: Thanks very much indeed. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Martin Phillips Sent: Wednesday, July 25, 2007 12:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [u2] : Cleaner Case Statement Hi Bill, Unlike languages such as C, Basic does not allow multiple conditions in the way in which you are looking to do. In terms of run time performance or program size, if it really is just a GOSUB, there whould be little disadvantage in writing the more verbose form of your first example. Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton, NN4 6DB +44-(0)1604-709200 --- 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/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Tony Jones/WA/QBE/Insurance is out of the office.
This did make me gigglethese dates are in UK format Les Sherlock Hewkin Project Manager - Financial Systems 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 05 July 2007 15:26 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Tony Jones/WA/QBE/Insurance is out of the office. Dear Mr. Admin, Please unsubscribe Mr. Jones as looking forward to 5 months of 'out of the office' auto-replies is a highly annoying consideration. Thanks A Heap! KLP quote who=Tony Jones I will be out of the office starting 04/07/2007 and will not return until 09/07/2007. I will respond to your message when I return. - IMPORTANT NOTICE : The information in this email is confidential and may also be privileged. If you are not the intended recipient, any use or dissemination of the information and any disclosure or copying of this email is unauthorised and strictly prohibited. If you have received this email in error, please promptly inform us by reply email or telephone. You should also delete this email and destroy any hard copies produced. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Efficient way of determining if item is inuse
Try using FILELOCK Les Sherlock Hewkin Project Manager - Financial Systems 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 07 June 2007 14:48 To: u2-Users Subject: [U2] [UV] Efficient way of determining if item is inuse Hi all, UV10.1.8 (PICK FORMAT) HPUX 11 I am writing a routine that monitors/imports files from a particular directory. It is important for me to not begin processing a file that is not finished being transferred. What I am trying now is using the fuser command and boy is it dog slow. My code is similar to the following COMMAND = SH C ls lrt indir EXECUTE COMMAND CAPTURING LINES LOOP REMOVE LINE FROM LINES SETTING MORE WHILE MORE DO FNAME = EREPLACE(TRIM(LINE), ,@AM) FNAME = FNAME9 COMMAND = SH C /usr/sbin/fuser indir/ : FNAME : EXECUTE COMMAND CAPTURING RESULTS RESULTS = TRIM(FIELD(RESULTS1,:,2)) INUSE = 0 IF RESULTS # THEN INUSE = 1 END REPEAT Can anyone give me a better (faster) way of making sure that a file is not in use? Thanks in advance, Scott --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Index on @ID
This is done on large files for speed. Try selecting a large file without an index on @ID and then with an index. We do use this method from time to time. Les Sherlock Hewkin Project Manager - Financial Systems 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: 18 May 2007 04:05 To: u2-users@listserver.u2ug.org Subject: [U2] [UV] Index on @ID I have found a file with an index on @ID. I know that it prevents the SAMPLE modifier from working on selects but does anyone know if there are any *good* reasons to have an index on the primary key of a file? Cheers, Stuart Boydell ** 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/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Single Signon for U2 - Identity Management ?
Hi, Are you looking for something like a CITRIX server? With CITRIX you publish to users the applications they are allowed to have. We run Wintegrate, word ... Etc as well as our VB apps from just one place. Les Sherlock Hewkin Project Manager - Financial Systems 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: 19 April 2007 14:49 To: u2-users@listserver.u2ug.org Subject: [U2] Single Signon for U2 - Identity Management ? You know how when you go to bed sometimes and your brain keeps thinking about some problem... I've been thinking this isn't possible in U2 environment, but sometime during the night I resolved to ask the question. Does anyone know of an Identity Management Suite that is U2 aware? This data security issue represents the next frontier for programmers, for solution providers, for network analysts. Who is the frontiersman in the U2/MV space? What we need - single signon and immediate access to those systems, servers, storage that your identity allows. Whatever you don't have rights to, you can't see (an old Novell concept that Microslop still doesn't get). Does anyone know about an IDM solution that interoperates with the major *nix OS's that U2 is ported to? Thanks for any guidance. -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] FILE EXPORT
Do you have a connection to both machines from one PC If so then you can use a terminal emulator like Wintegrate to do a bridge copy or some people call it a peer to peer copy. You have two sessions, one contacted to each machine, you tell your emulator what you want to copy and where you want it to go and set it running. I have done this in the past when working on remote machines. Les Sherlock Hewkin Project Manager - Financial Systems 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anita Panda Sent: 30 March 2007 06:27 To: u2-users@listserver.u2ug.org Subject: [U2] FILE EXPORT I think I was not clear in my question.Now i need to activities to be done. firstly,I have a universe instance on a different Machine located at USA and the other in INDIA. Both of them are stand-alone system.I by no means ,am able to get the data from the UNIVERSE USA to my UNIVERSE INDIA.No what I need is if there is any way of the user in USA can send me the DATA file from USA to INDIA so that the same DATA file could exist in INDIA without again creating the same file and inserting data.Is there any means without floppy,CD and magnetic tape.Please help me in this regard. I have got a huge BP file on a word document.Now its not feasible to type the whole file in the Universe Instance .Is there any way without typing the code to import the whole BP file into the Universe Instance. Thanks, Anita =-=-= Notice: The information contained in this e-mail message and/or attachments to it may contain confidential or privileged information. If you are not the intended recipient, any dissemination, use, review, distribution, printing or copying of the information contained in this e-mail message and/or attachments to it are strictly prohibited. If you have received this communication in error, please notify us by reply e-mail or telephone and immediately and permanently delete the message and any attachments. Thank you --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Error in report generation.
Sorry Brian, but I can read the second one a lot better then the firstbut that's because I am looking for uppercase words, mixed case never looks neat to me. Les Sherlock Hewkin Project Manager - Financial Systems 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 14 March 2007 09:16 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Error in report generation. Mark I WAS WAITING FOR YOU TO RESPOND THERE! SO YOU PREFER CODE THAT SHOUTS BACK AT YOU? THERE ARE GOOD REASONS WHY THE REST OF THE WORLD HAS SWITCHED TO MIXED CASE CODING - IT IS GENUINELY QUICKER TO SCAN AND READ. FORTUNATELY I'VE ONLY BEEN WITH MULTIVALUE FOR TWENTY YEARS SO I WAS ABLE TO DITCH UPPER CASE AS SOON AS UNIVERSE CAME ALONG. PROVING WHAT YOU SAID IN YOUR EMAIL ABOUT NOT FOLLOWING 'BUT THAT'S HOW I WAS TAUGHT' :) I'm not being frivolous (or personal - you obviously *read* these emails!) here. Whether we like it or not, perception is important. Whilst we are trying to position/encourage UniVerse, UniData et al as modern and up to date systems with a strong history, it makes sense to write in ways that match the expectations of new developers who are brought up with current conventions: that includes mixed case coding, legible styles and formats that can be genuinely expressive - like not using field numbers for example (a REAL bugbear of mine). Not using ED helps, of course. Before anyone jumps in - no I don't advocate rewriting existing code in this way. But quickly scan the following two sections and see which one reads faster. If you've been brought up around Delphi, Java, C#, VB, ASP or any of the 'modern' languages I'm willing to bet the first will be considerably quicker. Loop ReadNext Id From MYLIST Else Fin = @True End Until Fin Do ReadU CustomerRec From CUSTOMERS, Id Then GoSub ProcessRecord End Repeat LOOP READNEXT ID FROM MYLIST ELSE FIN = @TRUE END UNTIL FIN DO READU CUSTOMERREC FROM CUSTOMERS, ID THEN GOSUB PROCESS.RECORD END REPEAT Brian --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Why does the IF statement think these values are different?
Hi, Don't know if you have already checked but what is your wide zero set to in uvconfig? It is a hex number. This is used by universe to decide when two number are close enough to be regarded as the same. You can make the difference bigger so that your IF statement works how you would expect. Another solution is to use string maths...look at SADD,SDIV,SMUL SSUB.. Hopes this helps Les Sherlock Hewkin Senior Developer Core Systems - 9951 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: 07 November 2006 22:17 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Why does the IF statement think these values are different? Steve, a couple suggestions: a) It shouldn't make a lick of difference, but enclose the math in parans, just to insure the precedence you desire in the operation.. IF (INTREC+PRNREC) # (INTPAY+PRNPAY) THEN b) if that doesn't change things, try something like: WHATSUP = ABS((INTREC+PRNREC) - (INTPAY+PRNPAY)) IF WHATSUP 0 THEN ERRMSG='ACCT/CALCULATOR MISMATCH' HTH, -Baker HI All, I don't understand why the IF statement THEN clause is executed in the following code: CUSTOMCALC: 447: IF INTREC+PRNREC#INTPAY+PRNPAY THEN :: S CUSTOMCALC: 448: ERRMSG='ACCT/CALCULATOR MISMATCH: ':(INTREC+PRNREC)'R2':'/':(INTPAY+PRNPAY)'R2' :: INTREC/ NUMBER: 24016.35 :: PRNREC/ NUMBER: 978.56 :: INTPAY/ NUMBER: 24016.35 :: PRNPAY/ NUMBER: 978.56 :: ERRMSG/ STRING: T r L=42 `ACCT/CALCULATOR MISMATCH: 24994.91/24994.91' --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe Equivalent of the UnIData DIR command
Or . . . LIST UFD . . . Les Sherlock Hewkin Senior Developer Core Systems - 9951 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Symeon Breen Sent: 08 November 2006 09:45 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe Equivalent of the UnIData DIR command On windows do dos dir on *nix do sh ls -ailor similar. Rgds Symeon. On 07/11/06, Gordon J Glorfield [EMAIL PROTECTED] wrote: Doug, I'm afraid you're out of luck with this one. You'll have to write your own platform aware replacement. Yet another shortcoming of UniVerse as compared to UniData. Sorry, Gordon Gordon J. Glorfield Sr. Applications Developer UnitedHealthcare's Mid-Atlantic Health Plans 301-360-8839 [EMAIL PROTECTED] wrote on 11/07/2006 04:12:10 PM: Similar to my last post, Is there is a command that works the same as the UniData DIR command under UniVerse. I have not been able to find any items in the UniVerse documentation that comes close. I am using the DIR command to determine if a file exists at the OA level. The UnIData DIR command returns the file size in bytes, last modified date, last modified time, and file permissions of a file. Again, I need this to work under Windows and Unix Thanks in Advance Doug Farmer [snip] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- 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/ html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse Internal Date Blackout
You have found the bug We came across this just the other week. It is all to do with Juliann dates. Can't remember the exact detail but will try to find out and post. Cheers Les Sherlock Hewkin Senior Developer Core Systems - 9951 01604 592289 -Original Message- From: Timothy Snyder [mailto:[EMAIL PROTECTED] Sent: 09 June 2006 16:03 To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniVerse Internal Date Blackout [EMAIL PROTECTED] wrote on 06/09/2006 10:16:08 AM: SELECT TESTFILE WITH DATE 14000 Bad data 14000 for conversion D2/. Unconverted data used for selection. 8 record(s) selected to SELECT list #0. CLEARSELECT SELECT TESTFILE WITH DATE 14001 0 record(s) selected to SELECT list #0. SELECT TESTFILE WITH DATE 14365 0 record(s) selected to SELECT list #0. SELECT TESTFILE WITH DATE 14366 Bad data 14366 for conversion D2/. Unconverted data used for selection. 2 record(s) selected to SELECT list #0. So why are you using internal date values against a date-formatted dictionary item?!? If (for whatever bizarre reason) you want to do that, just use a dict item that specifies a straight numeric value. For the record, this is looking at 14001 as year 14, Julian date 001. 14365 is Julian date 365 in year 14. 14366 is day 366 in year 14. Oh, wait, there was no day 366 in year 14 - bad data. Hey, there was no day zero (14000) either! Make it easier on the humans and unambiguous for the computers. Use external dates. Tim Snyder Consulting I/T Specialist , U2 Professional Services North American Lab Services DB2 Information Management, IBM Software Group 717-545-6403 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://www.avg.power.net.uk/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: [U2C] Changes to the List
It was so simple when Cliff ran things. Receive an Email and reply to it. I have more posts about how to post this week then anything else, it is getting very boring, and more complicated. I have had a couple of failed to delivery messages because I an not a valid user on some of the lists. The amount of usefull posts have gone down. I do not like the way things are going. To many committees not enough action and common sense. Think I will be unsubscribing very soon. I wonder who is going to get this reply, I haven't got a clue..! Can't remember if I select Reply or Reply to all, bother. Les Sherlock Hewkin Senior Developer Core Systems - 9951 01604 592289 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 17 March 2006 08:06 To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Subject: [U2C] Changes to the List Thank you all for your views on this subject. The status of the user lists is one of many areas the U2UG are considering as we move forward this year. At our next board meeting we will be constituting a committee to advise on the best options for the list hosting. It may be that the committee finds a better option for the current list, recommends a move to a different list service, or recommends that the lists stay as current. Any recommendations, together with their rationale, will be fed back to the community and any decisions on the future of the lists will ultimately need to rest with the list membership. The committee will be continuing to seek comment from the membership on this issue. So in the meantime: 1. Please move this discussion over to the community list. That's where it belongs now. 2. If anyone wishes to contact the board directly on this matter, please email myself or other board members off-list. Thank You, Brian Leach, U2UG Board u2-community mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://www.avg.power.net.uk/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] RE: [U2C] Changes to the List
Can't get used to using reply to all, if I get an Email I want to reply to that Email. Les Sherlock Hewkin Senior Developer Core Systems - 9951 01604 592289 -Original Message- From: u2ug [mailto:[EMAIL PROTECTED] Sent: 16 March 2006 01:30 To: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: [U2C] Changes to the List All, We've now been living with the change to the lists for nearly a month. I'd like to invite opinions on the change. Are we all happy now that we are used to it? Personally, I think Larry made a good call, but this is a community, so I want me be sure that everyone gets heard. I've still got Jerry and Tom's original issues bookmarked, and I'm especially interested to see if their issues are still problematic. - Charles Barouch, Moderator U2-Users U2-Community RBSolutions SBSolutions Visit http://listserver.u2ug.org, enter your e-mail address, and 'browse all' lists to maintain your access. For non-U2UG e-mail: [EMAIL PROTECTED] u2-community mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://www.avg.power.net.uk/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] GOSUB variable-name?
I have always thought of OOP as a complicated way of producing very simlpe procedual code. Les Sherlock Hewkin Senior Developer Core Systems - 9951 01604 592289 -Original Message- From: Serguei [mailto:[EMAIL PROTECTED] Sent: 16 February 2006 09:58 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] GOSUB variable-name? OOP is a difficult concept to grasp for somebody from procedural programming background. My first use of OOP was a real pain. Once somebody through that stage one cannot understand how one could live without it. Unfortunately you have not get through that stage so you just don't understand what the advantages are. For me it is always much easier to develop a complicated functionality in a flexible way in a language that supports OOP then in U2. - Original Message - From: Jerry Banker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 15, 2006 4:01 PM Subject: Re: [U2] [UV] GOSUB variable-name? True, I am not an OOP. However I have studied it and I did use it when taking courses during the 80's one of which was Pascal. The Windows reference is just an example and not, by any means, the only use of OOP. I just don't think that U2 is missing anything by not having it built in. - Original Message - From: Serguei [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, February 15, 2006 4:03 AM Subject: Re: [U2] [UV] GOSUB variable-name? You not an OOP expect, are you? I have been using OOP since it appeared in Turbo Pascal long before and windows tools appeared and our current Java code calling Universe programs has nothing to do with windows tools (our application has an HTML browser interface). Only those who do not know anything about OOP think that it has anything to do with Windows. - Original Message - From: Jerry Banker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, February 14, 2006 5:45 PM Subject: Re: [U2] [UV] GOSUB variable-name? Not a limitation, you build your own objects. Objects after all are nothing more than subroutines that perform a specific task. You may even say that it is an advantage because you are not tied into doing what someone else has decided how something should work. You create your own. Almost every company I have worked for has had a different way of display and storing information. It's only when using windows tools that they will settle for what they get because they have no choice. - Original Message - From: Serguei [EMAIL PROTECTED] One of those limitation - no OOP. --- 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/ This message has been comprehensively scanned for viruses, please visit http://www.avg.power.net.uk/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Capturing hold file numbers.
PERFORM a setptr with the spool file open and extract the actual file from the result Les Sherlock Hewkin Senior Developer Core Systems - 9951 01604 592289 -Original Message- From: Tom Dodds [mailto:[EMAIL PROTECTED] Sent: 15 February 2006 15:53 To: User group U2 Subject: [U2] Capturing hold file numbers. Hi all: I need a little printer help if someone has experience with this situation. When you use the SETPTR command to direct printed output to a HOLD file and turn on the INFORM option (SETPTR 0,1,AT ASHTEST,HOLD,INFORM) you get the number of the hold file that is generated, displayed to the screen when the printer is turned OFF, CLOSED or the program is terminated. How can you capture this number, the Hold file number, within the executing program? Thanks in advance for you assistance. Tom Dodds [EMAIL PROTECTED] 708-234-9608 Office 630-235-2975 Cell --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://www.avg.power.net.uk/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse Internals course (UK)
Hi, I have sat at Martins feet and boy do they smell...:-) Sorry mate. We use Martin for all our Universe training. Each year we take on graduates and he beats them into shape for us. I have been on this internals course and recommend it to everyone. See you later in the year Martin when we find some more victims for you (hee hee) Les Sherlock Hewkin Senior Developer Core Systems - 9951 01604 592289 -Original Message- From: Stevenson, Charles [mailto:[EMAIL PROTECTED] Sent: 18 January 2006 16:09 To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse Internals course (UK) I've taken the equivalent class in Denver and recommend it. It was the meatiest UV training I have had. Without insulting my instructors in Denver, I would have welcomed the opportunity to sit at Martin Phillips' feet. FWIW, Chuck Stevenson From: Martin Phillips Subject: Re: [U2] UniVerse Internals course (UK) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://www.avg.power.net.uk/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] SOX question (United States only, I believe)
Is that all there is to it We have to do all that now... We also produce diff items of the programs. This details all the changes made. But I do have access to the live machine as well. Les -Original Message- From: Peter Gonzalez [mailto:[EMAIL PROTECTED] Sent: 09 December 2005 14:13 To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] SOX question (United States only, I believe) SOX SUCKS! (we have tee shirts with 'SOX SUCKS' on the front) Our productivity has gone way down. If there is a problem here is what we have to do now. And there are plenty of internal and external auditors to make sure we do the following. 1. Create a request to modify. 2. Copy the records from LIVE to DEVEL. 3. Debug the process. 4. Mod the program and correct the data records. 5. Create a user approval form. 6. Have the user sign off. 7. Have the IT manager sign off. 8. Notify the manager of programmers of the change 9. The manager of programmers notifies the system admin. 10. The system admin then moves the programs and (or) the corrected data records. 11. The system admin then notifies the IT staff of the move. 12. The programmer then notifies the user. Documentations includes screen shoots of all changes, programs, DICT, screens and records. The average doc package is about 8 pages. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Steven M Wagner Sent: Friday, December 09, 2005 8:27 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] SOX question (United States only, I believe) Marc How do the programmers to customer support if they cannot look at the data in the production data-base? It would be hard to research problems if you cannot look at live data. Steve At 08:49 AM 12/9/05 -0300, you wrote: Good Morning Charlie, No only a US issue, but also an issue for multinationals with US home offices. We are in Argentina and have clients that must comply and frankly we DO separate the DBA role from the programmer role and I am in favor of this although it is an administrative pain at times. Programmers on these sites do not get access to the production data-base and only get read-only to the user testing environment. Regards, Marc Hilbert Pick Professional Center Buenos Aires, Argentina. - Original Message - From: Charlie Rubeor [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, December 08, 2005 6:28 PM Subject: [U2] SOX question (United States only, I believe) When we started implementing Sarbanes-Oxley, I knew the question of why we don't separate the Database Admin role from the Programmer role would come up. Has anyone on this list been able to provide a satisfactory answer to the auditors, without spending a lot of time explaining the benefits of an MV database? Charlie Rubeor Unix/Database Administrator Wiremold/Legrand 60 Woodlawn Street West Hartford, CT 06110 Tel: 860.233.6251 x3498 Fax: 860.523.3690 Email: [EMAIL PROTECTED] Internet: www.wiremold.com [demime 1.01d removed an attachment of type image/jpeg] --- 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/ -- Steven M Wagner [EMAIL PROTECTED] Cary, North Carolina, United States of America --- 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/ This message has been comprehensively scanned for viruses, please visit http://virus.e2e-filter.com/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [Maybe spam] RE: [U2] Remove Scenario
Rubbish,sorry Tony but that's what I think. You say experienced developers and big companies don't use EQU INVNO.TABLE TO CUST(40). I beg to differ. What do you call experienced? does 20 years count??? and what do you call a big company??? we only have two boxes running universe, two HP boxes, one with 32 processors and four logical machines, with over 5k users. We define all our files this way. Our user base is growing all the time as the company grows and our apps just keep on working. Les. -Original Message- From: Tony Gravagno [mailto:[EMAIL PROTECTED] Sent: 12 August 2005 07:23 To: u2-users@listserver.u2ug.org Subject: [Maybe spam] RE: [U2] Remove Scenario Mark Johnson wrote: Here's a doozy. Mark, the fundamental problem is that the original code wasn't designed for the application that it's being asked to do now. That construct that you describe EQU INVNO.TABLE TO CUST(40) is something that experienced developers simply don't use anymore because it's such a bad idea. That code was written for small companies and when they get larger it falls apart as you see. It's like generating invoice numbers like this: INV.NUM = (OLD.NUM+1)R%4 Anyone remember day 10,000? This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] {Spam?} Unidata question
Had a look at how we do it. This is on universe thought. Disable logons (done in our menu system, it logs users off after they logon) Do a port status to find out who is on the system Send messages to the users giving them a countdown to being logged off Do another port status to find out who is still logged on Do Master OFF for those still logged on start evening work . . Finish evening work Enable logons Not as much help as you were looking for, I didn't read the Unidata in the subject line (dooh). But you're on the right track. Les -Original Message- From: Barry Green [mailto:[EMAIL PROTECTED] Sent: 27 June 2005 17:11 To: u2-users@listserver.u2ug.org Subject: RE: [U2] {Spam?} Unidata question Thanks Les, that would be great!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Les Hewkin Sent: Tuesday, 28 June 2005 12:42 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] {Spam?} Unidata question We do just this. We also have a list of users not to logoff, operators and the like. Haven't got the details to hand on how we did it, it's so long ago. Will dig out the details and post them. Les. -Original Message- From: Barry Green [mailto:[EMAIL PROTECTED] Sent: 27 June 2005 14:55 To: u2-users@listserver.u2ug.org Subject: [U2] {Spam?} Unidata question Hi Group, I'm using Unidata 6.1 on a Windows 2000 server. I'm having problems when I run a backup (using Arcserver) if users do not disconnect their sessions correctly the backup fails. I'm looking for a way to run a batch file before the backup which does the following: - Prevents future logins - Send a message to all logged in users saying Session will disconnect in 3 minutes - Sleep for 1 minute - Send a message to all logged in users saying Session will disconnect in 2 minutes - Sleep for 1 minute - Send a message to all logged in users saying Session will disconnect in 1 minute - Sleep for 1 minute - Logoff any logged in users Perform backup Then run another batch file which just restores the login function. Has anyone done this or can you give me any clues as to how and which commands to use, particularly the commands to stop logins, logoff all users (preferably in one command) and to allow logins again. Many thanks Barry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://virus.e2e-filter.com/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- 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] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...
Just going a bit off topic but. we had a batch process that processed lots of data and I mean lots, but it didn't have any transaction boundaries. Someone was asked to add them. So what did they do? yes you got it. At the start of the routine they started a transactions and at the end of the routine they ended the transactions. Guess what? the lock table filled up and the whole thing fell over. The fun you have with transactions is endless :-) Les -Original Message- From: Stevenson, Charles [mailto:[EMAIL PROTECTED] Sent: 22 June 2005 18:50 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... From: Les Hewkin What would you call a really big transaction? A transaction should encompass all updates that should happen (or be abandoned) as a group in order to insure logical data integrity at the application layer. Let me use an example, keeping the preceding statement in mind. (Please don't belabour the details. This is just to get the broad idea.) Suppose out in the real world, a car gets repaired. This is one chunk of work that the customer typically signs off on and pays as a whole. In a database application representing this bit of reality, at some point there is a work order that needs to be posted. Maybe - ~maybe~if you design it right - pieces of it can be posted as separate transactions in an attempt to keep transactions as small as possible, but to completely post the work order: - multiple parts each need to be moved from, inventory to car. - associated double entry journal entries need to happen to keep accountants happy. - some low-stock condition might trigger automatic re-order of some parts. (one could argue this is separate, but depending on how it is programmed this may end up nested in this Transaction) - some parts might be consignment and vendor info needs to be updated. - serial numbered parts might require special treatment. - mechanic's (plural?) hours need to be recorded in timekeeping system. - associated accounting journal entries. - Invoice needs to be created. - customer info updated. - maybe immediate payment: associated accounting updates. - Car history needs updating (let's say this is a regular customer we track his cars) - warranty or rebate info needs to be sent or queued for auto manufacturer. - more accounting journal entries? - Multiple user-defined cross-reference files (if/when native indexing not used) Under normal circumstances all that happens as one big lump (at least your business user hopes so. But one can imagine scenarios where part of the repair is in dispute, the customer agreed to part of the work, or is unhappy, etc. ) so normally a given repair is either Open or Closed. One might program it so that this post is one TRANSACTION, maybe with nested TRANSACTIONs within it. These would be really big transactions. There may be a lot of processing that happens between TRANSACTION START and COMMIT. Anywhere along the line some abnormality might cause a TRANSACTION ABORT. All of these would have to happen as a unit, or be rejected as a unit in order for the DB (at an application level) to remain self-consistent. If one were smart, one could invent stand-alone partial posts where one transaction involved one part or one labour entry, etc.. But even in those cases, each transaction would have to update part, or labor info, the repair record, and accompanying accounting journal entries all as one unit to maintain application integrity. These would still be big if not really big transactions. In either case, each transaction would involve multiple updates to files. More than one file /or record may involve sequential ids. Going into the transaction one might not know all that will be needed. Pessimistic and optimistic locking methods changes what one knows as a transaction begins. If you place a readu lock as soon as you read the record, then do the processing and decision making within the transaction, the transaction takes longer and locks remain set longer. If you do the processing first, then you know the updates required before you TRANSACTION START and re-read, placing readu locks, and compare what you expected with what you got. Almost all applications have one central document (like the repair order above) that everything revolves around. It usually defines the relationships to most of the other major entities in the db. There are usually updates that involve that central document and the entities connected to it. Those updates usually have to happen as a group, one logical transaction, for the sake of application data integrity. This is the sort of thing I was thinking about when I posed the question of how to control sequential ids, releasing that control ASAP within big transactions. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org
RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...
Hi, Just got back from a short break camping so sorry for the late reply. What would you call a really big transaction? I look at it like this. You have to write the data away, you need the next seq number, so everyone else can wait. How long does it take to write away data to disk? We split lots of the seq numbers down. We use the cost center that the user works in as part of the record key. This means lots of control records but not many problems. It all revolves around getting the lock on the control record first. Think of how a manual system would work. Someone wants to put a file in a filling cabinet but someone else is already there, they wait for the other person to finish what they are doing. The amount of time you have to wait is minimal. The only problem you get is when someone new comes along and doesn't understand about locking the control record first. Hope this helps Les. (only another 150 EMails to read) -Original Message- From: Stevenson, Charles [mailto:[EMAIL PROTECTED] Sent: 16 June 2005 04:54 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... Ah-HA! Some real world transaction experience! Just what I wanted, Les. From: Les Hewkin Start trasnactions Readu control record then record.ID = control record write record control record += 1 write control record end end transaction This seems to work for us. We do have loads of control records for generating ID and we never have any missing numbers. And for really big 'trasnactions', where there is a lot of other writes mixed in, having the control record locked for the duration of the transaction is not a bottleneck for you? That was my main concern. cds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://virus.e2e-filter.com/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How to release locks (LIST.READU)
Have a look at the UNLOCK command. This allows the system administrator in the UV account to unlock any lock set by a READU. Before you go round unlocking records make sure you know why the locks are there. Has someone just walked away from their screen for a while? Unlocking records can lead to problems later on. Les -Original Message- From: Anthony Dzikiewicz [mailto:[EMAIL PROTECTED] Sent: 15 June 2005 12:01 To: u2-users@listserver.u2ug.org Subject: RE: [U2] How to release locks (LIST.READU) I dont believe LIST.LOCKS shows READ locks. Use LIST.READU EVERY to see all READU locks. Two commands for two different things. I dont know of any commands to release READU locks. The MASTER LOCKS command will release the synchronization locks, but not READU. One thing you could do is to MASTER OFF the user. This is not always the best thing. You could walk over to their terminal and back them out of what they are doing. You could also make use of TANDEM to take control of the terminal and do the same thing (if you dont like walking). If it is a deadlock, shown by LIST.READU EVERY, I always use the admin menu, deadlock administration to take care of it. Anthony -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pankaj Gupta04 Sent: Wednesday, June 15, 2005 5:21 AM To: u2-users@listserver.u2ug.org Subject: [U2] How to release locks (LIST.READU) Hi All, I am facing a strange problem with the locks. When I executed LIST.LOCKS at universe prompt, no locks were shown but when I executed LIST.READU, 7 records were displayed as locked. I tried to CLEAR all the locks but was not able to do that. Can someone tell me how to release the locks which are displayed in LIST.READU output? Thanks in advance. Regards, Pankaj Gupta *** CAUTION - Disclaimer ** This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS End of Disclaimer INFOSYS*** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 6/8/2005 -- Internal Virus Database is out-of-date. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.6.6 - Release Date: 6/8/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://virus.e2e-filter.com/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO...
What was the question? If I remember correctly it was about the best way to allocate sequential numbers for record ID's? Yes? Well here goes Start trasnactions Readu control record then record.ID = control record write record control record += 1 write control record end end transaction This seems to work for us. We do have loads of control records for generating ID and we never have any missing numbers. We have an internal audit department that goes around checking these things. Just had a quick check and there are 3140 users logged on to one of our systems and we don't have locking problems. Nice, neat and simple. If anything does go wrong then it is due to a major system problem, but we don't have them anymore!!! Les -Original Message- From: Bruce Nichol [mailto:[EMAIL PROTECTED] Sent: 14 June 2005 05:04 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... Goo'day, Bob, At 19:44 13/06/05 -0700, you wrote: Come on, people. A request was made for options. I guess I'm one of those to whom you are referring. Please accept my abject apologies. However, in my defence, and in defence of those others, I'll add that the discourse started with options and then evolved in to SOX and auditors. Your offering came after that, so my (and, I assume, others) response was geared towards the latest level of the discussion. snip Now if you have something better, offer it up! The original poster wants options, so lend a hand instead of a finger. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Steve Johnson Sent: Monday, June 13, 2005 4:29 PM To: U2UG Subject: Re: [U2] Best practice for Sequential IDs using TRANSACTION START COMMIT/RO... But this would not keep those pesky auditors happy. In the following sequence, how could they know that item 1*4 was missing? 1*1 1*2 1*3 2*1 etc. Regards, Steve Johnson FXA Group Ltd Bangkok [snip] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.0 - Release Date: 13/06/05 -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.0 - Release Date: 13/06/05 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.323 / Virus Database: 267.7.0 - Release Date: 13/06/05 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://virus.e2e-filter.com/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Uniobjects hack
I have been following this thread with great intrest. The issues seems to be that if someone has Excel, UniObjects and knows how U2 works that they can gain access to the data. Where are these people? Are they working for the IT department? Is this a real life scenario? or an exercise in theory of what might happen? Les -Original Message- From: Piers Angliss [mailto:[EMAIL PROTECTED] Sent: 31 May 2005 10:07 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Uniobjects hack JayJay, Reading between the lines I think you're saying a firewall could be a good idea I'm not sure that the other methods will work though. As I understand the problem, it is that you can have a secure VB App using UniObjects on a secure PC but if I have access to Excel on that PC, together with a valid server login id and password (with update rights) and basic knowledge of the directory structure on the server then techniques 2, 5, 6 7 won't trouble me at all. Ok, I need to understand UniObjects and U2. I'm not even sure that a firewall would help because the PC I'm trying to hack the database from has a valid IP address to run the VB App As somebody looking to implement UniObjects alongside traditional server-based applications that's a big hole. I can plug it by taking David Jordan's advice and using AUTHORIZE, but that's a lot of work for me at this stage. It sounds like UOLOGIN is a step in the right direction, but it is only available on UniData and if Ian's experience is any guide may have some implementation issues. I've been impressed with how easy it is to use UniObjects, I'm less impressed now. The functionality is great but in too many cases it's just a hugely inviting route to hack the database, it needs better server-side authentication Piers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Jenkins Sent: 30 May 2005 01:56 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Uniobjects hack Other techniques posted on the group will work as well - but to list a few: 1. firewall with nominated IP address interconnectivity ONLY 2. Restricted accounts with purged VOCs 3. O.S level permissions (or Tivoli Access Manager) 4. Triggers 5. Account level controls (remote verbs etc) 6. UO application-level authentication (suggest public key and one-time-pad for the serious - stops network sniffing) 7. Restrict access to Windows client PCs - stop anyone from doing anything untoward as they don't have permission to load or use that sort of software. 8. firewall 9. firewall --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://virus.e2e-filter.com/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Uniobjects hack
Can we have a quick show of hands of those who have had there U2 system hacked? I am not saying that it's not an issue, I am just curious. I do not know of it happening. Les -Original Message- From: Ian Renfrew [mailto:[EMAIL PROTECTED] Sent: 31 May 2005 13:33 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Uniobjects hack Even scarrier, if a person has telnet (almost definitely since its a OS supported application), a valid user id, password and knows how U2 works then they may be able to access data. No need to install UniObjects or purchase Excel. Depending on the version of UniData or network access, the user may be able to go as far as utilizing Windows Explorer to access / view UniData data. The user could use a file browser to view report information contained within the HOLD (_PH_ / PH) file. ... Ian - Original Message - From: Les Hewkin [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, May 31, 2005 6:09 AM Subject: RE: [U2] Uniobjects hack I have been following this thread with great intrest. The issues seems to be that if someone has Excel, UniObjects and knows how U2 works that they can gain access to the data. Where are these people? Are they working for the IT department? Is this a real life scenario? or an exercise in theory of what might happen? Les -Original Message- From: Piers Angliss [mailto:[EMAIL PROTECTED] Sent: 31 May 2005 10:07 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Uniobjects hack JayJay, Reading between the lines I think you're saying a firewall could be a good idea I'm not sure that the other methods will work though. As I understand the problem, it is that you can have a secure VB App using UniObjects on a secure PC but if I have access to Excel on that PC, together with a valid server login id and password (with update rights) and basic knowledge of the directory structure on the server then techniques 2, 5, 6 7 won't trouble me at all. Ok, I need to understand UniObjects and U2. I'm not even sure that a firewall would help because the PC I'm trying to hack the database from has a valid IP address to run the VB App As somebody looking to implement UniObjects alongside traditional server-based applications that's a big hole. I can plug it by taking David Jordan's advice and using AUTHORIZE, but that's a lot of work for me at this stage. It sounds like UOLOGIN is a step in the right direction, but it is only available on UniData and if Ian's experience is any guide may have some implementation issues. I've been impressed with how easy it is to use UniObjects, I'm less impressed now. The functionality is great but in too many cases it's just a hugely inviting route to hack the database, it needs better server-side authentication Piers -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Jenkins Sent: 30 May 2005 01:56 To: u2-users@listserver.u2ug.org Subject: RE: [U2] Uniobjects hack Other techniques posted on the group will work as well - but to list a few: 1. firewall with nominated IP address interconnectivity ONLY 2. Restricted accounts with purged VOCs 3. O.S level permissions (or Tivoli Access Manager) 4. Triggers 5. Account level controls (remote verbs etc) 6. UO application-level authentication (suggest public key and one-time-pad for the serious - stops network sniffing) 7. Restrict access to Windows client PCs - stop anyone from doing anything untoward as they don't have permission to load or use that sort of software. 8. firewall 9. firewall --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This message has been comprehensively scanned for viruses, please visit http://virus.e2e-filter.com/ for details. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users
RE: [U2] I'm in an Array quandry, any suggestions...
Any attributes outside the range of the dim are added to the last dim(?). So what you want to do is ok as long as you are aware of how the data is being held. Ok if you and only you are ever going to work on the system! We use an include to hold the dim statement along with an equate table. It makes these changes easy. One include to amend and a list of programs to compile. Les -Original Message- From: George Gallen [mailto:[EMAIL PROTECTED] Sent: 12 May 2005 16:01 To: u2-users@listserver.u2ug.org Subject: RE: [U2] I'm in an Array quandry, any suggestions... WOW. I just found an interesting feature of UV. You can MATREAD a record that has more fields than are dimensioned, and you can MATWRITE that record back out INTACT without getting an error, It only bombs with an out of bounds error when you try to reference a subscript past the dimension. Soas long as any of those program dont try to mess with data it doesn't know about, we should be safe. George -Original Message- [mailto:[EMAIL PROTECTED] Behalf Of George Gallen I'm modifying some programs that were written about 15-20 years ago, there must be 30 or 40 that interact with each other. Here is the problem. All the programs use dimensioned arrays, and they were dimensioned to exactly what was needed at the time, now I need to add 4 fields to one program. But I'm afraid if another program reads this newly created array, it will bomb out with an array out of bounds error. What is on my side, is all the programs that reference these files, all use the same variable name. My initial thought was to write a small program that will 1. open a program 2. search for a dimension of the suspect variable(s) 3. increase it's dimension level 4. write the program back out 5. recompile the program (I don't believe any are cataloged) Any other ideas? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] making 00001 our of 1
I don't like to disagree with people BUT.. I like the first example best. Why not compare like with like This is how I would write it BEGIN CASE CASE RATE.INDICATOR = 5 TOTAL.AMT = AMOUNT * MAIN.RATE CASE RATE.INDICATOR = 6 TOTAL.AMT = AMOUNT * SECONDARY.RATE CASE 1 ERROR.CODE = INVALID.RATE.ERROR.CODE END CASE We each have our own style. They are all just as good as each other. It's just what you are used to. Les. -Original Message- From: Adrian Matthews [mailto:[EMAIL PROTECTED] Sent: 03 March 2005 14:55 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] making 1 our of 1 Personally I find well spaced and structured code easier to read. Consider the following: BEGIN CASE CASE V=5 TOTAL = AMT*RATE CASE V=6 TOTAL = AMT*RATE2 CASE 1 ERR = 14 END CASE Is much better as: Begin Case Case RateIndicator = 5 TotalAmt = Amount * MainRate Case RateIndicator = 6 TotaAmt = Amount * SecondaryRate Case ELSE ErrorCode = INVALID_RATE_ERROR_CODE End Case Obviously ELSE and INVALID... are equates. Humans can read mixed case a great deal easier than all uppercase and the spacing helps the logic. Sensible variable naming negates the need for comments. All above IMHO and how long will this thread survive before going to community!! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 03 March 2005 13:53 To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] making 1 our of 1 IMHO I use the term 'overly grand' when i review existing prior code on my current and new clients and there is a very large verbose nature to it. Not being conclusive, but often times the code looks nice but there's way too much 'air' in the program at the expense of being better in the logic area. Certainly I've not read everyone's code. But what I've seen over the years has taught me that when I see grandness, that grandness takes a 200 line program and makes it 700. Case in point: *** * * OPEN MD FILE * *** OPEN ,MD TO F.MD ELSE ERRMSG=CANNOT OPEN THE MD FILE. PLEASE CONTACT YOUR PROGRAMMER GOSUB 9 STOP END * * * OPEN PRODUCT FILE * * OPEN ,PRODUCT TO F.PRODUCT ELSE ERRMSG=CANNOT OPEN THE PRODUCT FILE. PLEASE CONTACT YOUR PROGRAMMER GOSUB 9 STOP END * * END OF OPENING FILES * What gets me is the time spent to make the asterisks match the length of the comments. I see your variable assignment style a lot yet if a new variable were needed, say CUSTOMER.LAST.SALE.DATE = would you re-indent all of the other variables just to look pretty? (I don't mean pretty in a derogatory way, I mean to spend your time and the client's $ for something that really doesn't matter) I know that there are some system-generated source code 4GL's that may create the comments for you. But I can see past that with the inconsistent content of the actual code. There is a command which escapes me now that formats source code (not necessarily databasic) in the editor to match old-school BAL programming. I've tripped over it by accident and then lose my changes as I EXit and then re-edit to not have all the 'air'. Some could argue that a 200 line program becoming 700 could fall under the concept of standardized programming or making it easier for the next guy. Well, I'm that 'next guy' plenty of times and since it's very inconsistent, it's certainly not a standard. I could write a book on the wide variety of programming 'standards' I've inherited and the ineffeciencies found. It's unfortunate that in my travels the grandness happens to have a related brother of reduced logic and a more brute force approach. It's just harder to research with all of that clutter. My 2 cents. Mark Johnson - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, March 03, 2005 6:56 AM Subject: Re: [U2] [UV] making 1 our of 1 Mark, I'm one of those programmers who use the overly grand way of spacing you describe. I believe that ASDTFY = '' AS = '' DRT = 0 is much more readable than ASDTFY='' AS='' DRT=0 especially when there is a lot more code than in this example, and everything else around it is crammed together as tightly as it can be as well. Code is written for the human as much as the compiler, and I like it to be as easy to read (and spot errors) as possible. This spacing won't bother a find program if you wrote it or have the source, and teach it better. My 4 cents. Regards, Charlie Noah [EMAIL PROTECTED] (mailto:[EMAIL PROTECTED]) writes: [snip] P.S. If you use my concept, you may
RE: [U2][UV] UO.NET beginner question
I thought this was a bug in UV.NET, it can only use port 31438. Les -Original Message- From: Nick Cipollina [mailto:[EMAIL PROTECTED] Sent: 01 March 2005 15:43 To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] UO.NET beginner question Yes. No. I'm not sure if there was a reason. I would still like to know how to point to a different port, even if I could change it back to 31438. Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Don Kibbey Sent: Tuesday, March 01, 2005 9:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2][UV] UO.NET beginner question Are you on the same physical network as the target machine? Is there a firewall between you and it? What is the reasoning behind changing the rpc port to 7200? --- 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/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Windows 2003 password
Yes this is possible. We only ever change our passwords within Universe. I will go and try to find out how it gets done. I think some bright spark wrote a bit of c code to do it all... Les -Original Message- From: Louie Gouws [mailto:[EMAIL PROTECTED] Sent: 10 February 2005 12:59 To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Windows 2003 password Hi All, Universe 10.0.4 Windows 2003 Server I want to change the Windows 2003 password via my UV application (thru Telnet). The application is totally dependant on the Windows user + password for security, and I want the users to change their own passwords say every 30 days. Is it possible? Note: If the Windows 2003 password setup says every 30 days you must change our password - you can work for longer thru UV + telnet, without Windows 2003 forcing you to change your password. Is this a short-coming of UV ? Louie --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Header Trick Needed
Have a look at DQUOTE and SQUOTE They add quotes around vars Les -Original Message- From: Brutzman, Bill [mailto:[EMAIL PROTECTED] Sent: 12 January 2005 16:17 To: 'u2-users@listserver.u2ug.org' Subject: [U2] Header Trick Needed If possible, from within a UniBasic program, I would like to embed a specified date in a report header using a command like... execute SORT SALES.ANALYSIS BY CUSTHEADING 'Year-To-Date Sales ' : This.Date.F Perhaps more than the two standard quote chararacters, ['] and [] are available. Suggestions would be appreciated. --Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] The list format and usefulness
Just to throw oil on the fire... This is the technical list.please take this to the community list (very big grin..) Les 3 more days work to go -Original Message- From: Charles Barouch [mailto:[EMAIL PROTECTED] Sent: 21 December 2004 06:31 To: [EMAIL PROTECTED] Subject: Re: [U2] The list format and usefulness David, What I do is subscribe to both the list and the digest. That way I can skim and delete the individual messages as they come in (from the list), still have all the content if I need it later (from the digest). To control bandwidth, I have them going to two different names, so I can opt to not pull the e-mail with the separate posts if I don't have time or speed to spare for it. As moderator I can't delete-without-reading, but you could. I know it's not the answer you proposed, but I find it a workable solution. What has me more curious is your comment about the online indexing being insufficient. What would you like to see done differently? - Chuck Info-glut Barouch Clifton Oliver wrote: Full content. A lot of times watching how someone else is thinking is more instructive than what they are thinking. For a problem, an answer is enough. To learn how to solve a class of problems, watching the process that more experienced (or even just different) techs go through is an education worth the noise on the channel. IMO. Clif -- - Charles Barouch (718) 762-3884 x 1 - Key Ally Voice Mail cbarouch - Skype (Free VoIP Phone) [EMAIL PROTECTED] - Consulting services [EMAIL PROTECTED] - News [EMAIL PROTECTED] - U2-Users Moderator [EMAIL PROTECTED]- Zeus Data Integration Mount Olympus, Home of Zeus Data Integration --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Data Corruption
Edit the record and delete it. To be able to edit the record sselect the file first. this is how I do it Hope this help Les -Original Message- From: Brutzman, Bill [mailto:[EMAIL PROTECTED] Sent: 17 December 2004 15:56 To: '[EMAIL PROTECTED]' Subject: [U2] Data Corruption There lives a new record in our OP table that shows up as INVISIBLE from a TCL prompt. Without luck, I tried the commands... DELETE OP ^251 DELETE OP ^255 I looked at the file using EditPlus. Of course, there are many special characters that appear. Suggestions would be appreciated. --Bill --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Scanner Connection
Hi, We scan about 5000 documents a day. These are then feed into an optical system for storage. We have written apps that use these images. We would never think about trying to write a scanning app. There are so many good ones on the market, why try to reinvent the wheel? A good pakage should be able to do OCR. Les. -Original Message- From: Mark Johnson [mailto:[EMAIL PROTECTED] Sent: 01 December 2004 08:26 To: [EMAIL PROTECTED] Subject: [U2] Scanner Connection I have a client using Accuterm with telnet sessions for all the users. One user has a Bell Howell multi-page scanner that gets around 100 pages per day of work orders etc. That user's emulator is Ve-Client from Visual Pick and they want to re-write the app with Accuterm and some VB scripting if necessary. My question is where would someone go to find out how this can be done. It presently is done in VE with a 9,500 line program (4GL generated code) that has oodles of includes and gets very busy. It still doesn't do what I would like and that is for the scanner to write the scanned docs to a temp folder, I would use Accuterm to load in those filenames and offer them to the user for proper pc-filenaming to attach to the application. I would appreciate any insight on this. Thanks in advance. Mark Johnson --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Begin Transaction / Commit without turning on transactio n logging
Yes this will work in Universe, we do it all the time. There are certain things that you can't have inside a transaction. Perform input are the two that spring to mind. Also beware of where you do your reads. Reads inside a transaction get raised to a READU To get a full understanding of the effects of transaction boundaries write some small test programs. Have a look at the lock table while the programs are running. Move the reads inside and outside the transaction and see the effects. Have fun. Les -Original Message- From: Bjvrn Eklund [mailto:[EMAIL PROTECTED] Sent: 30 November 2004 09:54 To: '[EMAIL PROTECTED]' Subject: SV: [U2] Begin Transaction / Commit without turning on transactio n logging I have a follow up question What if you in program A use a BEGIN TRANSACTION and then start another program B and then come back to program A Like This: BEGIN TRANSACTION if x= 1 then call programB(y) end x=x + y + 1 COMMIT How does RFS handle this? Is the processing in program B a part of the transaction or? Bjvrn Eklund -Ursprungligt meddelande- Fren: Bob Witney [mailto:[EMAIL PROTECTED] Skickat: den 30 november 2004 10:29 Till: [EMAIL PROTECTED] Dmne: RE: [U2] Begin Transaction / Commit without turning on transaction logging This works fine, our main system has used it all the time since 1994 with absolutely no problems on Universe under AIX all releases Bob -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dennis Bartlett Sent: 30 November 2004 09:04 To: [EMAIL PROTECTED] Subject: [U2] Begin Transaction / Commit without turning on transaction logging Hi All I've been told that using BEGIN TRANSACTION at the start of an update routine, and COMMIT at the end will cause the system to store (in memory) all pending updates until the commit... how true is this, and are there any caveats? - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, WG M|lke, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
[U2] test
Are the lists up and running? I haven't seen any post for nearly 24 hours Les. This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Why is this statement failing? (UniVerse)
What do you expect this to do ? What do you mean when you say there is a bug? I have tried this on universe, with a few CRT's added, and all looks ok to me. Les. -Original Message- From: Chris van O [mailto:[EMAIL PROTECTED] Sent: 08 October 2004 07:30 To: [EMAIL PROTECTED] Subject: [U2] Why is this statement failing? (UniVerse) Ive found a bug that has been in production for many years, but has just started to cause problemsbut I dont know exactly why... DEC.OFFSET = 1 FOR I = 1 TO 20 FOR J = 1 TO 99 K = I R0%2 : '.' : J R0%2 PRX = K IF INT(PRX*DEC.OFFSET)=DEC.OFFSET*PRX THEN PRINT K : ' PASSED' END ELSE PRINT K : ' FAILED' END NEXT J NEXT I Ive fixed it by saying . IF (PRX*DEC.OFFSET)+0 = DEC.OFFSET*PRX THEN But I still cant dont know why it was failingor why this hasnt been a problem in 10 years with over 50,000 transactions a day. The data are strings passed from a client app that usually look like: 80.03 120.25 100.01 12002.4 --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] How do we get unique records from Universe file(Table)
Hi, What do you mean by 'unique'? Can you show us an example of what you want to do. All records in a universe file have a unique identifier (ID). Les. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 August 2004 15:05 To: [EMAIL PROTECTED] Subject: [U2] How do we get unique records from Universe file(Table) Hi, Can anybody help me in retriving the unique(distinct) records from Universe file tax in advance regards Reddy --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniObject Licening
Have a look at Redback. We use UniObjects for VB applications but Redback for web based applications. Redback uses a server process to cut down the number of licenses used. Les -Original Message- From: Nick Southwell [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 09:19 To: [EMAIL PROTECTED] Subject: RE: [U2] UniObject Licening Are your thousands of students concurrent users? We designed our application to have a max number of connections say 100. When the application knows it has reached that limit it will sleep and retry. Its not the most graceful approach but it allows us to put a ceiling on usage. Cheers Nick -Original Message- From: Fawaz Ashraff [mailto:[EMAIL PROTECTED] Sent: 14 July 2004 02:46 To: [EMAIL PROTECTED] Subject: [U2] UniObject Licening Hi All, We are trying to use UniObject for UniData to get information for various web projects. Most of the Front End is done using VB .Net. It looks like UniObject is using a user license for each connection. There would be thousands of students using this application and we are having a licensing issue. Should we structure our program differently? Has anyone else come a cross the same problem? If so what did you do? Thanks a lot. Fawaz __ Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard. http://promotions.yahoo.com/new_mail --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately. No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Open and Direct Group Limited unless otherwise notified by our duly authorised representative independent of this message. Open and Direct Group Limited is a limited company registered in United Kingdom under number 4390810 whose registered office is at 10 Norwich Street, London, EC4A 1BD --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Passing a SELECT ID if it's not in the file...
George, Lists are just items held in a file, SAVEDLISTS. Run a program that creates a list for you and then just do a get list. Les. -Original Message- From: George Gallen [mailto:[EMAIL PROTECTED] Sent: 09 July 2004 15:54 To: [EMAIL PROTECTED] Subject: [U2] Passing a SELECT ID if it's not in the file... I have a paragraph that does... SELECT FILE WITH @ID = TARGET RUN PROGRAM {Program} LOOPS THROUGH READNEXT ID'S IF ID IS IN FILE IGNORE OTHERWISE PUT IN FILE This works fine if TARGET exists in the FILE. How would can I force the TARGET to be in an active select list if it's not in the file? Keeping in mind this is in a paragraph. I tried: 0001: PA 0002: * A,Enter ID 0003: EDIT-LIST 0004: DATA I 0005: DATA Enter ID 0006: DATA FI 0007: GET-LIST 0008: LIST FILE But I'm stuck at the EDIT-LIST. How do I tell it a unique listname , unique for the PID anyway. For Instance, If you say SAVE-LIST (noname), it saves it using a unique name for the PID, and GET-LIST (noname) will get this list. But is there anyway to get this uniquename for EDIT-LIST? George --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] CREATE.FILE one liner and UVSH.EXE
To create a test file type CREATE.FILE TESTFILE 1,2,18 1,2,19 1,1,18 is the dict size and type (mod = 1, sep = 2, type = 18) 1,1,19 is the data size and type (mod = 1, sep = 2, type = 19) Les -Original Message- From: Andy Moore [mailto:[EMAIL PROTECTED] Sent: 07 July 2004 11:42 To: [EMAIL PROTECTED] Subject: [U2] CREATE.FILE one liner and UVSH.EXE DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please delete it and notify the sender immediately. Please note that there is no guarantee that this email or any attachment is virus free or has not been intercepted or amended. Hello, I am currently writing an application in VB.Net that communicates with Universe servers via UVSH.EXE (can't use Uniobjects as not all our users install them or allows them) I have hit a problem where I am trying to create a file via UVSH.EXE as it appears I am limited to one line commands, unless anyone knows differently? The problem is that I am trying to create a type 19 file and although the help file on Universe states I can do this with one line, Universe itself doesn't seem to alllow it. In the help file it says the following: CREATE.FILE [DICT | DATA] [filename [, datafile]] [type] [modulo] [separation] [parameter [value]...] [description] Am I incorrect in understanding the TYPE option to be the file type? For an example to this I am typing (following the above) CREATE.FILE TESTFILE 19 1 3 which I would expect to create me a type 19 file, but it creates a type 18 file! Is there something I am doing wrong here or is the help file incorrect? I have tried this on Universe 10.0.4 and 10.1.0 and both versions seem to act the same. Andy Moore Selima Software Ltd Tel: 0114 2815000 Fax: 0114 281 email: [EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/