[U2] BLAT with Outlook Calendar/Appointments
While this isn't a U2 or even an MV question, someone may have some guidance. I've installed BLAT on a few MV clients systems with very favorable results. I don't want to entertain any U2-specific email utilities or SENDMAIL unless all other options are exhausted. There's something in Outlook whereby a user can be in an appointment and 'send' that appointment to a recipient and it shows up in their calendar program as an appointment. It may or may not show up as a regular email. But it definitely shows up as an appointment. My client uses Outlook at the manager's desk and the MV system can send scheduled calls as emails to the sales and technical traveling people's blackberrys. But they would like to deliver the appointments further to the recipient's calendar. I'm all ears. Thanks in advance. Mark johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [OT][U2] Wintegrate
In my post I suggested not focusing on cost alone. So is there a fair comparison (like consumer reports) between Wintegrate and Accuterm. I've used both and am pro-Accuterm and am finding some of my colleagues dissing Accuterm 97 as that's as far as they got. Yes, I'm using Wintegrate 98 but I don't know what their latest is either. I can't imagine Accuterm 2K2 falling short on any comparison for any features as Peter Schellenbach has impressed me tremendously with his knowledge (or access to) MS internals and MV internals in his product. Therefore, is there an unbiased review of the features of these 2 emulators. And what about Procomm and/or Viaduct. Thanks Mark Johnson - Original Message - From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, December 14, 2006 6:29 PM Subject: RE: [OT][U2] Wintegrate Mark: The usual rule for technologists is we want what we want because someone else is paying for it. The usual rule for business people is we want what works as long as it's cost effective (or cheap). :-) The cost difference isn't really fair for a side-by-side comparison of the benefits of the products. To me the cost is of paramount importance because whatever wIntegrate has that AccuTerm doesn't have can't possibly justify wIntegrate costing $11,250 for a 50 user operation vs $1,000 for AccuTerm when I'm paying for it. It's like U2 costing $75,000 for a 100 user license while DB2 or SQL Server costs $5,000 - $7,500 for an unlimited single CPU license. It makes it hard to compete. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Thursday, December 14, 2006 2:45 PM To: u2-users@listserver.u2ug.org Subject: Re: [OT][U2] Wintegrate I'm all ears. I've been using Wintegrate for 10 years (most recent is W98) and was Pro-Wintegrate up until 2 years ago when a client wanted to get out from under VE-Client (that's another disaster). I wrote up my side of the story and another consultant posted his side about Accuterm 2K2 (The latest). Side, by side things were equal until we got to WED, GED and, best of all (although no flames for being only price conscious), the price. IBM wanted $225 per seat for my client's 40 user system and Accuterm was $1,000 for 50 seats. The best IBM would do is a 5% discount. Considering the immense support that I've personally received from Peter Schellenbach and the wonderful features of Accuterm, compared to the stoic corporate stonewall from IBM it was more of a no brainer. Perhaps if you're remembering Accuterm only as a terminal emulator then that's not fair to accuterm. The WED program editor is the best I've seen in my 3 decades of MV programming and the GED environment allows VB-looking forms to work directly with the MV database without any ODBC or other middleware. Plus, there's a whole boatload of VB-Scripting capabilities that make every PC and network resource available to a MV program. As an emulator, accuterm can have multiple sessions in split windows, bridge copy/paste between different systems, copy/paste to MS apps, detect PC elements like last window opened etc plus all the expected keyboard mapping, emulations and other emulator stuff. For us programmers, WED is worth the price of admission by itself. Words cannot fully describe how wonderful editing MV programs with a notepad editor that understands MV concepts as compared to just using notepad. My 2 cents for Accuterm. Mark Johnson - Original Message - From: Symeon Breen [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, December 14, 2006 3:43 PM Subject: Re: [OT][U2] Wintegrate No No No- Wintegrate wins against Accuterm any day . On 14/12/06, Mark Johnson [EMAIL PROTECTED] wrote: If you must get wintegrate, it should still be available from IBM. I would strongly go with Accuterm as it wins hands down on many comparisons. Unless your apps are married to wintegrate's gui components. Accuterm's GUI designer is huge. 2 of my clients have dictated that all new programs are done with it and it works perfectly side by side in a green screen environment. Best of all, Accuterm is $1,000 for 50 licenses versus $225 each from IBM. You do the math. My 1,000 cents Mark Johnson - Original Message - From: Nick Cipollina [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, December 13, 2006 11:47 AM Subject: [OT][U2] Wintegrate Does anyone know where I can get a copy of Wintegrate? Thanks, Nick Cipollina MCTS, MCP ACS Heritage, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804) 965-8294 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users
Re: [OT][U2] Wintegrate
If you must get wintegrate, it should still be available from IBM. I would strongly go with Accuterm as it wins hands down on many comparisons. Unless your apps are married to wintegrate's gui components. Accuterm's GUI designer is huge. 2 of my clients have dictated that all new programs are done with it and it works perfectly side by side in a green screen environment. Best of all, Accuterm is $1,000 for 50 licenses versus $225 each from IBM. You do the math. My 1,000 cents Mark Johnson - Original Message - From: Nick Cipollina [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, December 13, 2006 11:47 AM Subject: [OT][U2] Wintegrate Does anyone know where I can get a copy of Wintegrate? Thanks, Nick Cipollina MCTS, MCP ACS Heritage, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804) 965-8294 --- 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: [OT][U2] Wintegrate
I'm all ears. I've been using Wintegrate for 10 years (most recent is W98) and was Pro-Wintegrate up until 2 years ago when a client wanted to get out from under VE-Client (that's another disaster). I wrote up my side of the story and another consultant posted his side about Accuterm 2K2 (The latest). Side, by side things were equal until we got to WED, GED and, best of all (although no flames for being only price conscious), the price. IBM wanted $225 per seat for my client's 40 user system and Accuterm was $1,000 for 50 seats. The best IBM would do is a 5% discount. Considering the immense support that I've personally received from Peter Schellenbach and the wonderful features of Accuterm, compared to the stoic corporate stonewall from IBM it was more of a no brainer. Perhaps if you're remembering Accuterm only as a terminal emulator then that's not fair to accuterm. The WED program editor is the best I've seen in my 3 decades of MV programming and the GED environment allows VB-looking forms to work directly with the MV database without any ODBC or other middleware. Plus, there's a whole boatload of VB-Scripting capabilities that make every PC and network resource available to a MV program. As an emulator, accuterm can have multiple sessions in split windows, bridge copy/paste between different systems, copy/paste to MS apps, detect PC elements like last window opened etc plus all the expected keyboard mapping, emulations and other emulator stuff. For us programmers, WED is worth the price of admission by itself. Words cannot fully describe how wonderful editing MV programs with a notepad editor that understands MV concepts as compared to just using notepad. My 2 cents for Accuterm. Mark Johnson - Original Message - From: Symeon Breen [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, December 14, 2006 3:43 PM Subject: Re: [OT][U2] Wintegrate No No No- Wintegrate wins against Accuterm any day . On 14/12/06, Mark Johnson [EMAIL PROTECTED] wrote: If you must get wintegrate, it should still be available from IBM. I would strongly go with Accuterm as it wins hands down on many comparisons. Unless your apps are married to wintegrate's gui components. Accuterm's GUI designer is huge. 2 of my clients have dictated that all new programs are done with it and it works perfectly side by side in a green screen environment. Best of all, Accuterm is $1,000 for 50 licenses versus $225 each from IBM. You do the math. My 1,000 cents Mark Johnson - Original Message - From: Nick Cipollina [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, December 13, 2006 11:47 AM Subject: [OT][U2] Wintegrate Does anyone know where I can get a copy of Wintegrate? Thanks, Nick Cipollina MCTS, MCP ACS Heritage, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804) 965-8294 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Taxware
In the last 12 years I've lost a bunch of clients due to mergers or 'upgrades' to allegedly more modern systems. With only one exception, each was a turn for the worse. The users bemoaned the lack of features we have installed and while it looks 'pretty' with its GUI interface, it is nice frosting on a very plain cake. The fact that you're migrating over to an RPG system makes me laugh and cry at the same time. I programmed with RPG in the mid 1970's before working for Microdata then. You will sorely miss virtually everything that is missing on that AS/400 system that is taken for granted on an MV system. While many contempory IT people look down their noses at us MV people, RPG is even worse than MV in this case. Today, these youngsters think RPG is either Role Playing Game or Rocket Propelled Grenade and not Report Program Generator. If there's any shred of possibly having a fair trial for the death penalty of your MV system, then I could offer a few real-world scenarios where the MV system would have prevailed. Now I know that we're biased towards MV. But to go to RPG is more Jurrasic than Pick is. My 2 cents. Mark Johnson P.S. I have friends who still program in COBOL, Fortran, Pascal, IDA and even BAL. And we're the ones criticized for keeping our technologies in the past. - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, November 29, 2006 7:40 AM Subject: Re: [U2] Taxware Mark, With all of the changes in Unidata (over the years) we have been able to due an awful lot with Shims. Obviously, it no longer resembles the original version. We interface to conveyor systems, built an EDI engine, web presence, Amazon integration, address correction software, external search engines, etc. It really works well for us. As a matter of fact, there is another local company, that I believe, is still using Shims as well. Unfortunately, every good thing comes to an end. We were acquired by an entity that does not use Unidata. Theoretically, over the next 6 months we will be assimilated to their AS/400 RPG 4 system. Oh, well. Vance Mark Johnson [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/28/2006 11:07 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject Re: [U2] Taxware I'll bite. How big (or not big) is SHIMS now-a-days. I worked on it 20 years ago along with its step brother, RESULTS. Is it supported or detached like Results? Thanks Mark Johnson. --- 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] Taxware
I'll bite. How big (or not big) is SHIMS now-a-days. I worked on it 20 years ago along with its step brother, RESULTS. Is it supported or detached like Results? Thanks Mark Johnson. - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, November 28, 2006 10:36 PM Subject: Re: [U2] Taxware I integrated Taxware into our business system (Shims - Unidata 6.0). We use the transactional approach for exemption certificates but have developed a c-wrapper (with the help of this list) for the realtime api for the tax calculations. We do not use the client side application for tax exemptions because it is far to limiting (have to download to a local pc and manually enter certificates). If you would like move information, please feel free to contact me offline. Vance [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/28/2006 04:03 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject [U2] Taxware ok Task at hand -- install the c version of Taxware on AIX 5.3 Unidata 6.x and interact on a transactional or batch basis. I saw Epicor listed as one of their partners --- so Anyone use Taxware (first data company)? Setup? How it interacts? Batch or transactional? Problems? Support raves/woes? -- Debster --- 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] [UV] Question about EQU
I'm a little confused where dictionaries come into play with compiled versus interpreted programs. I've worked on interpretive basic system and dictionaries don't have anything to do with it. Unless it's a 3rd form of programming, ie parameter driven. Thanks Mark Johnson - Original Message - From: Debster [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Saturday, November 18, 2006 4:43 PM Subject: RE: [U2] [UV] Question about EQU Wouldn't it then be that anything that is using compiled rather than interpretive is faster... i.e. Basic rather than dictionaries... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin King Sent: Saturday, November 18, 2006 1:06 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [UV] Question about EQU David, I am interested in your opinions as to why, given that equates are compile time constructs, would have any impact at all on execution speed. Understand, I am not contesting your premise, but rather would simply like more explanation to understand your perspective. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- 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] [UV] Question about EQU
About 20 years ago I saw a programmer use a similar method. Like your observation, it seemed to work as they were Equated variables and not available in the debugger. This programmer also felt that the program would compile faster by having all of the comment lines after the last logical END. Somehow he felt that the miniscule time that the compiler spent not compiling a comment line within the program was worth the time for another programmer (me) to constantly have to print the commented section just to get the narrative on the different code sections. Your key word is 'inherit' as in a relic from the past. Don't tell anyone outside of the MV community or we're doomed. My 1 cent Mark Johnson - Original Message - From: Barry Brevik [EMAIL PROTECTED] To: U2-users (E-mail) u2-users@listserver.u2ug.org Sent: Friday, November 17, 2006 8:11 PM Subject: [U2] [UV] Question about EQU I inherited some code and I noticed that the programmer consistently placed his equates outside of the program flow, in other words, the equates would never be executed. Nevertheless, the DO get evaluated. For example: LABEL1: FOR I = 1 TO 10 PRINT 'HELLO WORLD' NEXT RETURN EQU THIS TO THAT, YIN TO YANG LABEL2: I = 1 LOOP I += 1 WHILE I LE 10 REPEAT RETURN See how the EQU would never be executed? Since it works, I assume the tokenizer reads the whole program and picks up the equates, but what I want to know is, is there some reason for doing it this way, perhaps better performance or less memory used? Barry Brevik --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Question about EQU
Let's not have a contest on bad programming techniques or we'll be here all year. Thanks. - Original Message - From: Kevin King [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, November 17, 2006 8:45 PM Subject: RE: [U2] [UV] Question about EQU See how the EQU would never be executed? Since it works, I assume the tokenizer reads the whole program and picks up the equates, but what I want to know is, is there some reason for doing it this way, perhaps better performance or less memory used? I would guess there is neither a performance nor memory reason but rather just an attempt at cleverness and/or obfuscation. EQUs, being a compiler directive, simply update the symbol table for compilation so there is no additional memory being used and as those symbols are compiled to p-code there would likely be no performance implication. I would think it would necessitate a two pass compilation or deferred references to anything equated to avoid unassigned variables, and the fact that its lack of obviousness has prompted your question, I'm inclined to nominate such a coding practice as The Bad Idea of The Week. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- 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] [OT] goodbye to the list(s)
Sounds like fun. Again, good luck in the future. Mark Johnson - Original Message - From: Claus Derlien [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, October 24, 2006 2:22 AM Subject: RE: [U2] [OT] goodbye to the list(s) I started programming on a zx81 in 1981 bought in Hong Kong complete with tape recorder and 16 kb expansion pack for 650 hk $ I was a trainee on a huge maersk container ship - my plan was to be an engineer maintaining ship diesels but got hooked on computers, so i changed direction to computers, but now i go back to the basics :-) For the record : as a motorman i will be maintaining all mechanical parts on the rig, as well as being man over board boat captain, and also take of the role as helicopter landing officer :-) I will prolly continue to do fun programming on my laptop with UniVerse PE - one of the pleasures of being on an oil rig is the schedule : 2 weeks offshore 3 weeks on shore at home :-) best regards from 'Soaking wet' denmark Claus Derlien -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Monday, October 23, 2006 2:40 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [OT] goodbye to the list(s) Good luck. Sounds more exciting than sitting at a desk all day. For the benefit of all, what was your movitation to convert to a really unrelated career? And what got you into programming in the first place. Thanks Mark Johnson --- 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] [OT] goodbye to the list(s)
Good luck. Sounds more exciting than sitting at a desk all day. For the benefit of all, what was your movitation to convert to a really unrelated career? And what got you into programming in the first place. Thanks Mark Johnson - Original Message - From: Claus Derlien [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, October 23, 2006 7:59 AM Subject: [U2] [OT] goodbye to the list(s) Alas it is my turn to shift focus - starting from next week i will no longer be a programmer, instead i will start a new career as a motorman onboard an oilrig in the northsea So i would just wish you all luck and prosperity in the u2 business.. For the last time best regards from Denmark Claus Derlien programmer --- 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] Slow ascii output
Keep in mind that 16MB for 32 users is 250 times the memory available circa late 1970s' with the Microdata Royale series. There's something to be said for programming on an older system that gives you respect for todays horsepower. I experience this first hand every other week when visiting my Microdata client from my normal U2/D3 client base. While you can't get really technically sophisticated as with the current systems, you do become more effecient when programming within limits. Perhaps the single thing I miss the most when programming on this old system is the fact that I cannot use external subroutiness as freely as on every other platform. I have a whole bunch of handy subs that I install on all of my clients but have to convert them to INCLUDES if I want to use them there. Microdatas don't like mixing RUN and cataloged programs together. My 1 cent. Mark Johnson - Original Message - From: Anthony W. Youngman [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Saturday, October 21, 2006 6:29 PM Subject: Re: [U2] Slow ascii output In message [EMAIL PROTECTED], Claus Derlien [EMAIL PROTECTED] writes no one and I mean NO ONE uses a system with 16 MB ram today! we have 65 users on 2 gig ram, and when we do payments of unemployment salaries to our members we do everything in memory, and just write the edi file to a record a large batch takes less than two minutes and it also generates payment specifications for storage in pdf format (using cross pdf package). oh and we also do an xml conversion of the edi file on the fly aswell.. UniVerse is really a top performer when it comes to number crunching and file management how do you power a 16 meg system today ?? - with steam ? Note the use of the PAST tense. That machine is now salvage in my garage, waiting for me to restore it to personal use. I was just pointing out that MMV, and some things may work for some people and not for others. Why we were trying to run 32 users on 16 meg, even when the system was brand new (1990ish), I don't know. Penny-pinching, I guess. It's just that WRITESEQ makes a lot of sense when you're building BIG strings and are short of RAM... Med venlig hilsen Claus Derlien programmxr Edb-afdelingen Cheers, Wol Our system was short of RAM - 16 meg for 32 users (PI/Open on an EXL 7330). It thrashed enough under normal load, even before you started to try and build large (and I mean LARGE) strings in BASIC... Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- 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/ -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- 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: RE: [U2] Roman Numerals
I recall this in the D3 manual and wondered why would anyone have such a thing. A=123 PRINT OCONV(A,U0033) yields CXXIII I guess it was for incrementing chapters or some other formal/outline number sequences. I don't know what the maximum number is but OCONV(25000,U0033) yields M. 50,000 and 100,000 didn't work. My XIV cents. Mark Johnson - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, October 19, 2006 4:25 AM Subject: RE: RE: [U2] Roman Numerals The Chinese Year has always been wrong, since it is still assumes 01 Jan as the start day of the year. I think I reported that to VMARK about 20 years ago... Brian David A. Green wrote: Does any one have a Digit to Roman Numeral converter they would like to share? Ron White responded: How about ICONV/OCONV with the NR function code. Look in the Basic Reference Manual index for roman numerals. A search on CDP reveals a couple interesting tidbits on this. According to Oliver Elphick, the NR conversion in Universe uses a change of alphabetic case to represent multiplication by 1000, so v=5 but V=5000. According to Tom Rauschenbach, [sic] the author of the NR conversion (someone named Hal) says that there was a reason for the upper/lower case distinction, but he can't remember what it was. He also claims that the Chinese New Year is wrong. (I have no idea what that means.) The D3 equivalent (as if anyone here cares) is the user exit U33. And the Reality equivalent is conversion MCDR. R83 had conversion MCR. So many standards, so little time... T --- 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] VOCLIB and keeping VOC entries Short and Small, IM RM
In observing this thread the words 'page size' caught my eye. In 1978 I remember a much older programmer working with me at Microdata (sic) reading very closely the Basic compiler output generated with the MAP option. Microdata's compiler didn't (doesn't) generate the necessary file helpful with debugging programs automatically so you had to specify with the (M option to generate it. It produced the variable table and laid out the basic code lines as they were spread out over the object code record. I recall him reviewing a FOR...NEXT loop that had the FOR part in one frame and the NEXT part in another and he was spending time trying to put compilable code (not comments) in front of the FOR section in the hope that the both the FOR and NEXT were in the same frame. This may have had the moniker Frame Faulting. Mainframes called this a Core Dump. So he would code and compile and review, code and compile and review until he felt it was right. Perhaps his age at the time (50?) indicated a respect for the incredibly precious resources that he was used to and the disciplines that he had to adhere to. In the last 28 years of my MV programming I have never recalled having to be so anal as to perform such a lower-level observation for such an unmeasurable improvement. I could never count the number of times I typed the word BASIC I don't advocate sloppy programming or poor file design techniques. But with today's incredibly fast, fast, fast, fast and large, large, large systems, I believe there is also an unmeasurable element to over analyzing the tweaking. While it's easy to take an academic approach to the micro-managing of each CPU cycle and disc read, at some time it just really doesn't matter. Granted if you create a file with a mod of 1 and try to cram 10 MB into it, the system will accomodate this gross error and reward you with a slower file. But if the file was created with a mod of 1001 (sic) and it should have been 1401 (sic), how measurably different is the delay with the 40% undersized file of 1001? (PS for those who don't know, (sic) means example. Don't reply with lessons on prime numbers. It's just an example). I tried this years ago on a single user system (multiple user systems are much harder to truly measure with the other user's affect). IIRC I had a file that needed a 3001 (sic) modulo and I loaded it from tape into different file sizes ranging from 11, 101, the calculated 3001 and even 15001. I performed some crude timing tests, ie sorting, read/re-write etc and came away with the impression that it really doesn't matter unless it's tremendously undersized. The 11 size file was the poorest but the 101, 501 and 15001 were suprisingly close to the 'preferred' 3001. IIRC even having some non-prime modulos near 3001 and it didn't matter either. I haven't tried this test recently but I can imagine that the results would be quicker but the shot-group would be the same if not tighter. I don't know about U2 systems, but D3 systems have long dropped the separation value in creating files with the assumption of '1'. That closes that chapter on file calculations. I can't imagine justifying the process to analyze and re-analyze this today. Perhaps I'm wrong and someone managing a 10,000 user system will babble about every precious CPU. But for the rest of us it is an entertaining distraction that would be hard to cost-justify. We don't have a 10 MB hard drive system supporting 16 users with 32K of core memory anymore. Today's numbers are downright staggering in the MV world. My 101,1 cents Mark Johnson - Original Message - From: Anthony W. Youngman [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, October 18, 2006 5:06 AM Subject: Re: [U2] VOCLIB and keeping VOC entries Short and Small, IM RM In message [EMAIL PROTECTED], Adrian Merrall [EMAIL PROTECTED] writes And on, and on, until the particular bit of data is found. So... (this being one of the overwhelmingly elegant things about the Pickuverse) this means that in a properly sized hashed file NO MATTER HOW BIG it only takes one disk read to get to any record given a known key. Ask your local Oracle/Sybase/Informix/SQL Server DBA if they can do that. Stand back though, they tend to sputter alot. But won't this only work if your data fits into the modulo that matches your page size? If your data is lumpy and doesn't nicely fit into the page size/file modulo selected you get level 1overflow and more disk IO. The stats I've come across (yes, they're old, they came from Prime) say that PROVIDED Adrian's properly sized caveat is followed, even when you have level 1 overflow and lumpy data, your 1 merely increases to an average of 1.05. In other words, 19 out of 20 attempts still hit first time... Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said
Re: [U2] VOCLIB and keeping VOC entries Short and Small, IM RM
I stand corrected. I've used (sic) for years and no-one has complained. Perhaps they didn't know either. I just don't want someone replying to a post because my editorial example isn't technically correct, prime-wise. In this case, 3001 is prime but I don't want to insure that all the other numbers are prime just for a dissertation. It was for relative difference and an example only. Thanks Mark Johnson - Original Message - From: Jeff Schasny [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, October 19, 2006 12:32 PM Subject: Re: [U2] VOCLIB and keeping VOC entries Short and Small, IM RM Much as I hate to make editorial comments on a very nice writeup, I'd hate for you to go on misusing [sic]. From the wikipedia (and correct as far as I have always known): /*Sic*/ is a Latin /wiki/Latin_language word meaning thus, so, or just as that. In writing, it is italicized and placed within square brackets /wiki/Bracket [/sic/] to indicate that an incorrect or unusual spelling, phrase, or other preceding quoted material is a verbatim http://en.wiktionary.org/wiki/verbatim reproduction of the quoted original and is not a transcription error. This may be used either to show that an uncommon or archaic usage is reported faithfully (for instance, quoting the U.S. Constitution /wiki/U.S._Constitution, The House of Representatives /wiki/House_of_Representatives shall chuse [/sic/] their Speaker...) or to highlight an error, often for the purpose of ridicule or irony (for instance, Dan Quayle /wiki/Dan_Quayle famously changed a student's spelling to 'potatoe /wiki/Potatoe' [/sic/]), or otherwise, to quote accurately whilst maintaining the reputation of the person or organisation quoting its source. In folk etymology /wiki/Folk_etymology, sic is sometimes erroneously thought to be an abbreviation of spelling is correct, same in copy /wiki/Copy_%28written%29, spelled incorrectly, spelling incompetent, said in context, stupid in context, stand incorrect, or spelling intentionally changed, to cite but a few backronyms /wiki/Backronym. Mark Johnson wrote: But if the file was created with a mod of 1001 (sic) and it should have been 1401 (sic), how measurably different is the delay with the 40% undersized file of 1001? (PS for those who don't know, (sic) means example. Don't reply with lessons on prime numbers. It's just an example). [large amounts of stuff trimmed] -- == Jeff Schasny jschasnyATricochetDOTcom == --- 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] VOCLIB and keeping VOC entries Short and Small, IM R M
You're welcome. In another magazine that I write for, I've been labeled The Resident Curmudgeon. I guess my age shows up not believeing (or wanting to believe) things that others may get excited about. Oddly enough I have a brother who writes HTML in Wordpad and despite my suggestions, he's become pretty profecient with it. I guess the same can be said for Jurrasic Pick programmers like myself who have lived 100 years in ED BP ABC with the L22 editor. I now use WED from Accuterm and many on this forum use other modern tools for managing these text files we call programs. Some even use vi as their preferred editor. Using programming tools like SB, GED and the other hamburger helper 4GL's, we are spared from the tedious nature of the generic MV EDitor. On the other hand, many people are still supporting and enhancing systems that were written 10-25 years ago and one could wonder how they could write such sophisticated applications with *only* the L22 editor. The average age of my client's systems is 18 years. plug I am enjoying using Accuterm with its GUI editor for making VB-looking forms on top of the standard MV database and haven't been this excited about an MV product since the creation of the EXECUTE command. Add their Windows Editor WED and all of the connectivity stuff and sell it for $995 for 50 licenses and it's a no brainer. All of my clients (except for those still on Microdata) will be installing Accuterm and I will deliver happiness with the GUI programs. /plug Thanks Mark Johnson - Original Message - From: Ron Sharcott [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, October 19, 2006 12:48 PM Subject: RE: [U2] VOCLIB and keeping VOC entries Short and Small, IM R M I enjoyed reading that and wanted to say thank you. Rapid Application Development (RAD) does not have to be sloppy and quick. If slowed down a touch it can start to include a touch of quality. Often RAD is taken to mean just get it done when really it means roll it out when it can do the job and use prebuilt tools to do the job. Applications that assist RAD can be bloating if used without a watchful eye. Editing HTML in Word is a prime example of that. At the same rate writing 100 pages of HTML using nothing but Notepad is a waste of time. Its all about balance. Thank you again. Ron Sharcott (3635) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Thursday, October 19, 2006 7:50 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] VOCLIB and keeping VOC entries Short and Small, IM RM In observing this thread the words 'page size' caught my eye. In 1978 I remember a much older programmer working with me at Microdata (sic) reading very closely the Basic compiler output generated with the MAP option. Microdata's compiler didn't (doesn't) generate the necessary file helpful with debugging programs automatically so you had to specify with the (M option to generate it. It produced the variable table and laid out the basic code lines as they were spread out over the object code record. I recall him reviewing a FOR...NEXT loop that had the FOR part in one frame and the NEXT part in another and he was spending time trying to put compilable code (not comments) in front of the FOR section in the hope that the both the FOR and NEXT were in the same frame. This may have had the moniker Frame Faulting. Mainframes called this a Core Dump. So he would code and compile and review, code and compile and review until he felt it was right. Perhaps his age at the time (50?) indicated a respect for the incredibly precious resources that he was used to and the disciplines that he had to adhere to. In the last 28 years of my MV programming I have never recalled having to be so anal as to perform such a lower-level observation for such an unmeasurable improvement. I could never count the number of times I typed the word BASIC I don't advocate sloppy programming or poor file design techniques. But with today's incredibly fast, fast, fast, fast and large, large, large systems, I believe there is also an unmeasurable element to over analyzing the tweaking. While it's easy to take an academic approach to the micro-managing of each CPU cycle and disc read, at some time it just really doesn't matter. Granted if you create a file with a mod of 1 and try to cram 10 MB into it, the system will accomodate this gross error and reward you with a slower file. But if the file was created with a mod of 1001 (sic) and it should have been 1401 (sic), how measurably different is the delay with the 40% undersized file of 1001? (PS for those who don't know, (sic) means example. Don't reply with lessons on prime numbers. It's just an example). I tried this years ago on a single user system (multiple user systems are much harder to truly measure with the other user's affect). IIRC I had a file that needed a 3001 (sic
Re: Re: [U2] VOCLIB and keeping VOC entries Short and Small, IM RM
I had such an occurrence where someone was creating an additional data-level file on an existing dict/data file set. So he typed: CREATE-FILE DATA EXISTINGFILE NEWDATALEVEL 1,1 1,1 assuming that the 1,1 pertained to the dict and the 1,1 applied to the new datalevel that they were creating. The 1,1 was ignored While D3 and native systems reply with the base and mod frame numbers of the new file, it wasn't read by the programmer. But when the new datalevel file was put into production, the client called in a few weeks as it got hammered. There was some egg on the face of that programmer, especially reviewing the TCL-STACK file (big brother) for the typed command. FYI Mark Johnson - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, October 19, 2006 11:51 AM Subject: RE: Re: [U2] VOCLIB and keeping VOC entries Short and Small, IM RM Mark Today's numbers are downright staggering in the MV world. A couple of weeks ago I had to repair a failed RedBack implementation. The garbage collection wasn't running, and so their state file had grown to being a mere 15,000 times undersized. Strangely enough, this eventually led to corruption and decay. But it must have been running a long while before it did. and, yes, I left the tuning manual and garbage collection instructions on the guy's desk. grin Brian --- 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] VOCLIB and keeping VOC entries Short and Small
Steve's suggestions are right on the money and have been for the past 30 years. Virtually every one of my client's system, regardless of flavor, has had this form of clutter. Oftentimes it's just as simple as copying the VOC item to the VOCLIB (MD to PROCLIB etc) and changing the VOC item to reference the VOCLIB item. The VOC (MD) is rarely SELECTED but since all new items added to the VOC are appended to the group, the 'lumpy' effect may make certain items appear 'slower'. My 1 cent. - Original Message - From: Stephen O'Neal [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Sunday, October 15, 2006 5:30 PM Subject: [U2] VOCLIB and keeping VOC entries Short and Small The intent of VOCLIB is to reduce the VOC size. One idea for speed is to keep your VOC very small. This way the search for all items is faster. For some VOC items, like 'PA'ragrpahs and 'PR'ocs can be sizable (like 1,000's of characters). This causes Lumpy records. (To be shocked, sometime LIST VOC SIZE.) So, the intent was for people to make 'R'emote pointers and to put the larger sized items in the VOCLIB. Yes, if you do this, your system will run faster. Example: ED VOC LARGE.PARAGRAPH 1) R 2) VOCLIB 3) LARGE.PARAGRAPH ED VOCLIB LARGE.PARAGRAPH 1) PA Some really large description of the paragraph 2) SELECT 3) LIST... While you are at it, you should check your VOC for overflow, which will also slow down your system. For your education, Steve Stephen M. O'Neal Lab Services Sales for U2 IBM SWG Information Management Lab Services Anthony W. Youngman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2006 01:17 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject Re: [U2][UV] UO.NET Help In message [EMAIL PROTECTED], Nick Cipollina [EMAIL PROTECTED] writes Paul, Thank you very much. Turns out we were missing the VOCLIB file. This is a very useful piece of information. Is this documented anywhere? Thanks, Nick Cipollina I've got a feeling VOCLIB isn't created automatically. It's a Pr1me-ism, and doesn't contain anything by default, I don't think, so it's odd that it's required. That said, I've never seen an INFORMATION account without it, and I think the ODBC stuff originally came from Prime, so it's probably a historic hangover. Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- 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][UD] UniQuery SELECT WITH Limits
Just because I respect the past and can recognize the perpetual changing of the 'state of the art' doesn't mean I live in the past. Your comments are unwelcome, short-sighted and clearly illustrate a complete lack of knowledge of what I know and where I've been. I praised F correlatives in the past tense and they were certainly an incredible asset in their time when compared to the prevailing databases. What we could accomplish in a single, albeit cryptic, line of code took other systems a whole lot more lines of code and other very expensive resources. The very fact that you don't have to endure F correlatives today is a tribute to their help in building up the overall Pick/MV marketplace that you currently enjoy. Without them, Pick would have been just another VSAM/ISAM or other flat, processor heavy database and English (sic) would never have grown to be the powerful tool it is. Everytime, and I mean every time you are at TCL and type an English query you should thank F correlatives. My present client base includes MV systems all the way from early 1980's-era Microdatas all the way to U2, D3, Mvbase and a bunch in between, not to mention many non-MV technologies. My duration in the MV world allows me to comment with first-hand experience on possibly the full extent of its time period and all of its milestones.. Thanks for your comments and I will continue to defend the F correlative for its contributions. Mark Johnson - Original Message - From: Bruce Nichol [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, October 12, 2006 11:13 PM Subject: Re: [U2][UD] UniQuery SELECT WITH Limits At 08:30 26/09/06 -0400, you wrote: Don't pick on the F correlatives as they were the state of the art back then and got us where we are today. And so were valve radios and kerosene fridges.Whilst there is a resurgence of valve amplifiers for audiophiles the rest of us great unwashed can do without either having them or knowing anything about them especially when there is a progression path. Catch up with the rest of the world.Your customer will ultimately thank you unless you want to go down in history as the last person defending F-correlatives. There really are times when the tripe still propounded for vanilla Pick is just not the answer in U2.. 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. Version: 7.5.427 / Virus Database: 268.13.3/473 - Release Date: 12/10/06 16:15 --- 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] Command that is the opposite of MATPARSE.
Does that eliminate MATBUILD? - Original Message - From: Dave Walker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, October 03, 2006 8:39 AM Subject: RE: [U2] Command that is the opposite of MATPARSE. They work in Unidata... -- Dave Walker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bill Haskett Sent: Monday, October 02, 2006 8:35 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Command that is the opposite of MATPARSE. Mark: I don't believe this works in the U2 products. All those little niceties of D3 are not considered essential in U2. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Monday, October 02, 2006 4:14 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Command that is the opposite of MATPARSE. I don't know if this would work on U2 but as I was trying to remember this for D3, I simply equated them as such: DIM A(100) MATREAD A FROM FILE, ID ELSE STOP B=A PRINT A(49), B49 My .001 cents. Mark Johnson - Original Message - From: Kevin King [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, October 02, 2006 6:53 PM Subject: RE: [U2] Command that is the opposite of MATPARSE. Just curious - Does anyone know if there is a command/function that will do just the opposite (of MATPARSE)? MATBUILD -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- 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] Command that is the opposite of MATPARSE.
I don't know if this would work on U2 but as I was trying to remember this for D3, I simply equated them as such: DIM A(100) MATREAD A FROM FILE, ID ELSE STOP B=A PRINT A(49), B49 My .001 cents. Mark Johnson - Original Message - From: Kevin King [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, October 02, 2006 6:53 PM Subject: RE: [U2] Command that is the opposite of MATPARSE. Just curious - Does anyone know if there is a command/function that will do just the opposite (of MATPARSE)? MATBUILD -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- 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][UD] UniQuery SELECT WITH Limits
I'm curious as well with so many WITH's. Please entertain us with the specifics of your query. Performance wise, this offers the following question. If the first WITH fails and it's a bunch of ANDed WITH's, does the system continue to gather the other pass/fails despite the first failing and the rest are moot. I've streamlined many queries by dividing and conquering. Especially if some of the fields are heavier than the others, ie correlatives or translates. Not to mention any indexed fields. Thanks Mark Johnson - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, September 25, 2006 4:45 PM Subject: Re: [U2][UD] UniQuery SELECT WITH Limits Not to second guess, but anytime someone says something about hitting one of the limits, I have to think there is a better way of doing what you want to do. Why don't you give us a little more detail as to what you are trying to do? Bruce M Neylon Health Care Management Group jjuser ud2 [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/25/2006 03:21 PM Please respond to u2-users@listserver.u2ug.org To u2-users@listserver.u2ug.org cc Subject [U2][UD] UniQuery SELECT WITH Limits Hi hello how are ya :) Limits. The documentation I have for Using UniQuery says that you can only have 120 different with fields in a SELECT statement. I'm trying to select a series of non-contiguous numbers at random intervals to generate a select list. There are 251 of these numbers. Do I have to split the list into three different groups in order to generate three different lists that I can do a SAVE.LIST on? What's the best way to go about getting these select lists? --- 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][UD] UniQuery SELECT WITH Limits
I have another thought on this many WITH's. As a filter (I'm sure it's pretty much all AND's as mixing AND's and OR's tends to be misleading), and you're wanting a single list, perhaps just write a program to go through the file and challenge everything sequentially. If it passes all of the 200 or so tests, retain the item-id either in a local variable or writing to a temp file. As soon as it fails on any test go to the next item-id. Then either WRITELIST the local variable or SELECT the temp file to get your list of quailfied records. My 2 cents Mark Johnson P.S. Something tells me that your current TCL SELECT statement isn't generated by hand or run in a PROC and that it's being created by a data/basic program. Thus, by the time you assemble the TCL statement, you could be testing the records. - Original Message - From: Richard Brown [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, September 25, 2006 7:04 PM Subject: Re: [U2][UD] UniQuery SELECT WITH Limits A couple of thoughts. If you do SELECT FILENAME WITH FIELD = 123456479 does that count as multiple WITHs? You could setup a dict item that looks at a certain position in the field then select on that. D3UD/U2 FIELD.NAMEFIELD.NAME 1 A 1 I 2 0 2 @ID[3,1] 3 3 4 4 5 5 1L 6 6 S 7 8 T3,1 R 1 SELECT FILENAME WITH FIELD.NAME = 1 Will get all the items that have a 1 in the 3rd position of the ID - Original Message - From: jjuser ud2 [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, September 25, 2006 3:21 PM Subject: [U2][UD] UniQuery SELECT WITH Limits Hi hello how are ya :) Limits. The documentation I have for Using UniQuery says that you can only have 120 different with fields in a SELECT statement. I'm trying to select a series of non-contiguous numbers at random intervals to generate a select list. There are 251 of these numbers. Do I have to split the list into three different groups in order to generate three different lists that I can do a SAVE.LIST on? What's the best way to go about getting these select lists? When I execute the LIMIT command in UniData, it tells me: U_MAXFNAME: File name limit = 198. U_NAMESZ:Record id(key) size = 126. U_SELEMAX: Number of select list = 10. U_MAXDATA: Number of DATA statement = 500. U_HEADSZ:HEADER/FOOTER length = 2120. U_MAXHASHTYPES: Number of hash functions = 3. U_MAXSORT: Number of sort fields(BY...) in LIST = 20. U_MAXWITH: WITH stack size = 256. U_MAXWHEN: WHEN stack size = 60. U_MAXCAL:Number of SUM+AVG+PCT+CAL in LIST = 54. U_MAXBREAK: Number of BREAK.ON+BREAK.SUP in LIST = 15. U_MAXLIST: Number of attribute names in LIST = 999. U_LINESZ:Page width in printing =272. U_PARASIZE: Paragraph name and its parameter size = 256. U_LPCMD: System spooler name = NT Spooler. U_MAXPROMPT: Number of prompts allowed in paragraph = 60. U_FSIZE: Dictionary field name size =31. U_MAXVALUE: Number of values WHEN can handle = 10240. U_MAXBYEXPVAL: Number of values BY.EXP can handle = 10240. U_SENTLEN: Maximum sentence length = 9247. U_PROCBUFSZ: Proc buffer size = 4095. U_NIDES: Maximum number of virtual fields in query= 256. Thanks! :) --- 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] [UV] TEXT box subroutine
Just sharing a nice feature of Accuterm. Good Luck Mark Johnson - Original Message - From: Bob Woodward [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, September 18, 2006 11:37 AM Subject: RE: [U2] [UV] TEXT box subroutine Thanks, Mark, but changing term emulator software is not an option. This needs to work in Dynamic Connect. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Sunday, September 17, 2006 9:20 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] TEXT box subroutine Accuterm has a TXTBOX subroutine that can be immediately added anywhere from within any green screen program for the desired answer. I didn't look specifically, but I'm guessing that it has a multi-line counterpart. Thanks. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] TEXT box subroutine
I'm interested in hearing why accuterm is so bad and why Openinsight is preferred. One of the consultants I work with uses both and prefers accuterm. I'm liking accuterm the more I use it for GUI and have presently concluded that OI is a database instead of a front end/emulator. It's easier to implement a new emulator like accuterm with its features than a new database conversion. Thanks Mark Johnson - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, September 15, 2006 9:36 AM Subject: RE: [U2] [UV] TEXT box subroutine Accuterm, as we have found it, is a horrible tool for gui. You should have check out OpenInsight. Real windows tool. But then eveyone has their favorites. DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: Re: [U2] [UV] TEXT box subroutine From: Martin Phillips [EMAIL PROTECTED] Date: Thu, September 14, 2006 9:32 am To: u2-users@listserver.u2ug.org Hi Bob, Have you looked at AccuTerm as an alternative to Dynamic Connect. The associated GUI library is amazing. We were recently involved in conversion of a UniVerse application from character mode to GUI mode complete with mouse support and the major parts of the job took two people less than three days. Martin Phillips Ladybridge Systems 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] TEXT box subroutine
Accuterm has a TXTBOX subroutine that can be immediately added anywhere from within any green screen program for the desired answer. I didn't look specifically, but I'm guessing that it has a multi-line counterpart. Thanks. - Original Message - From: Bob Woodward [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, September 15, 2006 4:46 PM Subject: RE: [U2] [UV] TEXT box subroutine I wasn't implying I was looking for a gui tool. Maybe I phrased it wrong. What I'm trying to accomplish is a green screen solution where I'd be more than happy to re-display my underlying form and data after I've allowed the user to modify a lengthy description field. My intent is to only display the first couple of lines but when the user wants to edit that description, I display a box that they can move up and down, left and right, insert and delete then either save the changes or reset back to the original contents of the field. The solutions I've been given, thus far, all look promising. I'm currently checking each to see how I could customize them to what my specific needs are. Again, thanks to everyone on the list! BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dianne Ackerman Sent: Friday, September 15, 2006 12:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] TEXT box subroutine Wow, it's really something to say it's a horrible tool for gui without any explanation! We LOVE LOVE LOVE the Accuterm gui and switched our development from OpenInsight to Accuterm and have had nothing but success! -Dianne [EMAIL PROTECTED] wrote: Accuterm, as we have found it, is a horrible tool for gui. You should have check out OpenInsight. Real windows tool. But then eveyone has their favorites. DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: Re: [U2] [UV] TEXT box subroutine From: Martin Phillips [EMAIL PROTECTED] Date: Thu, September 14, 2006 9:32 am To: u2-users@listserver.u2ug.org Hi Bob, Have you looked at AccuTerm as an alternative to Dynamic Connect. The associated GUI library is amazing. We were recently involved in conversion of a UniVerse application from character mode to GUI mode complete with mouse support and the major parts of the job took two people less than three days. Martin Phillips Ladybridge Systems 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] TEXT box subroutine
Here goes. Accuterm is incredibly affordable. $1,000 for 50 licenses. That's great to begin with. Second, for us programmers: WED is a great editor marrying the MS feel of Notepad with a MV-oriented editor. Indenting, multi-windows, cut paste, label finding, color coding, opening subordinate programs etc. Third, GED (the GUI designer) creates regular mv subroutines that can be incorporated in an existing green screen apps and menus. 2 of my clients mandate new development in GED and to back-develop existing programs when time is available. IIRC, there is no magic pill to convert a green screen app to a gui app. Key word is CONVERT instead of re-write. The ability to manage a multi-year transition with GED/green screens is very appealing to end user environments instead of VAR environments. My 2 cents. Mark Johnson - Original Message - From: IT-Laure Hansen [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, September 15, 2006 4:59 PM Subject: RE: [U2] [UV] TEXT box subroutine I would really like it if all parties could give arguments to support their opinion of it: is it solid? Satisfying to the users? Supported or not on certain platforms? Working best or worst with certain types of programs? etc. I would help me and hopefully others cut through some time and efforts. Thanks in advance. Laure Hansen, City of Redwood City Information Technology www.redwoodcity.org 1017 Middlefield Road Redwood City, CA 94063 Tel: 650-780-7087 Fax: 650-556-9204 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dianne Ackerman Sent: Friday, September 15, 2006 12:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] TEXT box subroutine Wow, it's really something to say it's a horrible tool for gui without any explanation! We LOVE LOVE LOVE the Accuterm gui and switched our development from OpenInsight to Accuterm and have had nothing but success! -Dianne [EMAIL PROTECTED] wrote: Accuterm, as we have found it, is a horrible tool for gui. You should have check out OpenInsight. Real windows tool. But then eveyone has their favorites. DSig David Tod Sigafoos SigsSolutions, Inc. Original Message Subject: Re: [U2] [UV] TEXT box subroutine From: Martin Phillips [EMAIL PROTECTED] Date: Thu, September 14, 2006 9:32 am To: u2-users@listserver.u2ug.org Hi Bob, Have you looked at AccuTerm as an alternative to Dynamic Connect. The associated GUI library is amazing. We were recently involved in conversion of a UniVerse application from character mode to GUI mode complete with mouse support and the major parts of the job took two people less than three days. Martin Phillips Ladybridge Systems 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Any have a Sun Sparc Box
Look up Bob Wyatt from Sun/Unidata. He knows virtually everything about that implementation. - Original Message - From: george r smith [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, September 14, 2006 12:04 PM Subject: [U2] Any have a Sun Sparc Box All, Anyone have any experience with Sun Sparc boxes as development boxes for Unidata. Anyone heard if IBM might certify Unidata on the Solaris AMD boxes. thanks grs --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] TEXT box subroutine
GED is a great program. 2 of my clients have dictated that all new development is in GED. It's a wonderful marriage between VB forms and our beloved pick database. Plus, Peter Schellenbach should get some form of Nobel Peace Prize for WED as well. My 1 cent. Mark Johnson - Original Message - From: Martin Phillips [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, September 14, 2006 12:32 PM Subject: Re: [U2] [UV] TEXT box subroutine Hi Bob, Have you looked at AccuTerm as an alternative to Dynamic Connect. The associated GUI library is amazing. We were recently involved in conversion of a UniVerse application from character mode to GUI mode complete with mouse support and the major parts of the job took two people less than three days. Martin Phillips Ladybridge Systems 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/
Re: [U2] Time/Date as a single number
I worked on a Security Monitoring system for years and the best date/time schema is (DATE()*86400)+TIME() It's incredibly useful when detecting time differences between 2 times that may or may not cross a day boundary. It was never meant to be an alternative to the DATE() and TIME() functions alone. The DATE()-1 concept would mean that you're trying to replace the DATE() method and you're correct. With the method mentioned above, it really doesn't matter as long as its consistent because the date expressions. During my time when using the method above, it never was a replacement for the actual date and time of an occurrence. It was simply used to derive the time 'difference' as many signals, alarms and incidents in the security monitoring business are time sensitive, ie received 2 signals within 15 minutes, which could obviously cross midnight. My 1 cent Mark Johnson - Original Message - From: Kevin King [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, September 12, 2006 4:45 PM Subject: RE: [U2] Time/Date as a single number My method is take date()*86400+time() Is the goal to track a chronology via a single field? If so, I'd say your calulation is close. Wouldn't it be: ((DATE() - 1) * 86500) + TIME() (...as the number of days elapsed is today - 1, not today.) Regardless, you're right that the date could get humongous. For the cycles you're going through to do this calculation it would be a small step to convert it into and out of any other base to compress and decompress the bytes. The foundational question, however, is one of context. Why do you need this? That answer may limit or expand your options. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com ** Check out scheduled Connect! training courses at http://www.PrecisOnline.com/train.html. --- 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] Using DICT items in basic program
Thank you Brian for your observations. I'm of the Jurrasic Pick era with 95% of my world being mv and the other 5% being MS Access. I am enjoying the GUI development environment of Accuterm and may convert upcoming MS clients to that GUI front end on top of D3 as the client doesn't care that much about back end databases when it has a nice front end. I've inherited many, many systems (45 in the last 10 years alone) with their incredibly diverse and over-written methods for many, many tasks. Certainly I've not seen everything but I've seen a ton of programming of which I can extract the best methods to continuously add to my own personal library of what's effecient. I can also ignore the less intelligent ineffeciencies. My download utility's purpose is for the one-time project. It's pretty much a TCL only command issued typically by the only cook in the kitchen, me. I've written many portable subs that I install at all of my clients for their recurring needs. While there could be some extension of unidata/universe that allows direct writing to a PC folder, most implementations don't have it that easy. The native ones don't have it at all. Thus I develop my subroutines and tweak them per mv flavour on which they're installed. Thus whether it's UD/UV, D3, Mvbase, Microdata or native systems, DOWNLOAD works the same as well as most of my subroutines. If I were to add DOWNLOAD to a proc or a program, my experience would prevent me from performing 5 million executes and approach the solution with a more effecient method. I have subs that easily make CSV's or simple HTML's and have automated many import/export facilities including unix-ftp, MS-ftp, VB scripts and other contemporary attachments. Thus, if my clients were to convert to other version of MV, only my subs need be changed and not the local changes in dozens if not hundreds of programs. One sub that answered the original post is called GET.DICT(FILE, ID, VAL) which has the embedded English sentence mentioned earlier. I use it in DOWNLOAD as well as I've put it in regular CUSTOMER maintenance or other single item programs to get the results of a complex expression instead of writing the same code again. If the logic is complex or has the possibility of being changed, business-wise, changing the dict reference causes its use elsewhere to be changed as well. One thing I miss in D3 that I enjoy in UD/UV is the more advanced called subs from dict items. D3's versions can only pass (return) one parameter in the parameter string. It has access (ACCESS()) to the item-id, file and record but only once you're in the sub. It also gets a little funky when returning multi-valued values. The joy in the UD/UV called subs is that the sub being called doesn't care if it's called from English or a basic program. Thus, the intelligence can be shared whereby in D3 is has to be replicated or managed in a more klugy way. Score one for U2. My 3 cents. Mark Johnson - Original Message - From: Brian Leach [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, August 03, 2006 9:24 AM Subject: RE: [U2] Using DICT items in basic program Tim/Mark You both make good points. Mark was responding to a specific requirement (how to get a single field for a single record) with one working and largely cross platform solution. Obviously getting a tranch of data requires a different solution. I don't think Mark was seriously suggesting that a million executes is a way to go. Personally I would now look towards XML as that seems to be the best current option for integrating the enquiry and development languages - finally something native to close that gap in the PICK model - though in the past I have used everything from REFORMAT (slow but predicatable) to creating compound I Descriptors of the form: CONVERT(@FM:@VM:@SVM,CHAR(1):CHAR(2):CHAR(3),field1:@FM:field2:@FM ...) etc and doing a SELECT .. SAVING that descriptor. Each ReadNext then gets an entire row - just CONVERT() the delimiters back again - and the result is extremely fast. Doesn't work well with WHEN clauses though - but then few things really do :( Tim's point about DOWNLOAD does have some merit. But Mark is an old pro (sorry, forgive the 'old' bit ! ) and I'm sure he writes his utilities in a way that other developers can work out what they do grin. Calling a utility without looking to see how it works first - well that's just lazy. And it's not just MV that will screw up in those cases! You wouldn't expect to call a SQL Server or Oracle stored procedure without some DBA's approval, would you? Brian --- 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] Using DICT items in basic program
I am fully aware of the possibility of 5 executes for 1 million records
totalling 5 million executes.
Anyone can create an example of extremes to invalidate any suggestion. My
example was to acquire the results of a dict item within basic, one of those
missing elements that my sub can handle.
If I were intending to process 5 million records as you would suggest, I
would write a simple program to create the csv's. I create many of these as
programs for their recurring use. I use download for the one-shot simple
projects.
Besides, so what if it did 5 million executes. These systems can handle it.
Time or processor consumption wasn't an issue in the original request
My 1 cent
Mark Johnson
- Original Message -
From: Timothy Snyder [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Thursday, August 31, 2006 9:57 PM
Subject: Re: [U2] Using DICT items in basic program
[EMAIL PROTECTED] wrote on 08/31/2006 07:03:29 PM:
The magic is to take the TCL statement, derive the filename (CUSTOMER)
and
using READNEXT, acquire each of the item id's from the SSELECT
statement.
Then I generate very tiny English statements of the form:
EXECUTE LIST FILE ID NAME ID-SUPP COL-HDR-SUPP {any other necessary
suppressors} CAPTURING X
If I'm reading this correctly, you're performing multiple executes for
each record in the file. In the example you provided, you would be
performing one execute each for NAME, CSZ, PHONE, CONTACT, and
AGED.BALANCE. If you're processing a million records, that means you'll
be performing FIVE-MILLION executes!!!
Maybe I've misunderstood what you're doing. But if not, I don't recommend
this approach. The overhead of performing that many executes is
staggering. I had a customer that had a process that was running in eight
hours, and they desperately wanted to get it down to four hours. It was
consuming an entire CPU and imposing significant I/O wait times that
impacted system-wide performance. I found where the program was spending
most of its time and CPU cycles - it was in a routine that was performing
executes to locate a value within an index and read through that. I
changed it to eliminate the executes and use intrinsic basic functions
instead - nothing else was changed. It went down to twenty minutes - much
better than they had hoped for. CPU and disk consumption became
insignificant. Executes are a wonderful thing, but they are very
expensive operations when performed many times. By adding the capturing
clause, you're adding even more overhead.
---
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] Using DICT items in basic program
I've created a utility that allows me to process an English statement
(output columns only, the select and sort are done prior) to produce a
free-form CSV.
SSELECT CUSTOMER WITH STATE = NJ AND WITH AGED.BALANCE GT 100
DOWNLOAD CUSTOMER NAME CSZ PHONE CONTACT AGED.BALANCE (C:\FOLDER\ABC.CSV
Thus, my download utility will parse the sentence and derive the values for
the output dict items.
The magic is to take the TCL statement, derive the filename (CUSTOMER) and
using READNEXT, acquire each of the item id's from the SSELECT statement.
Then I generate very tiny English statements of the form:
EXECUTE LIST FILE ID NAME ID-SUPP COL-HDR-SUPP {any other necessary
suppressors} CAPTURING X
and viola, the variable X contains the single row, single column value of
that customer's NAME.
So your request is a variant of just processing a specific file with one or
more ID's for one field. Using English allows the magic of the correlatives
to dothe work so you don't have to re-write anything.
I've implemented this in Ud/Uv, D3, Mvbase. It's too cumbersome on Microdata
and mvbase has a quirk where the CAPTURING doesn't inhibit the screen output
so it gets a little busy.
My 2 cents.
Mark Johnson
- Original Message -
From: Bob Woodward [EMAIL PROTECTED]
To: U2-Users List u2-users@listserver.u2ug.org
Sent: Wednesday, August 30, 2006 6:21 PM
Subject: [U2] Using DICT items in basic program
Hi folks,
I'm trying to set up a general use utility and what I'd like to do is to
be able to call this utility, passing it an open file handle, a couple
other parameters plus one that could be used to specify a dict entry
name, not a field number. The catch is I'd like to use the dict entry
regardless of what type of definition it is. Obviously there would be
some limits but the general definition is that the dict item ultimately
points to a piece of data. An example would be I would want to use a
data position field like CUST.NUM in the INVOICE file. I'd also want to
be able to use something like CUST.NAME in the INVOICE file which would
be a pointer to the CUSTOMER file's NAME field. The utility would use
READ or maybe XLATE to obtain the desired information. I looked at
ITYPE() but I'm not sure that's going to get me what I'm looking for.
In AREV it was simply using the {} brackets.
TIA
BobW
---
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] Fwd: Ultimate users
I spent 13 years managing a 100 user Microdata (1981-1994) for a large ($85M) industrial pipe, valve fitting (plumbing) wholesaler using custom software from me and programmers prior. Being in NJ, (Ultimate's HQ roughly 15 miles away), we were clearly in their turf for this business. During the mid-late 1980's, Ultimate propogated the system SHIMS (Supply House Inventory Management System) and got a great deal of sales addressing this market specifically. It wasn't until I left in 1994 to then realize that SHIMS was a derivitave of the Microdata Results system. I obtained 6 SHIMS clients from 1987-1993 and later had 5 Results clients and they were incredibly similar in their data structures. This was probably based on both of their origins being 4 Gary Rd and the split-up of May 1979 when Ted Sabarese got the boot. Perhaps no-one checked the outgoing briefcases for file-save tapes. BTW, there's another derivitive called IDS (Industrial Data Systems) that's also based on Results. I also had another client using a renamed Results package. Imitation is the sincerest form of flattery? None of my SHIMS clients were on RS6000's. They were all on standard single rack proprietary OS true-Ultimate systems (Honeywells). I only got involved with RS6000's from 1993 through 2003. Slowly during the 1990's my SHIMS clients were absorbed by larger, more national plumbing wholesalers, thus dead-ending the Pick systems. Now I have zero. I still have 4 Results clients. I remained in contact with some of the SHIMS guys who stuck around (more business than IT guys) with one having switched to Eclipse. Based on his info, I didn't care that much for Eclipse as it seemed to be yet again another Pick 4GL that, as an outside consultant, I can't justify specializing in. I don't know if SHIMS is still around. I know that Results died with Microdata (et al) but the code still lingers with 4 of my clients. My 2 cents. Mark Johnson - Original Message - From: Clifton Oliver [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Saturday, August 12, 2006 11:46 AM Subject: [U2] Fwd: Ultimate users Posted on behalf of Henry Keultjes. Begin forwarded message: From: Henry Keultjes [EMAIL PROTECTED] Date: August 11, 2006 7:20:27 PM PDT To: Clif Oliver [EMAIL PROTECTED] Subject: Ultimate users Clif: Would you mind posting this to the U2 list? Henry There used to be quite a few plumbing wholesalers on Ultimate on RS/ 6000 machines. I would like to know about any and all of those and what they migrated to, if they are not still on the same system. Henry Keultjes hbkeultjesatearthlinkdotnet Database Scientifics Project http://www.ncolug.org/ppc.htm Mansfield Ohio USA --- 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] FW: Opening
Not to open a can of worms, but what does Good Programming Skills mean? Thanks Mark Johnson - Original Message - From: Allen E. Elwood [EMAIL PROTECTED] To: U2Users u2-users@listserver.u2ug.org; U2Community [EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 2:01 PM Subject: [U2] FW: Opening -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew McLaughlin Sent: Thursday, August 03, 2006 13:18 To: [EMAIL PROTECTED] Subject: [ManageUG2K] Opening Howdy all, First of all, a quick note to let everyone know, I've decided to resign from Shurflo and get back in to full time Java development. Woohoo! :) My last day here is 8/11. Now, my position will be open and we're interested in interviewing a suitable replacement. Anyone with M2K experience and good programming skills is a candidate. The office is located in beautiful Cypress, CA (Orange County). If you or someone else you know is interested, please send resume or CV directly to: [EMAIL PROTECTED] Thanks, Andrew __._,_.___ Messages in this topic (1) Reply (via web post) | Start a new topic Messages | Files | Photos | Links | Database | Polls | Members | Calendar You are receiving Individual Emails Change Delivery Settings Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe Visit Your Group SPONSORED LINKS a.. Business application software b.. Business application development c.. Business application d.. Epicor Yahoo! HotJobs Be Discovered! Employers find you Upload your resume New web site? Drive traffic now. Get your business on Yahoo! search. Y! Messenger Talk it up - free! Call your friends worldwide - free! . __,_._,___ --- 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] RE: [U2C] FW: Opening
Is it In Like Flynn or In Like Flint? - Original Message - From: Allen E. Elwood [EMAIL PROTECTED] To: Eric Armstrong [EMAIL PROTECTED] Cc: U2Users u2-users@listserver.u2ug.org; U2Community [EMAIL PROTECTED] Sent: Thursday, August 10, 2006 2:05 PM Subject: [U2] RE: [U2C] FW: Opening Hi Eric Andy is just a friend that I sent this email on behalf of, and isn't actually a member of this group. By M2K he meant Manage-2000 which is now owned by Epicor. This product has been around since 1978, and at last count had something like 700 menus. Never bothered counting the number of programs but it's probably around 10 to 12 thousand programs/subroutines. http://www.epicor.com/www/products/manufacturing/manage2k/ And on the other subject of 'good programming skills' if anyone here has ever seen one of Andy's programs they would know what he meant. He almost redesigns the language with his custom functions, so if you don't have a good handle on Unidata you might be lost for a month or so. I imagine that if you had 5 to 7 years of Unidata programming you'd be in like Flynn. M2k has a huge number of Utilities but they are fairly easy to learn, so the familiarity with Unidata would be more important, imho... hth, Allen -Original Message- From: Eric Armstrong [mailto:[EMAIL PROTECTED] Sent: Thursday, August 10, 2006 09:19 To: [EMAIL PROTECTED] Subject: FW: [U2C] FW: Opening Andrew, What did you mean by M2K? Did you mean W2K? Eric Armstrong Programmer/Analyst Lobel Financial 714.816.1207 714.995.7012 fax -Original Message- From: Allen E. Elwood [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 09, 2006 11:01 AM To: U2Users; U2Community Subject: [U2C] FW: Opening -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Andrew McLaughlin Sent: Thursday, August 03, 2006 13:18 To: [EMAIL PROTECTED] Subject: [ManageUG2K] Opening Howdy all, First of all, a quick note to let everyone know, I've decided to resign from Shurflo and get back in to full time Java development. Woohoo! :) My last day here is 8/11. Now, my position will be open and we're interested in interviewing a suitable replacement. Anyone with M2K experience and good programming skills is a candidate. The office is located in beautiful Cypress, CA (Orange County). If you or someone else you know is interested, please send resume or CV directly to: [EMAIL PROTECTED] Thanks, Andrew __._,_.___ Messages in this topic (1) Reply (via web post) | Start a new topic Messages | Files | Photos | Links | Database | Polls | Members | Calendar You are receiving Individual Emails Change Delivery Settings Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe Visit Your Group SPONSORED LINKS a.. Business application software b.. Business application development c.. Business application d.. Epicor Yahoo! HotJobs Be Discovered! Employers find you Upload your resume New web site? Drive traffic now. Get your business on Yahoo! search. Y! Messenger Talk it up - free! Call your friends worldwide - free! . __,_._,___ u2-community mailing list [EMAIL PROTECTED] 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] UniData proc manual
Being a Jurrasic Pick PROCtologist, I'm observing this thread and looked at my set of UD manuals. I didn't see anything for Proc. Perhaps as a job control language, its functions were replaced with the advent of the EXECUTE/PERFORM commands or paragraphs. I lived through the introduction of true PQN proc in the late 1970's from Microdata and their tangent was to further enhance proc with better buffer management etc. The other implementations developed EXECUTE and their flavors of MV. As I support both now, ie Microdata, U2, D3, native and others, I can appreciate the wrong turn Microdata did by enhancing PROC instead of BASIC. Perhaps the absense of the proc manuals for UD is the grandfather effect. They will support it but not endorse it. Granted, now-a-days, everyone can manage their apps through Basic and I can't recall either a command that works only in PROC and not Basic. Sure, there were some tricky user-exits in Proc but they existed as a work-around given the need to have all criteria-specific Select statements outside of Basic. I'm glad that I'm well versed in both PQ and PQN styles of Proc as I'm not in a position to re-write my clients' apps just because they're old-school. Until the compiler (processer) ceases to process Proc, I'll keep those balls rolling. My 2 cents Mark Johnson P.S. I'm glad that UD supports PQN procs. I've seen conversions to Microdata to D3 and they're a bit messy. - Original Message - From: John Jenkins [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, August 09, 2006 7:14 AM Subject: RE: [U2] UniData proc manual I've used PROC happily and consistently on UniData for ages - despite gibes from some colleagues - ;-' All the great toys : Buffer subscripts, Select buffers, file buffers, etc (and no - no manual) - I have always worked from memory, but used the ROS manuals to learn it in the past. I also remember writing a quick (basic but complete) Ledger system, in (PQN)PROC... and no, it wasn't my choice - it was also not a good idea - but it was mandated and it did work. It just shows you what you CAN do if you have to (but don't do this at home kiddies). Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 08 August 2006 17:50 To: U2 Subject: [U2] Unidata proc manual Has anyone ever seen a unidata proc manual? I can't find any reference, other than some information on user exits -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.10.7/411 - Release Date: 8/7/2006 --- 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] FOLD can mutilate {Unclassified}
Ding, Ding, Ding, Ding. We have a winner.
- Original Message -
From: Derek M. Falkner [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Wednesday, May 31, 2006 12:39 AM
Subject: RE: [U2] FOLD can mutilate {Unclassified}
We used to use the Hollerith code. That was after we changed from 7-track
paper tape - I was quite good at making corrections to that.
Derek Falkner
Kingston, Ontario, Canada
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson
Sent: May 30, 2006 11:26 PM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] FOLD can mutilate {Unclassified}
Trivia Question:
What's the name of the pattern (language) used for the traditional 80
column
IBM punch cards.
My 2 cents.
---
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] FOLD can mutilate {Unclassified}
Trivia Question: What's the name of the pattern (language) used for the traditional 80 column IBM punch cards. My 2 cents. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Multiple Data Files
Control files tend to be a hodge-podge of miscellaneous counters and other 'control' values. There tends not to be a DICT of a CONTROL file as the data is pretty inconsistent. Multiple Data Levels are pretty useful as otherwise indicated. Only drawback is when deleting the file, all the data levels go bye-bye and you may not want all to be deleted and thus manage separately. Multiple data structures within one data file is pretty much a pain in the ass. The Results Distribution system has the PRODUCT file containing 2 separate files structures, the Product Master record with the generic description, classes, weights etc and the many Warehouse records showing the on-hands and other transactional information per warehouse. I've been dealing with Results for over 20 years and I truly wish it weren't written that way. I worked with a stolen version of Results called IDS that separated it and was a lot cleaner. I worked briefly with another stolen version called SHIMS and it was combined. The trouble is that rarely are you wanting all Master and Warehouse records at once. You're either selecting Master or Warehouse records and every English request must contain AND WITH WHSE or AND WITH NO WHSE to differentiate between them. Add to the Basic selects having to separate and it's not been a good idea. I'm just sharing my opinion on primary combined files. One application, SAS for HVAC Servicing, has all of the pesky files like STATES, Salesman, Technicians, Vehicles, Tax Codes etc in one file with the primary key having a prefix of ST, SM, TE, VE, TX etc. Since that app has a whole lot of transactional data files, having these static files in one 'file' sorta makes sense. My 2 sense. Mark Johnson - Original Message - From: Bob Woodward [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, May 16, 2006 7:04 PM Subject: RE: [U2] Multiple Data Files If you are meaning multiple data record structures inside of a single file then for me, it's a lot more manageable to keep things like control records in a single file/table than to have many files/tables with only one or a few records/rows. If this is not what you mean then your question has me totally confused. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ron Hutchings Sent: Tuesday, May 16, 2006 2:33 PM To: u2-users@listserver.u2ug.org Subject: [U2] Multiple Data Files I came to the Pick world by way fo Prime Information through Universe with the Prime Flavor. I am currently working on an implementation of Universe with the Pick flavor. I have come across examples fo Multiple Data Files in the application and am having a difficult time understanding the purpose of this file structure. Can anyone share some practical uses for these file structures? --- 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] OPEN Statement DICT Default
My Bad, I meant [1,2], not the year part. Actually the [1,2] works for both hemispheres if the SET-DATE command is set to either US or European. Thus [1,2] or DM grabs the month and [4,2] or DD grabs the day. Thanks - Original Message - From: Roger Glenfield [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, May 08, 2006 11:05 PM Subject: Re: [U2] OPEN Statement DICT Default You did mean OCONV(DATE(),D2/)[1,2] for month, at least in the Western Hemisphere and [4,2] for the Eastern, right? ;-) Roger Mark Johnson wrote: I specifically remember being taught X=STR(0,5-LEN(X)):X for the 1 concept. Before the % was allowed, a shorter form was X=(0:X)R#5 which I recall using until % came about. On that note, I stole R-10 and C#10 from UD and offered it to D3 hopefully for their next release. Thanks Mark Johnson P.S. Many use OCONV(DATE(),D2/)[7,2] for the month. I think DATE()DM is the shortest way. Puzzle: Illustrate the simplest way to generate Jan thru Dec. --- 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] OPEN Statement DICT Default
That's cool. I owe Pete Colucci for this one: FOR I=1 TO 12 CRT (I*28)DM NEXT I Thanks. - Original Message - From: Womack, Adrian [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, May 08, 2006 11:27 PM Subject: RE: [U2] OPEN Statement DICT Default All the months order (full names): CRT OCONVS(ICONVS(1}2}3}4}5}6}7}8}9}10}11}12,DM),DMAL) Abbreviations: CRT OCONVS(ICONVS(1}2}3}4}5}6}7}8}9}10}11}12,DM),DMAL[3]) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Tuesday, 9 May 2006 10:50 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] OPEN Statement DICT Default I meant all of the months in order. Thanks. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- 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] OPEN Statement DICT Default
Mats: You'll like my (I*28) a little cleaner.
- Original Message -
From: Mats Carlid [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Tuesday, May 09, 2006 2:34 AM
Subject: Re: [U2] OPEN Statement DICT Default
You mean sthg like:
FOR I=31 TO 365 STEP 28
PRINT (I,'DMAL')[1,3]
NEXT I
Tried 'DMBL' but the abbreviations were only two characters.
But printing the actual string is somewhat shorter ...
-- mats
Mark Johnson wrote:
I specifically remember being taught
X=STR(0,5-LEN(X)):X
for the 1 concept.
Before the % was allowed, a shorter form was
X=(0:X)R#5
which I recall using until % came about.
On that note, I stole R-10 and C#10 from UD and offered it to D3
hopefully for their next release.
Thanks
Mark Johnson
P.S. Many use OCONV(DATE(),D2/)[7,2] for the month. I think DATE()DM
is
the shortest way.
Puzzle: Illustrate the simplest way to generate Jan thru Dec.
- Original Message -
From: Roger Glenfield [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Monday, May 08, 2006 9:42 AM
Subject: Re: [U2] OPEN Statement DICT Default
The same programmer that doesn't read the manual does an
EXECUTE instead of a SELECTINDEX, and yes, the index already existed
or
A=STR('0',20-LEN(B)):B
instead of
A=FMT(B,'L%20') or for the Universe Pick/Ideal flavor people in the
crowd A= B'L%20'
or
TODAY=OCONV(DATE(),'D2/')
CONVERT '/' TO @VM IN TODAY
MONTH=TODAY1,2
instead of
MONTH=OCONV(DATE(),'DM')
And yes, I have observed all of the above recently.
;) Just 15 minutes a week to look through the current manuals to find
out about a new option that you might not know existed?
Roger
Louie Bergsagel wrote:
I've never used the null dict indicator. Who ever reads the syntax book
unless a command doesn't work?
*:)*
-- Louie Bergsagel
On 5/5/06, Mark Johnson [EMAIL PROTECTED] wrote:
To All:
Was there ever a real requirement on any prior flavor to have the
typically
non-used DICT portion of the OPEN statement be the set of quotes and a
comma.
I accidentally forgot it in 1978 on a Microdata and it still compiled.
To
this
day I have not seen a reason for the OPEN ,FILE null dict
indicator
and
have not used it since unless I actually want the DICT level.
Just wondering.
Thanks
Mark Johnson
---
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/
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] call sunroutine in command line
I've answered this before with an incredibly simple utility that should be
part of the standard issue TCL commands. It was first printed in Datastream
in the mid 1980's. It's called PRINT
ED MD PRINT
001 PQN
002 HRUN BP PRINT
003 P
ED BP PRINT
001 PROCREAD X ELSE STOP (or use @command and have PRINT be
cataloged)
002 OPEN BP ELSE STOP
003 X-1=END
004 WRITE X ON %PRINT%
005 EXECUTE DECATALOG BP %PRINT%
006 EXECUTE BASIC BP %PRINT%
007 EXECUTE RUN BP %PRINT%
008 END
That's it. Period.
Thus any databasic instructions that can be expressed on a single line of
code can be passed from TCL and be processed. The limits are limitless.
Here's some TCL examples with their implied results
PRINT 5+5
PRINT ; FOR I=1 TO 10 ; PRINT I ; NEXT I
PRINT ; FOR I=1 TO 12 ; PRINT OCONV(I*28,DMA) ; NEXT I ; from previous
thread
PRINT ; OPEN PRODUCT THEN READ REC FROM ABC THEN REC15=REC20 ; WRITE
REC ON ABC
PRINT ; A=1; B=2; C=3; D=4 ; CALL FRED(A,B,C,D,E) ; PRINT E
PRINT ; EXECUTE GET-LIST ABC ; LOOP WHILE READNEXT ID DO ; PRINT ID ;
REPEAT
We're not talking rocket science here. It's just a single line of code that
gets compiled in the program above.
This saves your system (and eventually mine) from containing thousands of
tiny 3 line basic programs just to see what MTHS looks like as a time
conversion, or any other nuisance programs.
I use it at least a few dozen times a day, especially when testing
formatting or even some math. PRINT 1501234/15 is better than DIVD.
The only limit is when you get caught up with an ELSE that causes the rest
of the line tobe part of the ELSE and not the rest of the program. Thus, you
can program with consecutive (successful) THEN's like in the 4th example.
Specifically you would not use RUN or CALL in the original posting. PRINT
becomes a new verb in the MD and if it's there, it's probably a throwaway
connective for English.
I have installed this or its platform altered version on Microdata,
Ultimate, UV, UD, AP-Pro, D3, Adds, GA, MvBase, Sequoia, Alpha-Micro, Altos
and Revelation. It is so darn simple.
It's also Emulator independent being on Procomm, Hyperterminal, Telnet,
Wintegrate, Accuterm, Wintegrate and even PK-Harmony back in the day
Thanks and hopefully many can take advantage of this incredibly useful
program concept.
Mark Johnson
- Original Message -
From: Vance, Kathy [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Tuesday, May 09, 2006 9:17 AM
Subject: [U2] call sunroutine in command line
All,
How could I test a subroutine with AccuTerm command line? For example,
the subroutine is called WEB.BI.RENTAL.SUB(BTN.ID,CUST.ID,ERR.MSG) and
it has a select statement and returns a result set. In subroutine, there
is something like:
SUBROUTINE WEB.BI.RENTAL.SUB(BTN.ID,CUST.ID,ERR.MSG)
.
EXECSQLSTMT = SQLSTMT
ST=SQLExecDirect(@HSTMT,EXECSQLSTMT)
RETURN
End
Could I call this subroutine in command line by using:
RUN WEB.BI.RENTAL.SUB('953145678','4897','');
OR
CALL WEB.BI.RENTAL.SUB('953145678','4897','');
As a result, I could check the result of returned values from this
subroutine.
Thanks a lot,
Kathy
---
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] OPEN Statement DICT Default
I specifically remember being taught
X=STR(0,5-LEN(X)):X
for the 1 concept.
Before the % was allowed, a shorter form was
X=(0:X)R#5
which I recall using until % came about.
On that note, I stole R-10 and C#10 from UD and offered it to D3
hopefully for their next release.
Thanks
Mark Johnson
P.S. Many use OCONV(DATE(),D2/)[7,2] for the month. I think DATE()DM is
the shortest way.
Puzzle: Illustrate the simplest way to generate Jan thru Dec.
- Original Message -
From: Roger Glenfield [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Monday, May 08, 2006 9:42 AM
Subject: Re: [U2] OPEN Statement DICT Default
The same programmer that doesn't read the manual does an
EXECUTE instead of a SELECTINDEX, and yes, the index already existed
or
A=STR('0',20-LEN(B)):B
instead of
A=FMT(B,'L%20') or for the Universe Pick/Ideal flavor people in the
crowd A= B'L%20'
or
TODAY=OCONV(DATE(),'D2/')
CONVERT '/' TO @VM IN TODAY
MONTH=TODAY1,2
instead of
MONTH=OCONV(DATE(),'DM')
And yes, I have observed all of the above recently.
;) Just 15 minutes a week to look through the current manuals to find
out about a new option that you might not know existed?
Roger
Louie Bergsagel wrote:
I've never used the null dict indicator. Who ever reads the syntax book
unless a command doesn't work?
*:)*
-- Louie Bergsagel
On 5/5/06, Mark Johnson [EMAIL PROTECTED] wrote:
To All:
Was there ever a real requirement on any prior flavor to have the
typically
non-used DICT portion of the OPEN statement be the set of quotes and a
comma.
I accidentally forgot it in 1978 on a Microdata and it still compiled.
To
this
day I have not seen a reason for the OPEN ,FILE null dict indicator
and
have not used it since unless I actually want the DICT level.
Just wondering.
Thanks
Mark Johnson
---
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] OPEN Statement DICT Default
I meant all of the months in order. Thanks.
- Original Message -
From: Adrian Overs [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Monday, May 08, 2006 9:53 PM
Subject: Re: [U2] OPEN Statement DICT Default
Solution to puzzle :
Month = OCONV(DATE(),DMBL)
D = Date
MB = Abbreviated Month Name
L = Lower Case
On 9/5/06 9:45 AM, Mark Johnson [EMAIL PROTECTED] wrote:
I specifically remember being taught
X=STR(0,5-LEN(X)):X
for the 1 concept.
Before the % was allowed, a shorter form was
X=(0:X)R#5
which I recall using until % came about.
On that note, I stole R-10 and C#10 from UD and offered it to D3
hopefully for their next release.
Thanks
Mark Johnson
P.S. Many use OCONV(DATE(),D2/)[7,2] for the month. I think DATE()DM
is
the shortest way.
Puzzle: Illustrate the simplest way to generate Jan thru Dec.
- Original Message -
From: Roger Glenfield [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Monday, May 08, 2006 9:42 AM
Subject: Re: [U2] OPEN Statement DICT Default
The same programmer that doesn't read the manual does an
EXECUTE instead of a SELECTINDEX, and yes, the index already
existed
or
A=STR('0',20-LEN(B)):B
instead of
A=FMT(B,'L%20') or for the Universe Pick/Ideal flavor people in the
crowd A= B'L%20'
or
TODAY=OCONV(DATE(),'D2/')
CONVERT '/' TO @VM IN TODAY
MONTH=TODAY1,2
instead of
MONTH=OCONV(DATE(),'DM')
And yes, I have observed all of the above recently.
;) Just 15 minutes a week to look through the current manuals to find
out about a new option that you might not know existed?
Roger
Louie Bergsagel wrote:
I've never used the null dict indicator. Who ever reads the syntax
book
unless a command doesn't work?
*:)*
-- Louie Bergsagel
On 5/5/06, Mark Johnson [EMAIL PROTECTED] wrote:
To All:
Was there ever a real requirement on any prior flavor to have the
typically
non-used DICT portion of the OPEN statement be the set of quotes and
a
comma.
I accidentally forgot it in 1978 on a Microdata and it still
compiled.
To
this
day I have not seen a reason for the OPEN ,FILE null dict
indicator
and
have not used it since unless I actually want the DICT level.
Just wondering.
Thanks
Mark Johnson
---
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/
--
Adrian Overs
Phone : +61 (0)2 9484-7160
Mobile: +61 (0)411 358 354
---
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] OPEN Statement DICT Default
It's a shame that the habit wasn't broken when it became optional. Thanks. - Original Message - From: Kevin King [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Saturday, May 06, 2006 11:06 AM Subject: RE: [U2] OPEN Statement DICT Default Early versions of Reality did require it, including PC-MicroReality. -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Friday, May 05, 2006 10:37 PM To: u2-users@listserver.u2ug.org Subject: [U2] OPEN Statement DICT Default To All: Was there ever a real requirement on any prior flavor to have the typically non-used DICT portion of the OPEN statement be the set of quotes and a comma. I accidentally forgot it in 1978 on a Microdata and it still compiled. To this day I have not seen a reason for the OPEN ,FILE null dict indicator and have not used it since unless I actually want the DICT level. Just wondering. Thanks Mark Johnson --- 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 Free Edition. Version: 7.1.392 / Virus Database: 268.5.5/333 - Release Date: 5/5/2006 --- 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] U2 Courses offered by Raining Data
Wouldn't that be like asking Ford for Chevy questions. - Original Message - From: Bruce McAdoo [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, May 05, 2006 11:43 AM Subject: [U2] U2 Courses offered by Raining Data Does anyone have any experience with any U2 courses offered by Raining Data that they would share? Bruce W. McAdoo Wagner Brown, Ltd. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] --- 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] OPEN Statement DICT Default
To All: Was there ever a real requirement on any prior flavor to have the typically non-used DICT portion of the OPEN statement be the set of quotes and a comma. I accidentally forgot it in 1978 on a Microdata and it still compiled. To this day I have not seen a reason for the OPEN ,FILE null dict indicator and have not used it since unless I actually want the DICT level. Just wondering. Thanks Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Forum General Question
So why was it changed in the first place. I wonder how many liked it that way. Mark Johnson - Original Message - From: Richard Brown [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, May 01, 2006 11:45 PM Subject: Re: [U2] Forum General Question I think what Larry is saying is that it is now back to the first scenario you described. When you hit reply, the message goes to the list, which is then distributed to all of us. I subscribe to different list. Some I have to know to hit 'reply to all' to get my message to everyone. Some I can just hit reply and it goes to the list the poster. The poster will get it twice, once from me, once from the list. Personally I don't care which way it is setup. If I reply wrong for the list, that is my bad. Richard - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, May 01, 2006 11:20 PM Subject: [U2] Forum General Question While I'm a MV person, I don't know everything about all of this email/web/forum/thread stuff. What was the kind of U2 forum whereby a person posted a request and everyone got it. Then each answer got sprayed to everyone. And so on until it died. Now, it appears that only the person issuing the question gets the reply and many of us who might learn something of their public discussion are out of the loop. Am I detecting this properly. Thanks Mark Johnson --- 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] Forum General Question
Actually not. That's probably why I'm asking why the volume appears low. - Original Message - From: Nick Cipollina [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, May 02, 2006 9:52 AM Subject: RE: [U2] Forum General Question Haven't you seen any of the about 3000 emails on this subject? Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Tuesday, May 02, 2006 9:21 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Forum General Question So why was it changed in the first place. I wonder how many liked it that way. Mark Johnson - Original Message - From: Richard Brown [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, May 01, 2006 11:45 PM Subject: Re: [U2] Forum General Question I think what Larry is saying is that it is now back to the first scenario you described. When you hit reply, the message goes to the list, which is then distributed to all of us. I subscribe to different list. Some I have to know to hit 'reply to all' to get my message to everyone. Some I can just hit reply and it goes to the list the poster. The poster will get it twice, once from me, once from the list. Personally I don't care which way it is setup. If I reply wrong for the list, that is my bad. Richard - Original Message - From: Mark Johnson [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, May 01, 2006 11:20 PM Subject: [U2] Forum General Question While I'm a MV person, I don't know everything about all of this email/web/forum/thread stuff. What was the kind of U2 forum whereby a person posted a request and everyone got it. Then each answer got sprayed to everyone. And so on until it died. Now, it appears that only the person issuing the question gets the reply and many of us who might learn something of their public discussion are out of the loop. Am I detecting this properly. Thanks Mark Johnson --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Forum General Question
So one person's screwed-up auto-responder changes it for everyone else. Doesn't seem right. - Original Message - From: Roger Glenfield [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, May 02, 2006 9:52 AM Subject: Re: [U2] Forum General Question Somebody's auto-email-responder zoomed out 50+ I'll be back in the office on blah, blah, blah in a single day. At one point even responding to it's own 'responses'. Mark Johnson wrote: So why was it changed in the first place. I wonder how many liked it that way. Mark Johnson --- 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] Forum General Question
So one renegade email auto-responder changed this for everyone. Too bad that was the only solution. - Original Message - From: Larry Hiscock [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, May 02, 2006 1:47 PM Subject: RE: [U2] Forum General Question 50+ in a single day? Try 1500+ in an hour :-S -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roger Glenfield Sent: Tuesday, May 02, 2006 6:52 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Forum General Question Somebody's auto-email-responder zoomed out 50+ I'll be back in the office on blah, blah, blah in a single day. At one point even responding to it's own 'responses'. Mark Johnson wrote: So why was it changed in the first place. I wonder how many liked it that way. Mark Johnson --- 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] Forum General Question
While I'm a MV person, I don't know everything about all of this email/web/forum/thread stuff. What was the kind of U2 forum whereby a person posted a request and everyone got it. Then each answer got sprayed to everyone. And so on until it died. Now, it appears that only the person issuing the question gets the reply and many of us who might learn something of their public discussion are out of the loop. Am I detecting this properly. Thanks Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Different Conversion
With all of this talk of UD to D3, I'm interested in converting a client from Microdata *to* D3. That client is semi-proficient in MCD and to be quite honest, I'm not that interested in the 6/7 line dict items as compared to the 10 line ones. He's pretty good at creating A-type or F-type and leaves the more complex ones for me. I also have a client that was on MCD and now on UD and I detect a conversion utility that must have been run that took the original 10 line dict items and converted them to the 6/7 line dicts for UD, leaving the original 10 line dict item on the UD line 10 with a non-processing delimiter. Keeping the old dict item was probably for familiarity purposes. While they worked, they all became the REUSE and SUBR style on 002 that take some getting used to. While I have some clients on UD/UV, i'm not as good as others who focus wholy on UD/UV. Based on the speed deficiency, I've installed many phantom process on this MCD starting programs so that long reports do not tie up the actual user issuing them. They use the spooler pretty flexibly, more flexible than D3. The ironic thing may be that for the last 12 years of working on this client, all of my MCD tricks may have caused a greater burden for any upcoming conversion. C'est la vie. This client is pretty savvy and won't convert unless there are really, really good reasons. But the dialog has already been startd on a possible upgrade based on disc space. I guess my question is to learn of some conversion headaches that I may encounter. I know that Northbridge exists but haven't heard anything beyond their own words on how great they are. Real-life opinions are very important. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] PRODUCT EVALUATIONS
I'm presently happy with Accuterm as a terminal emulator, GED which is their GUI development module that designs like VB forms but is 100% pick subroutines with pretty managable code. Toss in WED, which is their Windows editor for programs and it's a home run. I'm sure there's many other screen editors but WED has met all of my desires for being 100% of the MS interface while intelligently editing MV programs, ie formatting, compiling, INCLUDES, CALLS, Multiple documents etc. Plus at $1000 for 50 licenses, it's a real sweet deal. Peter Schellenbach is 100% behind this product and incredibly knowledgable with MV, VBA and all of the GUI stuff. Having an emulator that can gradually allow you to convert programs to GUI on a priority basis instead of all at once allows for a smart transition. There is no magic pill. We decide which programs need upgrading, typically inquiry-based to give the users something beyond 80x24 green screens. We also take some existing programs with the business logic already coded and convert them to Callable subs for the GED to reference. My 2 cents. Mark Johnson - Original Message - From: will [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, March 02, 2006 1:57 PM Subject: [U2] PRODUCT EVALUATIONS An MV client has inquired about moving to GUI screens, Rapid/Easy Management Reporting Systems and Multi-Location Transmission protocols. We could simply give our client a recommendation of what is familiar to us, but that would not be an honest evaluation. In that light we are hoping that there are some real happy users of the new or updated products we have seen advertised and promoted at the trade shows. If anyone would care to weigh in with their pleasant surprises it might be helpful for everyone who are contemplating new purchases. Don't be shy if you threw or are contemplating throwing out something... that is of value also. If this list is an inappropriate forum for candid evaluations, then please send replies direct to [EMAIL PROTECTED] When we have had time to compile the results (shades of American Idol voting?), we will be happy to share them with any interested parties. Will --- 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] Steve Cashman
I'm guessing March 6. Just a hunch. I think that the list server should/could detect these and terminate. Otherwise, they could spin out of countrol. Mark Johnson - Original Message - From: Nick Cipollina [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Saturday, February 25, 2006 7:51 AM Subject: [U2] Steve Cashman Does anyone know when Steve Cashman will be back in the office? Nick Cipollina Pick Programmer ACS Heritage, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)965-8294 --- 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] Is there a Better Editor?
Accusoft's WED is absolutely huge. Your programs will come to life as you have a higher degree of visibility on them than the regular EDIT. Unlike notepad or wordpad, WED is MV oriented with keyword highlighting, indenting, double clicking to bring in INCLUDES and called subs, Compiling, multiple windows, colors, color printing etc. Plus the normal cut paste and windows keyboard shortcuts. I'm a converted EDit person who never got into VI or AE and it's great. I speak with Peter Schellenbach on a weekly basis and I'll be writing an article on WED soon. There are some nice features that will be added soon as well. Do not use it (or any program editor) as a data editor as you could offset the fields pretty easily. When combined with the GUI designer and run time, and at $1,000 US for 50 licenses, it's the absolute best bargain, hands down. My 2 cents. Mark Johnson - Original Message - From: Dave Taylor [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, February 21, 2006 7:46 PM Subject: Re: [U2] Is there a Better Editor? Michael, Yes. Download a free 30-day trial of Accuterm 2K2 from AccuSoft Enterprises at www.asent.com. Try their Windows editor, WED, at TCL and you'll love it. It will also move data back and forth between Unidata and your PC for whatever purposes you wish. You can buy it direct from AccuSoft on line. Dave Taylor President Sysmark Information Systems, Inc. 49 Aspen Way Rolling Hills Estates, CA 90274 800-SYSMARK (800-797-6275) (O) 310-544-1974 (C) 310-561-5200 (P) 800-339-1497 (F) 310-377-3550 Your Source for Integrated EDI Translation and DataSync Integration www.sysmarkinfo.com - Original Message - From: Caskey, Michael [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, February 21, 2006 3:10 PM Subject: [U2] Is there a Better Editor? Hi all, this is my first post to the board, so a big Hi to you all! I'm probably showing off my lack of knowledge here, but I hope someone might have the knowledge I seek, so... I have been tasked with creating reports from our UniData system using UniQuery. For building queries, I have been given a tool called PARADEX. This tool seems extremely ancient to me. The interface is extremely cumbersome. To edit anything, special commands are employed to edit my queries, one line at a time. I'm already fairly lost in the system, so the last thing I need is cumbersome tools to make my life even more difficult. I like things to be easy peasy. :) So, my questions are: 1. Is there a better way to run these queries? and 2. Is there a better query editor; text-based or GUI or both? Thank you all! Michael T. Caskey --- 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] Dict Item
There are a few things that I've always been curious about English that are somewhat esoteric in nature. This was one of them that came up this week and I really didn't have an anwer. I believe your answer is in sync with mine, that English builds what it needs at the onset and goes from there. I inherit a lot of crap in my travels and I saw this conflict but got into a debate with another MV programmer. Thanks - Original Message - From: David A. Green [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Saturday, February 18, 2006 11:11 AM Subject: RE: [U2] Dict Item Mark, Not having access to the English source code I couldn't say for sure. But having written my own web version, and from a designer's standpoint, it just makes sense to open and read all dictionary records once at the beginning. An exception might be a Virtual Attribute that uses other dictionary items. Thanks, David A. Green DAG Consulting -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Thursday, February 16, 2006 8:27 PM To: u2-users@listserver.u2ug.org Subject: [U2] Dict Item If a process has already started with a file and dict items, either a SELECT or SORT, and one or more of the dict items get deleted or changed during that time by another process, does it have any adverse effect on the first process. Not that this comes up often, but it did today with some temp files shared by users. I'm not looking for a lesson in temp files, just the English (sic) processor. Thanks in advance. Mark Johnson --- 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] Question about execute and stacked data.
My 2 cents on this regardless of platform is to take the low road. Sure you can set up tricky DATA/EXECUTE statements that you hope will work but somewhere along the way they will get out of sync. I test things like consecutive selects, ie First Select for the majority and the second to fine tune (there are effeciency reasons). But if the first one fails, I don't want the second to process 'alone' and get far more (or zero) items than expected. Proc had the IF E = 401 blah, blah intermediate tests. There is a lot of status, Returning and, Capturing clauses to consider. Assume the worst and program around unvalidated data and the good stuff will prevail. Mark Johnson - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 13, 2006 11:54 AM Subject: [U2] Question about execute and stacked data. This is on universe 10.0.10 on windows xp. If you have stacked data, it will be executed after an EXECUTE, so: 001 DATA 'WHO' 002 EXECUTE 'SELECT VOC' Will select the voc to list 0, then execute WHO. If the command in EXECUTE doesn't yield a list, then the data isn't executed, so 001 DATA 'WHO' 002 EXECUTE 'GET-LIST VOCCRAP' ;* assuming you don't have a list named voccrap 003 INPUT A 004 CRT A The GET-LIST doesn't return a list, so the WHO stays stacked and gets picked up by the INPUT later. Now here's the problem/question. Suppose you have a basic program that creates a list, for example: 001 L='A':@AM:'B' 002 SELECTN L TO 0 Saved and cataloged as MY.LIST.PROG And change the test program above to 001 DATA 'WHO' 002 EXECUTE 'MY.LIST.PROG' 003 CRT @SELECTED The WHO does not execute, even though the basic program creates a list. You can fiddle with the VOC catalog entries adding 'K' to attribute 4 so that you can see the list created by running the program from TCL. So the question is, what magic does a basic program need to do so that it can create a list and participate in the serial execution of stacked data? -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.375 / Virus Database: 267.15.6/258 - Release Date: 2/13/2006 --- 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] Question about execute and stacked data.
I use DATA statements for both situations. To pre-answer the next INPUT instead of programming around it, or to provide the next TCL command for consecutive sentences. I've used a controlled set of dozens of pre-quailfied answers to use entry programs as blind data validation or other entry update programs. By turning off the crt response (PH in proc or processing the verb 'P') it can appear seamless. Another cross platform scenario. Some support DATA SAVE-LIST FRED EXECUTE SELECT MD and others EXECUTE SELECT MD EXECUTE SAVE-LIST FRED and more: TCL=SELECT MD TCL2=SAVE-LIST FRED EXECUTE TCL This area is the one I find that I need to pay attention to when converting systems within MV. Some systems allow named list references in a program. Others allow numbers. It got out of hand and is pretty splintered. My 1 cent. Mark Johnson - Original Message - From: Louie Bergsagel [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 13, 2006 6:34 PM Subject: Re: [U2] Question about execute and stacked data. According to the documentation, DATA is only used ...as an input stack to act as responses to INPUT statements... so your basic.program.that.builds.a.list would have to contain INPUT COMMAND;EXECUTE COMMAND or you could add another EXECUTE line after the DATA/EXECUTE lines which ran the following program: 0001: INPUT COMMAND 0002: IF @SELECTED THEN EXECUTE COMMAND 0003: END On 2/13/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I've got a bunch of code coming from another system where this worked. We have a lot of places with things like: DATA 'basic.program.that.uses.a.list' EXECUTE 'basic.program.that.builds.a.list' And under universe this just isn't working. The basic program isn't setting something that universe wants to see before it will execute the DATA. Some of it could easily be changed to PERFORM 'basic.program.that.builds.a.list' PERFORM 'basic.program.that.uses.a.list' Or as EXECUTE 'basic.program.that.builds.a.list' RTNLIST LST EXECUTE 'basic.program.that.uses.a.list' PASSLIST LST But I was hoping someone knew the internals that allow DATA 'SAVE-LIST LST' EXECUTE 'SELECT VOC' To work but DATA 'SAVE-LIST LST' EXECUTE 'basic.program.that.builds.a.list' To not work. --- 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] Simple OT question
With every computer (and other) connector having a 'name', ie cat-5, db25 etc, what is the name of the female end (computer end) of the AC power cord? No joke, just curious. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Simple OT question
Gracias. It sorta looks liek a square D, despite it being a brand name. - Original Message - From: Gordon J Glorfield [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Cc: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org Sent: Monday, February 06, 2006 10:31 AM Subject: Re: [U2] Simple OT question Mark, I asked our PC techs here and they tell me it's referred to as a Square-D (pronounced Square Dee) connector. HTH, Gordon Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 02/05/2006 08:40:45 AM: With every computer (and other) connector having a 'name', ie cat-5,db25 etc, what is the name of the female end (computer end) of the AC power cord? No joke, just curious. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ 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/
Re: [U2] Simple OT question
Granted, it's RJ-45 or RJ-11 or RJ-12 depending on the number of wires. I was just curious as we were discussing connector names for a few minutes and came up with easily over 50 (audio, video, A/C of course computers). The Square-D was the one that stumped us. Thanks. - Original Message - From: Larry Hiscock [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 06, 2006 1:03 PM Subject: RE: [U2] Simple OT question AC Power cord, female. ;-) Actually, cat-5 is the name of the CABLE, not the connectors. The connectors that go on cat5, cat5e and cat6 cables are called RJ-45. db9 and db25 come in both male and female, as do AC power cords ;-) Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Sunday, February 05, 2006 5:41 AM To: u2-users@listserver.u2ug.org Subject: [U2] Simple OT question With every computer (and other) connector having a 'name', ie cat-5, db25 etc, what is the name of the female end (computer end) of the AC power cord? No joke, just curious. Thanks in advance. Mark Johnson --- 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] Justification for removal of savedlists
I've seen instances of 'permanent' save lists but I've converted them to control records in a separate files. I like Microdata's date time stamp of their lists. UD/UV certainly have these in the unix level. I wish D3 had some because when looking only at the pointer-file, you really can't tell when they're made. And hunting down their source is not that easy with both SAVE-LIST, WRITELIST and writing directly to the POINTER-FILE. My 1 cent. - Original Message - From: Pingilley, Ron [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 06, 2006 10:38 AM Subject: RE: [U2] Justification for removal of savedlists Try Savedlists do not contain data. They are collections of record keys selected for processing as a group (reports, postings, etc.), and deleting them does not change or delete the actual data. The records pointed to by the keys still exist as-is in their original files/tables. Keeping them does not add value to the system, as the records represented by the keys in the saved list may no longer exist in the file, or may have been updated since the saved list was created.. --Ron P. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Pizer Sent: Monday, February 06, 2006 8:33 AM To: u2-users@listserver.u2ug.org Subject: [U2] Justification for removal of savedlists I wrote a small routine that will go through Savedlists, HOLD files, ST.PPROCES records, etc. and selectively delete the records that are no longer needed but I have been stopped by my VP. She wants justification for the process. I don't have the knowledge to be able to give her what she wants. I've tried the following arguments with no luck: Savedlists can be outdated as soon as they are created. Taking up too much server room. Any one have any others to try? - Bill Pizer --- 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] Newbies need love too
I've found that existing systems can offer a great learning area. Perhaps not for the best programming styles. But it's usually pretty readable and the newbies can relate to the inside based on what's happening on the outside. My 1 cent - Original Message - From: Wendy Smoak [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, January 31, 2006 6:35 PM Subject: Re: [U2] Newbies need love too On 1/31/06, Walter Vaughan [EMAIL PROTECTED] wrote: Is there not a UniVerse for Dummies website? Our sales rep asked his programmer and he said, I learned it 20 years ago, I don't know how you would learn it today. I have 23 and 28 year old programers that will have to live with this solution for the next 20 years. They're bright, but in order to get them excited about this platform I need to let them experiment. I'm not aware of any introductory material... you just have to dive in. :) Have them install the Personal Edition on their development workstations, then go through the library of PDFs. * http://www14.software.ibm.com/webapp/download/search.jsp?go=yrs=u2trials * http://www-306.ibm.com/software/data/u2/pubs/library/100univ/univ_101.html It goes without saying that they should be subscribed to u2-users! -- Wendy --- 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] [AD] JOB POSTING: CENTRAL NEW JERSEY [/AD]
Whomever replies should do a thorough analysis of this opportunity. Take it as you wish. - Original Message - From: u2ug [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org; [EMAIL PROTECTED] Sent: Saturday, January 28, 2006 3:54 PM Subject: [U2] [AD] JOB POSTING: CENTRAL NEW JERSEY [/AD] REPOSTED FOR NONMEMBER: Silver Line Windows [EMAIL PROTECTED] CENTRAL NEW JERSEY (LOCAL APPLICANTS ONLY) IS PROJECT MANAGER (WEB APPLICATIONS DEVELOPMENT) Silver Line Windows is one of the largest and fastest growing manufacturers of vinyl windows and doors in the country. Our quality products are the result of state-of-the-art engineering and manufacturing. We have nearly 60 years of experience behind every item we produce, DELIVERING high value results again and again from our facilities in New Jersey, Illinois, Georgia, Ohio, Texas, Massachusetts and North Carolina. We have been awarded the Home Depot Vendor of the Year again and again and our North Brunswick, NJ facility has won the Window and Door Magazine's 2005 award for Most Innovative US Plant. We invite you to join in our success. The growing demand for our quality products continues to fuel our record growth nation wide. Our record growth requires that we add a top project manager to our world class IS team to help take us to the next level. The successful candidate will lead a series of high visibility state of the art Web Base Application projects in support of our Companys continuing growth. The ideal candidate will have a minimum of seven years experience including at least three in project manager roles implementing Internet Based Applications knowledge of Microsoft Internet Information Services (IIS). Knowledge of DesignBais a strong plus. Expertise in User Interface Design and Multi-Value Data Bases is also important. Why join Silver Line? We're the industry leader, and one of NJ's fasted growing companies. We reward team spirit, loyalty and strong performance with a competitive salary, medical/dental/prescription benefits, vision discount, tuition reimbursement, profit sharing, 401k, on site cafeteria and opportunities for career advancement. For confidential consideration, please send your resume to: Manager Plant Recruitment, Job Code: ISPM, Silver Line Windows, 1 Silver Line Drive, PO Box 6029, North Brunswick, NJ 08902-6029; Fax: (732) 247-9325; E-mail: [EMAIL PROTECTED] Visit our website at: www.silverlinewindow.com EOE M/F/D/V -- - 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-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] Combined Print.
A client has thousands of TIF images on a separate server that our D3 application can instantiate a new Internet Explorer session to view with. From that new IE session, the user can elect to print that image. A request was made to incorporate a 50% version of that image on one half of an 8.5x11 sheet of paper and include regular MV database output on the other half. Any help? Exclusively HP printers with PCL-5 or 6. Another alternative would be to cause the image to appear automatically as a referential picture in a word document. Thus the user would have everything in that DOC and either print using MS or email. I could create a DOC template with an empty picture box but I would have to know how to populate it. Maybe I should just keep a template of that document in a text file to export to the user. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] PROC question
Look for any PROCREAD or PROCWRITE statements as well in the programs. - Original Message - From: John Hester [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, January 25, 2006 4:41 PM Subject: Re: [U2] PROC question Bob Woodward wrote: Maybe I'm just missing the finer points of PROC processing. I've got a MENU proc that's structured like this: PQ 10 C Top of Main Menu OA number of lines that display the available menu choices ... OEnter choice + IP: IF # A X IF A = 1 [PROD.PL PROG1.PROC IF A = 1 G 10 ... IF A = 99 [PROD.PL PROG99.PROC IF A = 99 G 10 O O That is not a valid menu choice. OPRESS [ENTER] + IP G 10 My problem is when I come back from one of the PROGxx.PROC's, I'm not getting the menu choice value back to execute the G 10 command. Instead it displays the error message at the bottom. As others have pointed out, the problem is likely that your input buffer is getting cleared. One easy way around this is to change the structure of your menu proc so you don't have to worry about the input buffer after the call to the program proc is made. All of our menu procs have this basic structure: PQ 10 C Top of Main Menu OA number of lines that display the available menu choices ... OEnter choice + IP: IF # A X IF A = 1 GO 100 IF A = 2 GO 200 IF A = 3 GO 300 GO 10 100 [PROGRAM PROC GO 10 200 [PROGRAM PROC GO 10 300 [PROGRAM PROC GO 10 We have a proc like this named BLANK.MENU that we just copy and modify anytime we need a new one. -John -- John Hester System Network Administrator Momentum Group Inc. (949) 833-8886 x623 http://memosamples.com --- 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] U2 and MAC
Not for nuthin' but what would be the purpose of putting UV/UD on a Mac. I see it as a technical challenge that can be accomplished but it doesn't seem that practical or worthwhile. Macs are traditionally 50% more expensive than equivilent PC, mano y mano, so what's the gain? I've owned many versions of both from Apple I II, Lisa, and IBM-PC, XT, Heathkits, S100's, TRS-80's to today's P4's and Powerbooks and have kept the two families apart for their own positive reasons. I use my Powerbooks G4's for video editing with Final Cut Pro and PC's for everything else. Just asking. Thanks - Original Message - From: Glen Batchelor [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, January 23, 2006 11:52 AM Subject: RE: [U2] U2 and MAC Don't you mean OS-X as been available on Intel systems for 2 weeks? I find it impossible to believe that Apple would stoop down to Intel processor architecture, just to get more market share. If they DID, then I'm going to go outside and wait for the pink elephants and flying pigs(not to be confused with Pink Floyd). --- Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 e-mail: [EMAIL PROTECTED] --- www.allspec.com --- -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Baakkonen, Rodney A (Rod) 46K Sent: Monday, January 23, 2006 10:01 AM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] U2 and MAC Macs have been Available on the Intel platform for about two weeks. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Claus Derlien Sent: Monday, January 23, 2006 3:37 AM To: u2-users@listserver.u2ug.org Subject: SV: [U2] U2 and MAC mac os x is based on bsd, but remember that its a ppc processor, so you will need the version of universe/unidata compiled for a ppc, or wait until os x is released on an intel platform. best regards from denmark Claus Derlien -Oprindelig meddelelse- Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] vegne af Raymond DeGennaro II Sendt: 23. januar 2006 05:24 Til: u2-users@listserver.u2ug.org Cc: u2-users@listserver.u2ug.org; Mark Johnson Emne: Re: [U2] U2 and MAC At 14:14 -0500 2006/01/21, Mark Johnson wrote: Isn't the underlying OS either Linux or Unix. That should be a start. In a nutshell, it's the best of FreeBSD, NetBSD and OpenBSD. Ray Frie Funktionfrer - faglig organisation og tvfrfaglig a-kasse - www.f-f.dk ** ** *** Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, der kun er beregnet for adressaten, og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en fejltagelse modtaget denne email, bedes De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand tak. ** ** *** This email and any files transmitted with it may contain confidential information intended for the addressee(s) only. The information is not to be surrendered or copied to unauthorised persons. If you have received this communication in error, please notify us immediately by telephone: +45 6313 8550. Thank you. ** ** *** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] U2 and MAC
Isn't the underlying OS either Linux or Unix. That should be a start. - Original Message - From: Jerry Banker [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, January 20, 2006 10:17 AM Subject: [U2] U2 and MAC Has there ever been a thought to put either of the U2 products on a Mac? With all of the recent news about Apple making a comeback I was wondering if there has ever been a thought to put a release on the MacOS. Jerry Banker --- 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] CSVs' (Different Question)
Subject: Exporting leading zero fields in csv. I have been exporting from MV to CSV for years and one of my pet peeves is that leading zero fields, like customer numbers, product codes and zip codes lose their leading zeros when the csv is opened in Excel. I will save everyone the trouble with prior suggestions by illustrating what hasn't worked yet. I've tried exporting as simple HTML but null cells don't get the proper frames. I've tried prepending a single quote but the single quote appears as data in Excel. I've also tried pre/append a single space but it still loses the leading zeros. I've noticed that when manually entering a value in Excel with a leading single quote, it retains the leading zeros. But when the CSV cell is '07748 it keeps '07748. I know that the user can re-format the cell to be zip code or custom but that gives the impression that the main system can only do part of the job. I also know that if the user is in Excel, they can import the TXT file and follow the import wizard to change the column's style to TEXT and not GENERAL. Again, this puts the burden on the users. HTML retains the value and the missing frames on null cells is okay but the users are used to clicking on the filename in Windows Explorer and HTML 'opens with' Internet Explorer. Great for viewing but not useful if they desire any data manipulation in excel. I am not versed in java or perl but if they can accomplish the job then maybe I'll learn them. I don't mind having the difficult part be on my side (MV) as long as the users get their simplicity. Thanks in advance Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] CSVs' (Different Question)
Where do I quote these? I have MV basic programs that create csv's, ie A,B,C,12345,000123 already. Thanks. - Original Message - From: Kevin King [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, January 16, 2006 10:08 AM Subject: RE: [U2] CSVs' (Different Question) To get Excel to keep the leading zeroes when importing a CSV, quote the value, aka: =012345 --- 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] PROC Question
Microdata allows multiple lines on PROCS, and I used to be very good at PQN procs but I don't recall the syntax. I would stay with the offered suggestions. My 1 cent - Original Message - From: Bill Haskett [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, January 11, 2006 1:35 PM Subject: RE: [U2] PROC Question Bob: I used to be pretty proficient in PROC and have never heard of this...but that doesn't mean it doesn't exist. :-) Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Wednesday, January 11, 2006 9:35 AM To: U2-Users List Subject: [U2] PROC Question Hi folks, I can't find anything in the IBM Doc's for ProVerb's that tells me how to create an entry that will allow me to put multiple commands on a single line. In a nutshell, from a menu when a user selects an option, I want to be able to execute multiple commands. Currently, I use multiple lines such as: IF A = 5 [USER.PL BASIC.PGM1 IF A = 5 [USER.PL BASIC.PGM2 IF A = 5 G 10 What I want to be able to do is: IF A = 5 [USER.PL BASIC.PGM1];[USER.PL BASIC.PGM2];G 10 Is my mind fried? Maybe... But is there something that will work? BobW --- 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] PROC Question
One final oft-seen PROC thing. You can have a PROC that has statement labels within have those statement sections referenced individually from the outside. Example PROX AAA PQN 100 T HERE AT 100 X 200 T HERE AT 200 X 300 T HERE AT 300 X and have calling PROCS likewise: [PROX AAA] 100 (some other proc statements) [PROX AAA] 200 (some other proc statements [PROC AAA] 300 So it's like haveing a library of SUBs in one place. My 1 cent. Mark Johnson - Original Message - From: Bob Woodward [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, January 11, 2006 2:50 PM Subject: RE: [U2] PROC Question Thanks, everyone. I got exactly the answer I was afraid I would get. Yes, my mind is fried... heavy sigh Because of system programming standards, I need to stay with a PROC but I was hoping to be able to streamline them a little bit. I appreciate the answers everyone offered, including the ones to quit using PROC's (and the thought has crossed my mind a number of times) but for the most part, we keep the PROC's pretty simple. Again, thanks. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Wednesday, January 11, 2006 9:35 AM To: U2-Users List Subject: [U2] PROC Question Hi folks, I can't find anything in the IBM Doc's for ProVerb's that tells me how to create an entry that will allow me to put multiple commands on a single line. In a nutshell, from a menu when a user selects an option, I want to be able to execute multiple commands. Currently, I use multiple lines such as: IF A = 5 [USER.PL BASIC.PGM1 IF A = 5 [USER.PL BASIC.PGM2 IF A = 5 G 10 What I want to be able to do is: IF A = 5 [USER.PL BASIC.PGM1];[USER.PL BASIC.PGM2];G 10 Is my mind fried? Maybe... But is there something that will work? BobW --- 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] DCOUNT
Thanks for all that responded. It was not a trick or underhanded question. It was just one of those days when I had programmed DCOUNT about a zillion times and I was wondering if there was any shortcut. It's better than the COUNT function that actually counts something different. I agree that having FOR I=1 to DCOUNT is not a problem with the small counts but dare not consider it as my conscience (the U2 Forum) would frown on it. I've learned a lot from this forum despite my decades of experience as I have not transversed every possible style of coding. My personal collection of styles is gleened from that vast experience of inheriting both good and bad code examples and keeping the best. Thanks Mark Johnson - Original Message - From: Bob Woodward [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, January 06, 2006 11:42 AM Subject: RE: [U2] DCOUNT Correct me if I'm wrong but does this method not require the DCOUNT function to be executed each iteration of I to determine if you have reached your max value? Granted, for a small number of values it would not be that much of a hit but I'd not like to encourage this on the off chance that you use it on a large number of values somewhere else. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Serguei Sent: Friday, January 06, 2006 6:02 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] DCOUNT I personally would even write it like this if I am sure the number of values is no more then ten: FOR I=1 TO DCOUNT(REC15,@VM) (and of course I would not use number as a field position) --- 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] Converting number to word
I wish that this Check Print Amount routine were standard MV-issue instead
of home grown.
On that topic, there is a user exit for converting a number to a roman
numeral. For sales reports to the branch offices in Italy.
My 1 cent.
- Original Message -
From: Bruce Nichol [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Thursday, January 05, 2006 12:12 AM
Subject: Re: [U2] Converting number to word
Goo'day, David,
Dick Pick's gift to the world:
At 15:24 05/01/06 +1100, you wrote:
Happy New Year,
A current project involves printing a number string in its alphabetic
description e.g. 1 = one, 3 = three, 11 = eleven etc etc. The precise
task
is printing a label of book information and in this case the label is
edition e.g. first/second.
The universe basic manual does not appear to provide a conversion code as
in MCN etc ; would someone know of a UV code or algorithm that
converts these strings?
Regards
David Knight
---
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/
Just add TH to everything above THREE and replace ONe TWO THREE with
FIRST SECOND THIRD... (I think)
And discard the cents!
0001: SUBROUTINE(N,S)
0002: S= ''; IF NUM(N) ELSE RETURN
0003: N = N'R26%12'
0004: FOR I = 1 TO 7 STEP 3
0005: X = N[I,3]
0006: SX = ''
0007: IF X 99 THEN SX = SX:' ':FIELD('ONE TWO THREE FOUR FIVE SIX SEVEN
EIGHT
NINE',' ',X[1,1]):' HUNDRED'
0008: X = X[2,2]
0009: IF X 0 AND SX # '' THEN SX = SX:' '
0010: IF X 0 AND SX = '' AND S# '' THEN SX = ' '
0011: IF X 19 THEN SX = SX:' ':FIELD(' TWENTY THIRTY FORTY FIFTY SIXTY
SEVENTY EIGHTY NINTY',' ',X[1,1]); X = X[2,1]
0012: IF X 0 THEN SX = SX:' ':FIELD('ONE TWO THREE FOUR FIVE SIX SEVEN
EIGHT NINE TEN ELEVEN TWELVE THIRTEEN FOURTEEN FIFTEEN SIXTEEN SEVENTEEN
EIGHTEEN NINETEEN',' ',X)
0013: IF SX # '' THEN S = S:SX:FIELD(' MILLION... THOUSAND','.',I)
0014: NEXT I
0015: IF S = '' THEN S = 'ZERO'
0016: IF S = ' ONE' THEN TEXT = ' DOLLAR ' ELSE TEXT = ' DOLLARS '
0017: S = S:TEXT
0018: IF N[11,2] = 0 THEN
0019: S = S:'ONLY'
0020: END ELSE
0021: IF N[11,2] 9 THEN
0022: S = S:N[11,2]:'/100'
0023: END ELSE
0024: S = S:' ':N[11,2]+0:' CENT'
0025: IF N[11,2] 1 THEN S= S:'S'
0026: END
0027: END
0028: RETURN
--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.1.371 / Virus Database: 267.14.12/220 - Release Date: 03/01/06
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.1.371 / Virus Database: 267.14.12/220 - Release Date: 03/01/06
---
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] New Year
Here's to everyone having a prosperous new year. Thanks for last year. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Using Esc
snip I worked with a client a while back and their application only used the BASIC INPUT statement. This caused some garbage data to occasionnally appear in their files. /snip I can honestly say that over 95% of my client's programs are INPUT ANS. Some have INPUT ANS,5 or INPUT ANS,5: or INPUT ANS,5:_ or even INPUT ANS:. Of these, my preference is INPUT ANS,5:_. One client with The Programmer's Helper has an Input subroutine but it doesn't appear to recognize the arrow keys. It does filter control characters. Like always, it's left to the individual programmer. Thus goes any help. My 1 cent. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Using Esc
This is exactly what I'm talking about. No offense to whomever wrote the keyboard mapping program, but it deviates from our real goals of application programming. My 1 cent. - Original Message - From: Jacques G. [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, December 20, 2005 11:58 AM Subject: Re: [U2] Using Esc I am sick of having to write filter routines for the control characters. It doesn't look good to the users either. On the plus side, many terminal emulators can have their keyboard re-programmed so that when you press a key it sends the key that you want. I've used this feature to send the proper arrow escape sequences on bad VT220 emulators. Once the terminal emulator is properly configured the setup file for it can become part of the standard installation procedure for the user. So if the escape key sends CHAR(251), it can be changed on the emulator without writing new code. I know that Hostaccess and Hummingbird allow for keyboard re-programming. I've used Accuterm before but don't remember if you can re-program its keyboard as well. On my emulator, I've configured F12 to do: S^M so that when I step through the debugger I only need to press one key. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- 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] Using Esc
Despite the progress made with conversions from green screen to GUI, my client base for example is virtually 100% green screen. I've been adding a few Accuterm GED programs but not to any huge extent. I believe that the providers should catch up with the times, especially Raining Data and IBM. They should recognize that the conversions from green screen to GUI do not happen overnight and it is truly an extremely large undertaking to consider re-writing legacy code for a gui interface. I'm not talking about re-developing the apps, just trying to make them a little more modern. One client would like their legacy Order Entry app re-written in a GUI interface. I'm truly afraid that my cost for this project will be prohibitive and that it may never happen. Thus adds another frustration. Nothing embarrasses me more than having to explain to a client's new employee that they have to re-type the whole answer if they spelled Apt 4B instead of Apt 4A on a long address line. That tiny piece of time starts off their relationship on a tremendous backwards note. Granted we know that the apps are sophisticated underneath. But the employee's shrugging shoulders speaks volumes. Perhaps what I'm hearing is that RD IBM will turn their back on this concept and, like many things, it's in my hands. So I'll re-deploy my GET.ANS() subroutine and try to tweak it for my different client's environments. Most users are not cut paste oriented. They just want to get to the end of 123 East South Street NW, Apt 4B and replace the B with an A. I don't blame them for condemming the application (and thus the database) with such a tired user interface. MS QuickBasic didn't provide any HomeEndDelInsert kind of INPUT statement. It actually provided too many INPUT formats so I had to write my own. Fortunately there were no terminal emulations or other 'environments', just DOS. Now, anyone programming with VB doesn't concern themselves one bit with these shortcomings. It's part of the environment. My 2 cents. Mark Johnson - Original Message - From: Brian Leach [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, December 20, 2005 7:22 AM Subject: Re: [U2] Using Esc Mark, AFAIR UV does provide cursor driven input - see the Input @, KeyEdit and KeyTrap statements. It is however pretty horrible. You can't blame the vendors for this one though. The problem has been the mindset of a community that hasn't shared code (how many virtually identical menu runners or input subroutines have I seen over the years) even though the runtime binding model of external subroutines makes it so easy... I doubt the vendors would be interested in extending a 20 year old text interface when you can download the free VB 2005 Express, UO.Net and do it all properly ... Brian -Original Message- From: Mark Johnson[EMAIL PROTECTED] Sent: 19/12/05 05:25:10 To: u2-usChis case MS got it right. Every input behaves very much like every other with the special keys. I believe that this should be accomplished by the providers themselves, ie Raining Data and IBM in their future releases. They already interpet the TERM setting and it would remove the differences. I took my GET.ANS and tried to fit it on Accuterm and couldn't get the proper backspace. --- 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] Using Esc
That is the one thing that is the most Jurrasic about MV systems, the INPUT statement. It's a shame that it needs so many home-grown methods that try to match with the language's IN or GET statements with the specific emulator's expressions of the characters being typed (and filtered). I wish the emulators themselves included a platform specific subroutine that could be easily edited as a replacement for the INPUT statements. I have successfully created a Wintegrate version emulating Adds-VP but there are so many combinations. GET.ANS() I know that some VAR's have developed their own configurable subroutines and attempted to emulate the very consistent Microsoft Textbox input scenario. In this case MS got it right. Every input behaves very much like every other with the special keys. I believe that this should be accomplished by the providers themselves, ie Raining Data and IBM in their future releases. They already interpet the TERM setting and it would remove the differences. I took my GET.ANS and tried to fit it on Accuterm and couldn't get the proper backspace. I'm not looking for code solutions now so please do not provide. I'm just suggesting that this 15 year old pursuit for a consistent INPUT interface be drawn to a close by the providers and not downstream by the VARs or individual programmers. Gone is the day where an employee's first brush with a keyboard is our old clunky Wyse-50. Virtually every new employee is coming from the MS interface and I am sick of having to write filter routines for the control characters. It doesn't look good to the users either. My 2 cents. Mark Johnson - Original Message - From: Results [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, December 19, 2005 2:04 PM Subject: Re: [U2] Using Esc Bill, Try CRT'ing the ASCII value of ANS to see what Esc is reporting as on this system. I have see 27 (typical), 251, and even 21 on some other terminal emulators. - Chuck The following code does not behave as intended. Esc = char(251) begin case case Ans = '' ; null case Ans = Esc ; return end case On the screen displays the characters...^[ appear. --- 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] Small FootPrint MultiValue
Not for nothin' but whenever I install D3 on a box, it seems to take around 5 seconds. Noticably shorter than any MS office product. If that qualifies as a small footprint. My 1 cent. - Original Message - From: Andy Pflueger [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, December 19, 2005 11:32 AM Subject: Re: [U2] Small FootPrint MultiValue On 12/19/05, Brutzman, Bill [EMAIL PROTECTED] wrote: Aside from U2 Personal Edition, are there any multi-value products like say IBM's CloudScape that do multi-value? There's always the open-sourced solution which does have a commercial version. Details found at www.openqm.com courtesy of LadyBridge Systems. :) -- The Linux philosophy is 'Laugh in the face of danger'. Oops. Wrong One. 'Do it yourself'. Yes, that's it. Linus Torvalds --- 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] Deciphering Pick UniBasic statement
snip I've worked with a client who purchased a package some years back and they only have the binaries. If the supplier ever goes out of business they are in trouble. /snip I must offer my opinion here on VAR-delivered object-code only systems. If I had any say in such a situation, I would require that the VAR place the source code that matches my purchased (licensed) system in escrow or some 3rd party place. I've run into a few prospective client situations that I could not turn into actual clients as I had nothing to work with. When the relationship is active or current, it's a nice deal for both the VAR and the client. The client gets current updates etc and the VAR has a locked in client. But when the VAR goes out of business, the client has a system with no source code and eventually it screws the entire MV community as in all of my examples, the replacement system wasn't MV-based. I don't want to digress into a debate on the merits of software licensing etc. That gets too out of hand. But when a VAR goes out of business and leaves no source code behind. No-one wins. Perhaps anyone in this current situation should re-negotiate the terms of their relationship with an application VAR who doesn't provide the source code. Otherwise, if the VAR folds, you're screwed. One VAR pulling a similar deceitful move removed from all of the dictionaries those dict items that weren't part of any English reports or Select statements. Think about it, if field 39 is used only in data/basic programs, it really doesn't need to have a dict item to work. I've spent many hours (and my client's $) backfilling missing dict items from source code. Likewise for source code with comments removed. If this were 1984 we would all have to play it a little closer. But it's 2005 and we should stick together because it really is MV versus other databases and not UD versus UV or MCD vs ULT or ADDS vs Sanyo etc. United we stand.. My 2 cents. Mark Johnson - Original Message - From: Jacques G. [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Sunday, December 11, 2005 11:31 AM Subject: RE: [U2] Deciphering Pick UniBasic statement Caleb's. It could take days to unravel the code by hand versus the few minutes needed to send it out to www.srs4uv.com. From one horror story I read on the site about a programmer that had sabotaged source code: The company used the SRS on the object code they were running. In addition, they compiled the suspect source code and used the SRS on that set. By comparing the two source code result sets they figured out which programs had been sabotaged. Why not simply compare the binaries ? Unix has a small program called: cmp that can compare two files and Windows has comp. You can tell which ones have been changed that way. You can also know when the files were last compiled by looking at the dates with ls -al on the binary. Still I think the decompiler can be a useful tool. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- 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] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword?
Not for nothing but I've worked on both platforms and I prefer Ud to Uv. My 1 cent - Original Message - From: Ken Wallis [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, December 01, 2005 11:07 PM Subject: [U2] RE: [UV] is there an equivalent to the UD ALL UniQuery keyword? To all you UniVerse experts out there. A site I know is moving from UniData on VMS to UniVerse on UNIX. Don't ask why, they just decided that was the path they wanted to go down. Anyhow, they've got used to the ability in UniData to LIST filename ALL and see everything. They're a bit surprised that this doesn't work in UniVerse. Any ideas? Of course we could write them a BASIC program called LIST that scans the command for the keyword ALL and if it finds it, works out what ALL means in the context of that file before invoking the real UniVerse LIST with a modified command, but I'd like to exhaust other options first. Cheers, Ken ALL Syntax ... filename ALL Description The UniQuery ALL keyword displays every data (D-type) attribute defined in the dictionary of filename. ALL does not display virtual (V-type) attributes. Example In the following example, the ALL keyword lists every D-type attribute in the INVENTORY file: :LIST INVENTORY ALL LIST INVENTORY ALL 10:25:34 Mar 25 1999 1 Product Number 15001 Inventory Date 08/20/1995 Inventory Time 01:00PM Product Name Modem Features 14.4K Internal V34 Color Quantity Price Reorder N/A 7486 $119.00 40 Product Number 35000 Inventory Date 07/09/1995 Inventory Time 10:00AM Product Name Speaker Features 250W, Direct/reflecting Color Quantity Price Reorder Black 148 $198.93 50 Charcoal 125 $198.93 50 --- 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] USB printer on D3
I have D3 installed on an Windows Xp system. I have a HP 1020 LaserJet printer (USB) that works fine on the windows side. I've properly created the device with 1 page eject. I have the printer folder open and when I send a print-job, I hear the wheels spinning on the printer but nothing comes out. I've appended 2-3 char(12)'s to the end of the job to kick it but to no avail. When I go to windows and print a test page, that job waits until I power-down the printer. The D3 job disappears and the test page comes out. Any suggestions? Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] 20 Digit Number
I was intending to make it easy on myself when having to enter these 20 digit numbers with my fingers when reading them on a printed paper. Thanks for all who replied. Happy Thanksgiving. Feliz dia de pabo. Mark Johnson - Original Message - From: John Jenkins [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, November 23, 2005 4:05 AM Subject: RE: [U2] 20 Digit Number Simplistic view maybe - but what about good old-fashioned BCD (Binary Coded Decimal)? Value Comp-3, hex +0 0C +1 1C +1201 2C +12312 3C +1234 01 23 4C -1 1D -1234 01 23 4D Here's a useful link...: http://www.discinterchange.com/TechTalk_COBOL_comp_.html Take a look at COMP-3. Alternative BCD/packed decimal schemas use the concept of an Overpunch to indicate negative numbers as some bit patterns are never used for digits: (0); 0001 (1) - 1001 (9) Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 20 November 2005 05:14 To: u2-users@listserver.u2ug.org Subject: [U2] 20 Digit Number General Question. A client has just taken on a new major customer and we have to keep track of their product codes. These codes are 20 numbers long with no real prefixing, suffixing or patterns. Is there any way to abbreviate numbers. I know this is a weird question but I know that I may be entering these codes manually during the testing and/or installation phase of this project and 20 numbers is a lot of typing. I've run out of ideas that simplify as most tend to complicate matters. The users will eventually be using bar code, scanning off of printed documents. As I develop, I will not have that benefit. I can calculator-enter numbers pretty effeciently given my accounting background. But 20 digits is a lot. I'm open to any ideas even if to know there are none. Thanks in advance. Mark Johnson --- 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: Fun with Robots (was: FW: [U2] 20 Digit Number)
Bar codes tend to be long as well. For UPC, the first section may be repetitive, thus can be omitted. I'm dealing with 20 digit numbers of no apparent syntax. They belong to my client's external customer. My request was a way to hand-type less than 20 to get 20 without a cheat-sheet or other short-cuts. I thought your original post had encryptions stored somewhere. Sorry for the confusion Mark Johnson - Original Message - From: Ross Morrissey [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, November 22, 2005 12:28 PM Subject: Fun with Robots (was: FW: [U2] 20 Digit Number) I'm not sure what you mean - there was no encryption in this app. Data entry applied barcodes to film canisters. The film sorting robot read the barcode and passed it (through DEVICE - what fun) to a routine that looked up order characteristics (e.g. 2 sets of 4x6 prints, slides, CD, express shipping) and calculated a bin number and returned the bin value to the robot. If the robot didn't hear back in less than .05 seconds, it defaulted to an error bin. The robot then dropped the roll into the target bin (actually it spun a J-shaped tube on a carousel the size of a Volkswagen and blasted the film down the tailpipe with a burst of compressed air). Testing this was similar to your issue of typing in long barcodes. I needed to type in thousands of barcodes and validate the results against (table driven) business logic changes - i.e. sort express and retail together. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Sunday, November 20, 2005 8:29 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] 20 Digit Number So what was the secret and was it human-able. I can code anything. I can't encrypt in my head that well. Thanks. - Original Message - From: Ross Morrissey [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, November 21, 2005 1:24 PM Subject: RE: [U2] 20 Digit Number I worked on the back end system for a film sorting robot. It read barcodes off 35mm film cartridges and I had to generate a bin number based on some complex logic. I put the logic in a subroutine, made an I-descriptor-callable shell, then wrapped it in a paragraph that allowed me to test against tens of thousands of historical transactions to give any code changes a real workout. No barcodes typed, and as a bonus, the logic was easily re-deployed to a manual interface later on. Thanks, Ross. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Saturday, November 19, 2005 9:14 PM To: u2-users@listserver.u2ug.org Subject: [U2] 20 Digit Number General Question. A client has just taken on a new major customer and we have to keep track of their product codes. These codes are 20 numbers long with no real prefixing, suffixing or patterns. Is there any way to abbreviate numbers. I know this is a weird question but I know that I may be entering these codes manually during the testing and/or installation phase of this project and 20 numbers is a lot of typing... --- 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] 20 Digit Number
That's cool. I think it'll work. Maybe not for everything but I can post to Notepad and work backwards. - Original Message - From: Ross Ferris [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, November 21, 2005 1:44 AM Subject: RE: [U2] 20 Digit Number Assuming you are using a windows PC, have the codes in a NOTEPAD document just cut/paste as required -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Kevin King Sent: Monday, 21 November 2005 4:32 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] 20 Digit Number Depends on the application. If you're entering it into your own application, patch your account number validation routine such that allows you to do whatever abbreviations you want: A could equal 123456763245435425324324 and that would be easy enough to do and would save you boatloads of time in testing. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: Saturday, November 19, 2005 10:14 PM To: u2-users@listserver.u2ug.org Subject: [U2] 20 Digit Number General Question. A client has just taken on a new major customer and we have to keep track of their product codes. These codes are 20 numbers long with no real prefixing, suffixing or patterns. Is there any way to abbreviate numbers. I know this is a weird question but I know that I may be entering these codes manually during the testing and/or installation phase of this project and 20 numbers is a lot of typing. I've run out of ideas that simplify as most tend to complicate matters. The users will eventually be using bar code, scanning off of printed documents. As I develop, I will not have that benefit. I can calculator-enter numbers pretty effeciently given my accounting background. But 20 digits is a lot. I'm open to any ideas even if to know there are none. Thanks in advance. Mark Johnson --- 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 Free Edition. Version: 7.1.362 / Virus Database: 267.13.4/175 - Release Date: 11/18/2005 --- 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] 20 Digit Number
It's the customer's carton numbers. We get an EDI document containing hundreds of them that get imported into the application. As normal, the client wants tracking down to the carton level (ie, received, shipped, received, errors, mis-matches). The users will eventually get printed tally sheets with the cartons bar coded. But for now, it's me and my fingers. The notepad idea looks good. Thanks. - Original Message - From: Brian Leach [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, November 21, 2005 4:51 AM Subject: RE: [U2] 20 Digit Number Mark, How are these numbers originated? It is rare for such complex numbers to be produced entirely randomly. How are you being supplied with the numbers to use for testing? Are they being printed out for you? If so, from where - and could they be transmitted or OCR'ed? More background please... Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Johnson Sent: 20 November 2005 05:14 To: u2-users@listserver.u2ug.org Subject: [U2] 20 Digit Number General Question. A client has just taken on a new major customer and we have to keep track of their product codes. These codes are 20 numbers long with no real prefixing, suffixing or patterns. Is there any way to abbreviate numbers. I know this is a weird question but I know that I may be entering these codes manually during the testing and/or installation phase of this project and 20 numbers is a lot of typing. I've run out of ideas that simplify as most tend to complicate matters. The users will eventually be using bar code, scanning off of printed documents. As I develop, I will not have that benefit. I can calculator-enter numbers pretty effeciently given my accounting background. But 20 digits is a lot. I'm open to any ideas even if to know there are none. Thanks in advance. Mark Johnson --- 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] 20 Digit Number
Thanks to all. I'm feeling good that my original assumption of abbreviating wasn't going to work. I appreciate all the different methods of entering. One will rise to the top. I'll post later. Thanks. - Original Message - From: Drew Henderson [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, November 21, 2005 8:02 AM Subject: Re: [U2] 20 Digit Number Mark, If you have specific numbers, or just need to have 20-digit numbers for testing, you can always generate several pages with the numbers and their associated bar-codes on them, allowing you to scan them in. Drew Mark Johnson wrote: General Question. A client has just taken on a new major customer and we have to keep track of their product codes. These codes are 20 numbers long with no real prefixing, suffixing or patterns. Is there any way to abbreviate numbers. I know this is a weird question but I know that I may be entering these codes manually during the testing and/or installation phase of this project and 20 numbers is a lot of typing. I've run out of ideas that simplify as most tend to complicate matters. The users will eventually be using bar code, scanning off of printed documents. As I develop, I will not have that benefit. I can calculator-enter numbers pretty effeciently given my accounting background. But 20 digits is a lot. I'm open to any ideas even if to know there are none. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- -- Drew Henderson There are two types of people - Dir. for Computer Center Operations those who do the work and those [EMAIL PROTECTED] who take the credit. Try to be in the first group, there is 110 Ginger Hall less competition. Morehead State University Indira Ghandi Morehead, KY 40351 Phone: 606/783-2445 Fax: 606/783-5078 -- --- 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] Swapping OS
Test a few programs before compiling every program en masse. We went to 5.2 a few years ago and some of the more cryptic code containing FILE defining Include equates caused some run time errors. Things like Line 587, Variable not assigned a value, Zero used and line 587 was an END. It was on Sun. Bob Wyatt may have more info on the Pantone conversion of 2001. Thanks Mark Johnson - Original Message - From: Dave R [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, November 21, 2005 6:03 PM Subject: Re: [U2] Swapping OS If you going from Unidata to Unidata I would think it would be a straight account save to an account restore, with a recompile of your basic code (if you have source code). The resetting, workstations and printers, D Raven [EMAIL PROTECTED] cell (949)2282224 e Fax (815)4259364 P.O. Box 17811, Irvine CA 92623-7811 -- Steven Frost [EMAIL PROTECTED] wrote: Hi - we are looking at the feasibility of switching our Unidata 5.2 platform from Tru64 to HPUX ( 64bit) has anyone done this before? I am assuming it wouldnt be a straight data and code migration. Steven Frost POWERCO 35 Junction Street Private Bag 2004 New Plymouth New Zealand Helpdesk 0800491491 DDI: +64 6 759 6583 Fax: +64 6 759 6253 Mob: +64 274 403940 Email:[EMAIL PROTECTED] Web: www.powerco.co.nz # This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal # * *** CAUTION: This email and any attachments may contain information that is confidential. If you are not the intended recipient, you must not read, copy, distribute, disclose or use this email or any attachments. If you have received this email in error, please notify us and erase this email and any attachments. You must scan this email and any attachments for viruses. DISCLAIMER: Powerco Limited accepts no liability for any loss, damage or other consequences, whether caused by its negligence or not, resulting directly or indirectly from the use of this email or attachments or for any changes made to this email and any attachments after sending by Powerco Limited. The opinions expressed in this email and any attachments are not necessarily those of Powerco Limited. * *** --- 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] 20 Digit Number
General Question. A client has just taken on a new major customer and we have to keep track of their product codes. These codes are 20 numbers long with no real prefixing, suffixing or patterns. Is there any way to abbreviate numbers. I know this is a weird question but I know that I may be entering these codes manually during the testing and/or installation phase of this project and 20 numbers is a lot of typing. I've run out of ideas that simplify as most tend to complicate matters. The users will eventually be using bar code, scanning off of printed documents. As I develop, I will not have that benefit. I can calculator-enter numbers pretty effeciently given my accounting background. But 20 digits is a lot. I'm open to any ideas even if to know there are none. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Taking night classes
Thanks Larry. I often wonder what the next thing I should invest my brain in. - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Thursday, November 10, 2005 5:18 PM Subject: [U2] Taking night classes Sometimes I get questions from Universe and Unidata programmers who are unemployed or will be unemployed asking about what classes would be helpful in finding new employment. I am sure their are many directions a person can go but here are a couple of suggestions. As recruiters we are seeing more requests for U2 along with VB.net and other internet software such as HTML, XML, and other web scripting languages. Also we are seeing less requests for Oracle and more request for MS SQL Server along with the U2 experience. I thought I would just pass those comments on and I realize that every shop is different. Larry Okeson Executive Vice President Software Search 1-800-949-5423 (toll free) 770-934-5138 [EMAIL PROTECTED] --- 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] Sort help needed
Sidebar:
Did (does) any system require the null expression for DICT in an OPEN
statement. Haven't used them since 1978 when I accidentally forgot it and
never looked back.
Just curious.
Mark Johnson
- Original Message -
From: Allen E. Elwood [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Monday, November 07, 2005 7:24 PM
Subject: RE: [U2] Sort help needed
Here's a generic sort routine to use as an example. It is capable of
sorting any number of attributes in a file. Basically, after using LOCATE
you have to use INSERT.
*TEST.SORT Sort unlimited associated fields off of one field
OPEN , ORDER.BACK TO ORDER.BACK ELSE PRINT GAA;STOP
ORD =
ORD11 = CHANGE('789,456,123',,,@VM)
ORD12 = CHANGE('1,2,3',,,@VM)
ORD13 = CHANGE('4,5,6',,,@VM)
ORD14 = CHANGE('SOMETHING, THAT, SHOULDNOTCHANGE',,,@VM)
ORD31 = CHANGE('7,8,9',,,@VM)
ORD32 = CHANGE('10,11,12',,,@VM)
* Setup Parameters
SORT.REC = ORD
ATTR.LIST = 12,13,31,32
ATTR.LIST = CHANGE(ATTR.LIST, ,, @AM)
ATTR.COUNT = DCOUNT(ATTR.LIST,@AM)
DATA.BASE =
SORT.ATTR = 11
SORT.BASE =
SORT.COUNT = DCOUNT(SORT.RECSORT.ATTR,@VM)
* Sort the data based off of the sort attribute in the sort record
FOR SORT.I = 1 TO SORT.COUNT
SORT.VALUE = SORT.RECSORT.ATTR, SORT.I
LOCATE SORT.VALUE IN SORT.BASE1,1 BY 'AR' SETTING SORT.INDEX ELSE NULL
SORT.BASE = INSERT(SORT.BASE, 1, SORT.INDEX, 0, SORT.VALUE)
FOR ATTR.I = 1 TO ATTR.COUNT
ATTR = ATTR.LISTATTR.I
ATTR.VALUE = SORT.RECATTR, SORT.I
DATA.BASEATTR.I = INSERT(DATA.BASEATTR.I, 1, SORT.INDEX, 0,
ATTR.VALUE)
NEXT ATTR.I
NEXT SORT.I
* Replace the sort record with the sorted values
SORT.RECSORT.ATTR = SORT.BASE
FOR ATTR.I = 1 TO ATTR.COUNT
ATTR = ATTR.LISTATTR.I
SORT.RECATTR = DATA.BASEATTR.I
NEXT ATTR.I
ORD = SORT.REC
WRITE ORD ON ORDER.BACK, 'TEST.SORT'
STOP
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Al DeWitt
Sent: Monday, November 07, 2005 15:27
To: u2-users@listserver.u2ug.org
Subject: [U2] Sort help needed
Environment: UniData - Pick Flavor
I'm trying to build a multi-value field in part number order.
I begin with LOCATE PART.NBR IN RECORD14 BY AL SETTING POS ELSE POS
= 0
The first time through RECORD14 is empty. The second time RECORD14
has one value. If PART.NBR is of greater value than what is now in
RECORD14 then I want PART.NBR to be the second value, if it is of
lesser value than I want PART.NBR to be inserted before the value in
RECORD14.
I will then do a second LOCATE to see where PART.NBR is stored
(RECORD14,x) and use that position to insert data into associated
attributes.
My problem is that I haven't done this in a while and when I did it was
in Universe. So not only am I suffering a senior moment I'm dealing
with a language barrier.
Any help would be greatly appreciated.
Thanks.
Al DeWitt
Stylmark, Inc.
---
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] [UV] PRINT @(-23)
Give Pete Schellenbach an email. He's extremely supportive of users of Accuterm. Quick turnaround. - Original Message - From: Dianne Ackerman [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Wednesday, November 02, 2005 9:22 AM Subject: Re: [U2] [UV] PRINT @(-23) Using Accuterm. The printer is fine because when I'm attached to other clients' sites it all works fine. -Dianne Bill_H wrote: Dianne: What client software are you using? wIntegrate? If so, check with File Printer Setup. Make sure a valid Windows printer is selected, or one that works with U2. Hope this helps. Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dianne Ackerman Sent: Tuesday, November 01, 2005 12:24 PM To: U2 List Server Subject: [U2] [UV] PRINT @(-23) I have a program which does a PRINT @(-23) at the beginning and a PRINT @(-24) at the end so that all the information prints on the aux printer. Works great, but when running at one particular client site, I get all kinds of weird characters printing on the document, at the beginning and end of each line. Fine at any other site, but just a problem when connected to this one client. Does anyone have an idea where I can look? Thanks! -Dianne --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV][OT]Embed command in CSV file? [ad]
Tony: What's the fastest path for someone who's been providing the CSV's for the last 10 years and wants to deliver something more complete. I don't want to spend a lot of my client's money on packages. The assumption is that the users are using Excel. I've taken some other advice on this forum to generate HTML which has had some success but is limited in ease of adding fields or making changes. Perhaps this is my opportunity to get into XML. Thanks Mark Johnson - Original Message - From: Tony Gravagno [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Sunday, October 23, 2005 5:46 PM Subject: RE: [U2] [UV][OT]Embed command in CSV file? [ad] Barry Brevik wrote: ...does anyone know if it is possible to embed some kind of command in a CSV file that will get Excel to autofit those rows automatically? The DIY solution is to use XML, for which there are examples around the Net. It's always amazed me that most IT people think that a plain CSV is an adequate deliverable when users want Excel. End-users often spend hours to days per month, reformatting data delivered like this, rather than making a request to IT for something more useful. I think there is some unstated belief by end-users that IT _can't_ create anything more sophisticated than a CSV, so they often don't bother to ask - it's one of those self-fulfilling situations that people assume won't change so they don't ask and then things never change. Anyway, I'm glad to see people here looking for something a little more professional and I encourage everyone to check with your C-level management or other hardcore Excel users about what they _really_ need from Excel, including multiple sheets in a workbook, charts, highlighted data, and dynamic updates from live databases (including MITS cubes, etc). Seeing there are no other definitive solutions presented in this thread... The problem described is exactly the problem solved with NebulAnalysis: http://Nebula-RnD.com/products/analysis.htm NebulAnalysis and other MS Office integration products were written a few years ago. Unfortunately there was only a small trickle of demand so we are no longer actively offering them. For some reason over the last few months a lot of people are looking to control Excel from MV so I might bring it back based on demand and available time. Please have a look at the audio/video demo here: http://Nebula-RnD.com/demos/nebulanalysis/ If you like what you see I may port this to U2 and give it some new life. While you're on the site, check out NebulaManager to see what's possible with Outlook - that's another one that I'd like to bring back. http://nebula-rnd.com/products/manager.htm I have a lot of experience with the internals of all of the Microsoft Office applications, and intend to continue development with Office 12 and the MS Office System. Nebula RD is growing and now has a team of U2 professionals who can do this sort of work. So if you need to get info to or from any Office product, feel free to ask about what's possible. Tony Gravagno Nebula Research and Development TG@ removethisNebula-RnD.com (We just posted a major website update with completely reworked pages, lots of new content, and a completely new strategic message. Please feel free to browse the site, comment, ask questions, etc. - Thanks!) --- 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] Double Indexes
I'm concluding that D3 doesn't support 2 simultaneous indexes. I deleted both indexes, timed a SELECT with 2 WITH's. Took about 85 seconds. Did a single SELECT WITH and then another SELECT WITH with the results and it went down to around 40 seconds. Re-indexed the DATE field and the first SELECT WITH was immediate but the second totalled to around 40 seconds again. Tried with 2 indexes and it went back to around 85 seconds. I optimized by deleting the CUST index and kept the DATE (it produced more items for one CUST than for one DATE, both were immediate) and then readv'd within a subroutine to get the specific CUST. Thus the DATE index remained. The users seemed happy with this approach. It ended up being around 15 seconds at best. Thanks. - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, October 21, 2005 2:43 AM Subject: Re: [U2] Double Indexes UV _should_ optimise 2-up secondary index selections (Glenn put a really good whitepaper on the list about indexes once - I can't find my copy now), use LIST/EXPLAIN to see if your indices are in use... My 2mil record test file uses 2 indices without a struggle returning a result in about a second or so. LIST SUPPORD IF REC.TYPE = O AND IF ORD.DATE = 11/04/04 EXPLAIN Single-variable predicates processed in index: F6 = 'O' AND F3 = '13251' Optimizing query block 0 Driver source: SUPPORD Access method: select list 0 with 249 ids UniVerse/SQL: Press any key to continue or 'Q' to quit -- Or try MERGE.LIST to see if that improves performance: SELECT FILE WITH DATE = 10.18 TO 1 SELECT FILE WITH CUST = 12345 TO 2 MERGE.LIST 1 INTERSECT 2 [EMAIL PROTECTED] wrote: - To: From: Mark Johnson Sent by: [EMAIL PROTECTED] Date: 21/10/2005 13:50 Subject: [U2] Double Indexes I'm wondering if a UD or UV system behaves similarly to a D3 problem I see. File contains 6,000,000 records. First field is DATE and 2nd field is CUST. Both are INDEXed. SELECT FILE WITH DATE = 10.18 quickly returns 11,000 items CLEARSELECT SELECT FILE WITH CUST = 12345 quickly returns 180,000 items CLEARSELECT SELECT FILE WITH DATE = 10.18 AND CUST = 12345 takes forever as if the indexes aren't there. I don't know if the double test in the SELECT statement ignores the INDEX on either (or the first) or is encumbered by taking the 11,000 quick DATE items and then hashingly goes through them looking for CUST. If I try SELECT FILE WITH DATE = 10.18 then SELECT FILE WITH CUST = 12345 it still takes longer than I would expect. Is a double INDEX a strange animal. Does U2 support indexing virtual fields, ie DATE.CUST? I don't think D3 can. Thanks in advance. Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** 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 email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related 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/
Re: [U2] [UV][OT]Embed command in CSV file?
Any advice on making better CSV's for eventual MV to Excel exports. I've used CSV's for years (avoiding A1 containing ID) and have been using HTML for some formatting. The HTML problem is I usually have to create the spreadsheet with its formatting, save as HTML and edit the 'text' of the HTML. SLK seems attractive. Where do I begin. Thanks - Original Message - From: Ewinger Klaus [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, October 21, 2005 3:14 AM Subject: AW: [U2] [UV][OT]Embed command in CSV file? Barry, Instead of using CSV, you could use SLK Format (Symbolic Link Format). It is slightly more work to format the data, but you have total control about cell formatting. You also get your cell types correctly, e.g. a date is formatted as a date and not as a string. Even formulas are possible. And the nice thing about it is, that it is pure ASCII. Not a binary format like .XLS. -Klaus -Urspr|ngliche Nachricht- Von: Barry Brevik [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 20. Oktober 2005 20:05 An: U2-users (E-mail) Betreff: [U2] [UV][OT]Embed command in CSV file? A little off-topic... From universe, I am creating a sequential file which is formatted as a CSV file, in other words each field is quoted and separated from each other by commas, for example: John,Jacob,Dingleheimer Schmidt The intent is that the resulting file is opened with Excel. You can force any cell into multiple lines by embedding a CHAR(10), for example: WRITESEQ \John,Jacob,Dingleheimer\:CHAR(10):\Schmidt\ TO MY.CSV.FILE THEN NULL ...when viewed in Excel will give you... JohnJacobDingleheimer Schmidt ...which is a great way of expressing multi-values. Finally I arrive at the crux. When you open such a document in Excel, it only displays one line per row even if a cell in that row contains multiple lines. To see all lines you have to select all and hit FORMAT | ROW | AUTOFIT. My users seem to be incapable of dealing with that, so... ...does anyone know if it is possible to embed some kind of command in a CSV file that will get Excel to autofit those rows automatically? Barry Brevik --- 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] Double Indexes
I putzed around with correlative-based indexed fields and got a lot of errmsg static. I'll try your suggestions. I'm trying to use the system instead of maintain manual xref files. This system is crammed full of 2M, 3M, 6Million record files and there is a lot of NUM1:NUM2 and NUM2:NUM1 (example) cross referencing done manually but none for DATE/CUST. I thought of creating a single Date/Cust xref file that could grab the eventual 800 average keys and let the secondary process filter it down to the desired subset but again, weaving it into this scrappy application (80% TPH) would guarantee not being perfect. Thanks. - Original Message - From: Scott Ballinger [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Friday, October 21, 2005 11:42 AM Subject: RE: [U2] Double Indexes [snip] Does U2 support indexing virtual fields, ie DATE.CUST? I don't think D3 can. Sure, both U2 and D3 support virtual index fields. U2 I type: CUST:.:DATE One caveat I know of is that in D3 you must use A-correlatives to define the index, e.g. Cust.date: a5:.:6 Or A0(call cust.date) Create-index myfile cust.date Select myfile with cust.date eq 12345.] - all records with cust = 12345 Select myfile with cust.date eq 12345.13809 - cust 12345 and date = 10-21-05 However, the fact that the date in cust.date must be specified in internal format reduces the utility of this approach, as does the fact that indexed dates can't be selected using greater than or less than type logic. Selecting by customer and/or date is pretty common; I usually end up creating a separate xref index file with the key = cust dot date and a mv list of myfile ids in attribute 1. Then you can select xref.file with cust = 12345 and with date ge 10-1-05 and le 10-20-05 myfile.ids This is usually pretty fast in itself, and you could always index cust and date in xref.file to make it faster under some circumstances. /Scott Ballinger Pareto Corporation Edmonds WA USA 206 713 6006 P.s. I did not know that that UV10 supports multiple index queries - very cool, and good to know! --- 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/
