Re: [U2] Rgarding ED editor
My 2 Cents: I love a GUI editor, but I've been using Pick/U2 since '82 and grew up with ED. It's still a very fast, very effective way to check records and make quick changes. Don -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Thursday, April 17, 2014 7:16 AM To: U2 Users List Subject: Re: [U2] Rgarding ED editor Doug, I totally disagree! Yes, once you get used to a GUI editor, ED/AE can be tough, but it has it's merits too. One, it's quick - it's ALWAYS available. Would you honestly invoke a GUI editor to make a quick change to a VOC entry? It's a tool of the trade - it needs to be a required learn George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: Thursday, April 17, 2014 9:18 AM To: U2 Users List Subject: Re: [U2] Rgarding ED editor If you are trying to use ED or AE in Universe or Unidata these are line by line editors. If someone is new to U2 then this is a bad move to try and teach them something so archaic. Regards, Doug www.u2logic.com/tools.html The only Eclipse editor with continuous compile technology ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Fwd: UML mapping tool for MV (UniVerse)
Wj, Sarcasm on: Use the Don security theory, first offense, cut off a couple of fingers, second offense, cut off right hand, problem solved. Sarcasm off Seriously, this boils down to a management issue, employee supervision and buy in. Don From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org Sent: Tuesday, July 16, 2013 12:44 PM Subject: [U2] Fwd: UML mapping tool for MV (UniVerse) -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Tue, Jul 16, 2013 9:42 am Subject: Re: [U2] UML mapping tool for MV (UniVerse) But with programmers able to create new DICT entries as they will, how do you *keep* it spotless? -Original Message- From: Hona, David david.h...@cba.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Jul 15, 2013 5:40 pm Subject: Re: [U2] UML mapping tool for MV (UniVerse) Regardless of the toolset, the first hurdle would be to normalise your database to look like a relational one. Which is likely to be the greatest hurdle. Data dictionaries in U2/PICK are optional are a purely for reporting purposes - they can have duplicates and these can be conflicting. Even worse (as if you thought it could be) - data dictionaries can be incomplete or wrong. This added to the lack of enforcement of data integrity and constraints usually causes these toolsets to fail (indeed, even the UV/ODBC driver fails too!)... so good luck! Rocket released U2 Metadata Manager to assist in this respect and is designed to allow forward and backwards capability. Although, support for this in UV is limited to the latest official release... so your alternative is UV/ODBC... For UV/ODBC users - I have always recommended a separate UV account and data dictionary that is spotless. For some this is the best option - why go against the flow - when you create your own stream... ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SORT reports line length, change right margin?
Randy, SETPTR can be used to set the line length/page width. SETPTR ,145,NODEFAULT,BRIEF Should set it to 145 characters. NODEFAULT says do not changes anything else and BRIEF suppresses the OK to set prompt. At the end you could/should reset it to 132. Of course, in a proc, put an H before SETPTR and a P on the next line. Good luck, Don Robinson From: Anthonys Lists antli...@youngman.org.uk To: u2-users@listserver.u2ug.org Sent: Monday, July 15, 2013 11:52 AM Subject: Re: [U2] SORT reports line length, change right margin? On 15/07/2013 15:32, randyleesmith wrote: It's been a while, nice to be back and working again. :) I'm on a Universe Database; I have a proc full of SORT reports. Bear in mind SORT and LIST are pretty much the same thing ... I needed to add new fields, but the size of the line is too small. I'm already using landscape mode and don't have enough space. I have been testing with PCL, but I was wondering if I could just make the line longer. Seems to be enough room if I could adjust the right margin. Could you shrink any field widths? Are there any text fields which often have wasted space? You can use the FORMAT or FMT (not sure which) modifier to adjust the field width just for that report rather than messing around cluttering up the dictionary. MARGIN /n/ only changes the left margin. What margins have been set in SETPTR? I can't remember whether the default is 0 or 3 (both left and right). I never had to deal much with SORT reports in the past, so I though you Guru's could help. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Running total
Kate,
This gives strange results if F1 is multi-valued so attribute 2
of the dict item needs to be: @1+SUM(F1)
Thanks,
Don Robinson
From: Kate Stanton k...@walstan.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Tuesday, July 2, 2013 6:32 PM
Subject: Re: [U2] Running total
Are you looking for @1? This gives a column containing running total (I
learned it from this list)
DICT AP F1 invoice value (A type or I type)
T1 running total I type: F2: @1 + F1
So, listing 3 items gives:
LIST AP TOTAL F1 KATE 10:26:30am 03 Jul 2013 PAGE 1
APID. INV. T1.
AMT.
101*850563 52,578.24 52,578.24
101*850568 -86.24 52,492.00
101*850569 86.24 52,578.24
*** 52,578.24
3 records listed.
On 2 July 2013 20:29, Martin Phillips martinphill...@ladybridge.com wrote:
Hi,
As far as I know, the only way to do this in U2 is to use either a common
variable or one of the @USERn variables in a subroutine to
accumulate the result. Handling multi-values is not hard (as below).
Getting this to work for breakpoint lines is a bit more
awkward.
For example, using UniVerse's demonstration sales database
(INITIALIZE.DEMO), I can create an I-type named ACCUM that reads
I
subr('ACCUMULATE', ITEM.TOTAL)
MD2
Cumulative
8R
M
BOUGHT
and a program catalogued as ACCUMULATE
function accumulate(item)
common /total/tot
if @ni = 1 then tot = 0
x = ''
n = dcount(item, @vm)
for i = 1 to n
tot += item1,i
x1,i = tot
next i
return (x)
end
I can then do
LIST ORDERS PROD.NO SELL QTY ITEM.TOTAL ACCUM
@ID.. Product No Sell. Qty. Item Total Cumulative
10002 605 $40.00 1 $40.00 40.00
501 $5.00 1 $5.00 45.00
502 $5.00 1 $5.00 50.00
504 $5.00 1 $5.00 55.00
10006 112 $6.00 3 $18.00 73.00
10004 704 $115.00 1 $115.00 188.00
301 $10.00 9 $90.00 278.00
10005 502 $5.00 9 $45.00 323.00
10003 202 $5.00 10 $50.00 373.00
204 $5.00 10 $50.00 423.00
10001 112 $6.00 7 $42.00 465.00
418 $27.00 4 $108.00 573.00
704 $115.00 1 $115.00 688.00
10007 301 $10.00 3 $30.00 718.00
Maybe Rocket can be persuaded to implement the CUMULATIVE field modifier
keyword that we have in QM to make this trivial
Martin Phillips
Ladybridge Systems Ltd
17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England
+44 (0)1604-709200
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:
u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: 02 July 2013 01:36
To: u2-users@listserver.u2ug.org
Subject: [U2] Running total
Teach me again how to do a running total in a Access/Recall/English report.
I haven't done one in years, but I seem to recall that it's possible.
___
U2-Users mailing list
mailto:U2-Users@listserver.u2ug.org U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
--
Kate Stanton
Walstan Systems Ltd
4 Kelmarna Ave, Herne Bay, Auckland 1011, New Zealand
Phone: + 64 9 360 5310 Mobile: + 64 21 400 486
Email: k...@walstan.com
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Recognition for Rocket and Rocket's U2 in dual rankings today!
Daniel, In the View from the Top by Andy Youniss, he list the following; 40% of US institutions of higher education 80% of Mexico’s emergency response systems 70% of North America’s largest independent insurance agencies 80% of automobile dealerships in North America 55% of Fortune 100 companies 50% of the top 400 energy-products companies Except for the Fortune 100 companies, it would seem that the others might be using packaged software. A list of these packages might be interesting. I'm not disputing the numbers but some explanation of how they were calculated would be nice to know. I have a vague idea about the auto dealers and higher education but not the others. I think this illustrates the I never heard of Pick/multi-value software comments we hear a lot of because the database is hidden from the users. BTW, maybe auto parts and many other wholesalers and retailers should be added to this list. Just my 2 cents, Don Robinson From: Daniel McGrath dmcgr...@rocketsoftware.com To: U2 Users List (u2-users@listserver.u2ug.org) u2-users@listserver.u2ug.org Sent: Monday, June 3, 2013 4:59 PM Subject: [U2] Recognition for Rocket and Rocket's U2 in dual rankings today! If you haven't seen it already, U2 got dual mentions today in top ranks. First: The UniData and UniVerse databases from Rocket Software have been listed for the first time in the database ranking site DB-Engines, making 45/169 (top 27%) on debut. http://db-engines.com/en/ranking Second: Rocket has been listed in the 'DBTA 100: The Companies That Matter Most in Data' with a big mention of the U2 databases from our CEO, Andy Youniss. http://www.dbta.com/Articles/Editorial/Trends-and-Applications/View-from-the-Top-Rocket-Software-89919.aspx http://www.dbta.com/Articles/Editorial/News-Flashes/DBTA-100-The-Companies-That-Matter-Most-in-Data-89876.aspx Regards, Dan ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [way ot] - Electronic Button Purshers?
Robert, Since you offered, I'll accept. If you know someone more deserving, that's fine. My first love is electronic hardware but I make a living by programming because it pays better. :-) My address is: Don Robinson 4189 Cannon Gate Dr. Cincinnati, OH 45245 TIA, Don Robinson 513-706-6149 (Cell) donr_w...@yahoo.com From: Robert Porter ropor...@ochsner.org To: U2 Users List u2-users@listserver.u2ug.org Sent: Monday, May 6, 2013 10:21 AM Subject: Re: [U2] [way ot] - Electronic Button Purshers? Ok... since this topic is so OT anyway. I have an OLD portable Tektronix oscilloscope that's not working right if anyone's interested. I can pull it down and check the model # if anyone's interested. It's been on the shelf for a LONG TIME. Something wasn't working on the screen. I don't remember if it was horizontal or vertical, or off to the side or what. I remember thinking that I'd fix it someday, and never got around to it... I'm sure the battery is probably shot by now. I think there's a couple probes in the bag too. If anyone is interested, pay for the shipping and it's yours. It might fit in a medium flat rate box ($12.50), I know it will fit in a large (~$17). Of course, these are domestic rates, if someone wants it over the pond, same offer - pay for shipping, but it will probably be more than it's worth... Robert F. Porter, MCSE, CCNA, ZCE, OCP-Java Lead Sr. Programmer / Analyst Laboratory Information Services Ochsner Health System This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the solicitor-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV full screen editor
Nirvan, I second AccuTerm WED. In addition to WED, I have created a couple of other commands using AccuTerm to run Windows programs. One of these is a compare program that opens 2 programs (items) in Winmerge. Winmerge is a windows compare/merge program that is very useful for locating changes in text files. It allows copying of data from either item to the other and when I exit it, I have a prompt to update the original items. Thus it does both a compare and edit. Winmerge knows nothing about MV so not so useful on multivalues. The second one opens a program (item) in windows grep which displays lines containing a search string. I have samba setup so I can use Winmerge, windows grep or any windows editor directly from Windows. I use Ultraedit which has a very useful hex mode. For data items containing multivalues and subvalues, AE is my choice. HTH. Don Robinson From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Monday, February 25, 2013 12:16 PM Subject: Re: [U2] UV full screen editor Probably the simplest, and easiest to use, would be AccuTerm http://www.asent.com. It is a terminal emulator, probably the best in the MV market, that includes an editor. You can call the editor while within the UV environment (that is, logged into an account) straight from the command line. So, instead of... :ED SOMEFILE ItemId ...you would change the ED verb with WED, like... :WED SOMEFILE ItemId This solution is probably best if you spend most of your time inside the UV environment and aren't interested in installing software other than a telnet client. In addition, it is probably the cheapest of all telnet clients you can use, assuming you place any value on your time. :-) HTH, Bill - Original Message - *From:* nirvanwijesek...@hotmail.com *To:* u2-users@listserver.u2ug.org *Date:* 2/25/2013 6:04 AM *Subject:* [U2] UV full screen editor Hello all, I'm new to this forum, so apologies if this topic has been brought up before. Can anyone recommend a decent full-screen editor for Universe? I require it for editing source code as well as modifying data files. Seems like most of them can do one or the other, but not both. We do not run System Builder, so is there anything else available? We are trying to move away from the native UV line editor. Many thanks. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Data not seen using LIST.ITEM
Tyler, Try using CT instead of LIST-ITEM. CT will display every line in the record including blank ones. The LIST-ITEM command skips blank lines and something may be causing it to skip 30. CT and LIST-ITEM don't use the dictionary so that's not the problem. Also, you can look at the record with ED or AE editors. Regards, Don Robinson From: Tyler44044 tyler.levass...@umit.maine.edu To: u2-users@listserver.u2ug.org Sent: Monday, January 28, 2013 4:04 PM Subject: [U2] Data not seen using LIST.ITEM Hello, Currently in the program I have, when I read values into an array called SR, if I do SR30 it shows the correct value on the screen. 30 also corresponds with the column number in the file as well. But when I do LIST.ITEM file ID number column 30 does not appear on the screen - all the other columns do except that one. This field is updated by another program so would that effect how the file displays data? Do I need to modify the dictionary of the file to allow this data to become available? Thank you to anyone who can assist me. PS. I am new to the language of UniVerse but I have programmed for some years before so I apologize if some of my terminology is incorrect. -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Data-not-seen-using-LIST-ITEM-tp39775.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Job ad in Berean, PA
Guys, Do recruiters have special training in using big impressive sounding words? Quotes: Works with stakeholders to perform application functionality gap analysis and feasibility studies. Independently performs assignments with instruction limited to results expected. Researches defects and solves for root cause in applications. My comments: Maybe they wouldn't have so many gaps if they gave the poor programmer better instructions! I always called software defects bugs, and of course you need to find the root cause, how else do you fix them? Just my 2 cents. :-) Don From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org Sent: Friday, December 28, 2012 12:33 PM Subject: [U2] Job ad in Berean, PA http://www.ziprecruiter.com/job/Senior-Programmer-116879/546532a0/?source=cpc-simplyhired Interesting they are looking for a Programmer but you must have strong knowledge of Unix, but only intermediate knowledge of their actual application environment :) Silly rabbits. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Eclipse ? was Job ad in Ardmore, PA
Jeff, Why? A terminal emulator is a terminal emulator Sounds like a needless restriction to me or does Eterm do more than emulate a termainl? Don From: Jeff Schasny jscha...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Friday, December 28, 2012 2:15 PM Subject: Re: [U2] Eclipse ? was Job ad in Ardmore, PA Accuterm/Wintegrate would not work with Eclipse. They have there own terminal emulator called Eterm. Wjhonson wrote: http://en.wikipedia.org/wiki/Intuit#Intuit_Eclipse Does Eclipse *require* the use of the Java client? Or is that optional? That is, can some users at one site, be using Accuterm / Wintegrate as dumb terminal emulators, while others are using the Java client? -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 9:34 am Subject: Re: [U2] Job ad in Ardmore, PA Oops Berean is the name of the recruiter or company The job is in Ardmore. -Original Message- From: Wjhonson wjhon...@aol.com To: u2-users u2-users@listserver.u2ug.org Sent: Fri, Dec 28, 2012 9:33 am Subject: [U2] Job ad in Berean, PA http://www.ziprecruiter.com/job/Senior-Programmer-116879/546532a0/?source=cpc-simplyhired Interesting they are looking for a Programmer but you must have strong knowledge of Unix, but only intermediate knowledge of their actual application environment :) Silly rabbits. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] How to create an entry in the Universe errlog file?
Hello guys, Today's challenge... I routinely check the Universe errlog file for problem programs. I would like to write my own errors to the errlog but can't find any way to to so. An example would be if an invalid or blank print Q is used in SETPTR. SETPTR doesn't check for a valid print queue but I can by reading the DEVICE file and displaying a message to the user. The problem is this can occurs in processes that log to COMO or PH and looking through a bunch of these is a pain. If I could write directly to the errlog file it would be much easier. Universe on AIX. Don Robinson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another job ad written by people who have no clue
Tony, As usual, you make some good points, however, I have a little different viewpoint. For the past 20 years I have worked for several mom and pop companies. These companies have refused to provide training for their employees including me and are very slow to adopt new developments in this business. I get reasons like, for what I'm paying you, you should already know ever thing, when so and so got back from training, they told me 'I know enough to get started, but I'm no expert', so no more training. (I guess the boss thinks a few days in class make you an expert!), I'll send you when we get a customer to buy the xyz product and several more I can't remember at the moment. Once, I was charged with supporting a customer with a new product and I was allowed to attend the same 3 day FREE training as the customer!! The customer had a couple of programmers that dug into it and within a couple of DAYS they knew more about it than I did, but I was still supposed to act like I knew what I was doing! Very frustrating. Any kind of Pick related training is always somewhere else and when the employer won't pay for you to go, what do you do? I understand it costs a lot but not being properly trained costs too. It seems a lot of employers want someone with specific experience instead of looking at your potential and ambition. Regards, Don Robinson From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users@listserver.u2ug.org Sent: Thursday, November 1, 2012 7:25 PM Subject: Re: [U2] Another job ad written by people who have no clue In the mainstream, it's generally understood that one must be in a constant learning cycle, or skills get outdated in a matter of 6-18 months. So .NET people need to understand the difference between WebForms and MVC, and adapt to generics, lambdas, and dynamic types. Java people need to adjust to changes in frameworks, networking, security, and XML parsing. PHP people need to understand competing frameworks as well as balance their server-side skills with JavaScript and related client frameworks. Any browser developer needs to shift with browser changes, now HTML5, CSS3, etc. And some of us need to do all of the above and then some. But what changes in the Pick world? Not much. And how do a lot of Pick people respond to that? By not feeling a need to do anything but R83-compatible BASIC. There are a lot of jobs out there for developers of new UI's for existing MV apps, but few people available who can satisfy the demand. And yet Pick people have had nearly two decades to improve their skills. Every developer here should be qualified for the job associated with this thread, because that ad looks pretty much like any other ad in this industry these days. I'm not trying to paint every Pickie as a dinosaur or a laggard - far from it. I'm just saying there are too many people who still only know BASIC while there have been any number of opportunities to move beyond that. And there are any number of examples of people in the mainstream who are in a constant mode of adaptation to prove that this is not only possible but the established norm. We are where we are in the Pick industry because Pick people generally become complacent in the belief that they are already using the best database in the world, so they don't need to learn anything else. That's just wrong at so many levels. That cripples the industry, making it more difficult for VARs to sell their software and for the DBMS providers to continue investing in this niche market. And let's face it, the additional problem that many here face is that the developer base is now aging, and it's difficult to start from scratch and jump on Mr Toad's Wild Technology Ride. We just can't do that anymore - myself included. What this means is that many people need to recognize their own limitations, and transition their approach to finding employment and consulting gigs. Position as a manager rather than as a programmer. Profile your skills as a problem solver who can get qualified people to write code, rather than competing with a million people who can write code but can't solve real world business problems. Sell your understanding of business rules, because this is an area where you excel compared to all of those people who can write code but have no idea what to write. T From: John Lorentz David Jordan wrote: you have to change the way you get the job interview. Only works if there are jobs available. In Portland, the long list of what people are looking for in skills when hiring does not include Pick (or other varieties). And years of experience in the field plus knowledge of xxx (say, PHP) does not equal five years of experience in PHP specifically using tools x and y in their equation, and you don't get past the initial screening. So I scramble to get what I can. Right now, I'm working QA on a contract and haven't had a chance for a permanent job for seven years now
Re: [U2] Consuming Web Services
Will and Brian, I had a similar experience. I indexed a file that had over a million records with the same code. All was ok for a couple of hours and then Universe crashed with something like out of string space. It was ugly! Had this worked, it would have been a great benefit but . I expermented with combining 3 attributes to reduce the max count to around 100,000 but the boss isn't willing to try again. Don Robinson --- From: Brian Leach br...@brianleach.co.uk To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Friday, October 5, 2012 8:59 AM Subject: Re: [U2] Consuming Web Services Will I don't understand what's wrong with indexing, can you clarify this point, and I'll wipe out a fix in three days :) Well for a start I didn't say there's anything wrong, I said it could be improved - not the same thing! But as to specifics, take the following scenario (UniVerse specific): - Grab a transaction file for say, 10 million records. - Assume a reasonable key length say 10 chars. - Add a field with two states (open/closed, male/female, that kind of thing). - Index it, and watch what happens to the performance on that file. - Better still, don't use an existing file! Create a new file and a program to copy or build the content in basic and show a counter every 1000 records. At the start it will be quick. After about 500,000 you can grab a beer in between the counters. The problem is, that a UniVerse index is very good at establishing the index key: it has a nice B+tree format with a decent level of fan-out. But when it comes to the list of primary keys being indexed against each index key, that's really just treated as a block of data. If you have a good ratio with a lot of index keys (date*type*something_else) each of which gives a relatively short list of primary keys you can get very good indexing performance. But it isn't very clever when you have a small number of index keys to a large list of primary keys. So every time you changed the flag value in the file above it would have to load up the two lists (one for old value, one for new), locate and delete from the old and locate/fail/append to the new, each list averaging 11 byte * 5 million entries. And then write it back to a succession of oversize blocks in the index file. Now you might say - well, you wouldn't index a transaction file like that. And you would be right - because of the design of the index. But it's a perfectly legitimate and reasonable thing to want to do. How to better manage a large index list is, of course, the question. Since it is a large list into which elements are potentially inserted/deleted in order, the list itself could be made into a set of B+Tree pages over a certain threshold, reducing the cost of location/insertion and location/deletion. Other databases use techniques such as key deltas and compression to alleviate this. And I'm sure there are better options if I could be bothered to research them. So there you go, Will. Your job for the weekend. Redesign the UniVerse indexing so it works for large lists, and get Rocket to adopt it. :) Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: 04 October 2012 16:43 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Consuming Web Services ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Etymology of Q-Pointer
Charles, My guess is Quick as in a quick link to another account. Don Robinson From: Charles Stevenson stevenson.c...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thursday, September 6, 2012 10:19 PM Subject: [U2] Etymology of Q-Pointer A newbie stumped me: Why are Q-Pointers Q pointers ? The Q lingo comes from the dawning days of Pick. Why was the letter Q chosen? Attribute makes sense. Synonym makes sense. PQ for Prestored Query makes sense. PR for Proc would have been better. D3 User Guide just says, Q-pointers are used in account master dictionaries to point to other files. UV User Ref says, Q-pointers are file definition synonyms that point to files in local and remote UniVerse accounts. Jonathon Sisk's Pick Pocket Guide doesn't help, either. PI never had Q-pointers. Clif, did Devcom consider it Questionable? I posed the same question on Pick Users GoogleGroup, but I didn't get a really satisfactory answer, yet. I'll bet someone here on the U2-List knows the true answer. Chuck Stevenson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SPAM-HIGH: Re: U2UG
Wrong it's not my friend. =) I do not host, develop, nor administer the U2UG website, I merely assist with the domain name upkeep and administration. Please do not contact me directly for website issues. Other than that, I fully support the U2UG organization and its capable volunteers. Regards, Don Verhagen -Original Message- From: Brian Leach br...@brianleach.co.uk To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Wed, Aug 29, 2012 10:51 am Subject: Re: [U2] U2UG John Contact me off-list and I'll see if I can help. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 29 August 2012 16:12 To: 'U2 Users List' Subject: [U2] U2UG What is the E-mail address for contacting support at U2UG? I clicked on the only link I could find (bo...@u2ug.org), but that got rejected (which suggests that needs to be reviewed). Thanks John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SPAM-HIGH: Re: U2UG
This was in response to the who-is for U2UG.org, in which, I am the domain name contact. - Don -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Wednesday, August 29, 2012 8:08 PM To: 'U2 Users List' Subject: Re: [U2] SPAM-HIGH: Re: U2UG Wrong it's not my friend. =) I do not host, develop, nor administer the U2UG website, I merely assist with the domain name upkeep and administration. Please do not contact me directly for website issues. Other than that, I fully support the U2UG organization and its capable volunteers. Regards, Don Verhagen -Original Message- From: Brian Leach br...@brianleach.co.uk To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Wed, Aug 29, 2012 10:51 am Subject: Re: [U2] U2UG John Contact me off-list and I'll see if I can help. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 29 August 2012 16:12 To: 'U2 Users List' Subject: [U2] U2UG What is the E-mail address for contacting support at U2UG? I clicked on the only link I could find (bo...@u2ug.org), but that got rejected (which suggests that needs to be reviewed). Thanks John ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Variable Interpolation
Guys, I may be way off base but I have a program that takes basic code from the command line, compiles and runs it. For example: 01 RUNBASIC CRT SYSTEM(2) ; CRT SYSTEM(3) 79 24 RUNBASIC is the program and CRT SYSTEM(2) ; CRT SYSTEM(3) is the code in this example. 79 and 24 are the answers. The string of = signs are just for looks. This could be EXECUTEd from within a program but why? It is quite handy for testing bits of code at TCL and might be useful in a proc. RUNBASIC will do anything you can do with one line of code using ; to separate statements including FOR ... NEXT and LOOP ... REPEAT. Code is free as long as you don't critisize it. Don Robinson From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org Sent: Friday, August 24, 2012 1:38 PM Subject: Re: [U2] Variable Interpolation The impression I get from this thread is something like Oh I've just read on the HELP pages that System(2) tells me the width of my CRT screen. Let me ask my process what it has as the value for System(2). Oops I have to write a program just to tell me that that's too much trouble. Why can't it just have a way to *tell* me ? Why -Original Message- From: Martin Phillips martinphill...@ladybridge.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Fri, Aug 24, 2012 10:11 am Subject: Re: [U2] Variable Interpolation Hi, I am intrigued by this thread, mostly because I have not understood why I would want it. If I can write CALL @SUB FOO(X,Y);Y=X+1;RETURN( 3, VAL ) as suggested, why don't I just write the code inline in my program. What have I missed? Martin Phillips Ladybridge Systems Ltd 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England +44 (0)1604-709200 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] u2ug.net Website
Brian, Larry, and Robert (for the explanation to the others of my predicament). I have been trying to figure out how to redirect the www.u2ug.org to Brian's new webserver (IP) without disrupting the listserver.u2ug.org. Robert you are correct that Network Solutions does not host the domain record but merely points to the appropriate domain named server (angelichost.net, Larry). Network Solutions would not allow me to simply point to an IP address, it's requires 2 named servers. I was thinking about have Network Solutions redirect it, but that requires Network Solutions to host the DNS and I didn't want to disrupt this list. I attempting to go through the solutions one by one and was at a point of giving up =). Now that I know all the players involved (Specifically, Larry) it seems that he can redirect www.u2ug.org from angelichost.net server. I will file Mr. Hisock's information away in a secret file. =) I will also give my contact information to him directly. Thank you all for your patience during this transition. Don Verhagen -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Wednesday, April 04, 2012 2:27 PM To: U2 Users List Subject: Re: [U2] u2ug.net Website This may be more about name resolution than you ever wanted to know, but here goes anyway... (knowledge is always a good thing). Sorry for the long post, domain name resolution is often misunderstood (kind of like people referring to somename.com as a top level domain or TLD - it's not, it's a 2nd level domain. The TLD is com.) The SOA nameservers in question are controlled by angelichost.net not Network Solutions (unless NS has some connection to Angelic I'm unaware of which is entirely possible). The only authoritative nameservers for the domain are ns9 and ns10 on angelichost.net's network. Anything else would have to be caching. Name resolution is hierarchical and works from right to left... ORG, U2UG.ORG, etc... The reason it works from anywhere is when you type it in locally, it will go to the one of the 13 root nameservers, aka (letter a-m).root-servers.net, (run by Verisign/Network Solutions and MANY others including NASA, DOD, Cogent, etc.) if not in cache based on the TLD in this case .ORG, it will then ask for the nameservers for the next level (U2UG.ORG in this case). In this case it will get ns9/ns10.angelichost.net. Root nameservers do not contain the zone records for the hosts themselves only the nameservers that are authoritative. It could keep going based on the break up of the domains. You can see this in action if you like... Here's part of the query for www.u2ug.org to a.root-servers.net: Default server: a.root-servers.net Address: 2001:503:ba3e::2:30#53 set q=any www.u2ug.org Server: a.root-servers.net Address:198.41.0.4#53 Non-authoritative answer: *** Can't find www.u2ug.org: No answer Authoritative answers can be found from: org nameserver = a0.org.afilias-nst.info. org nameserver = b0.org.afilias-nst.org. (clipped) Note how it says it cannot answer authoritatively, and points to the next level... Next I set the server to the 1st in the list from the root server Default server: a0.org.afilias-nst.info Address: 2001:500:e::1#53 www.u2ug.org Server: a0.org.afilias-nst.info Address:199.19.56.1#53 Non-authoritative answer: *** Can't find www.u2ug.org: No answer set q=any www.u2ug.org Server: a0.org.afilias-nst.info Address:199.19.56.1#53 Non-authoritative answer: *** Can't find www.u2ug.org: No answer Authoritative answers can be found from: u2ug.orgnameserver = ns9.angelichost.net. u2ug.orgnameserver = ns10.angelichost.net. Notice that the 1st time I messed up and hadn't set a q=any yet (query any/all information) and it refused to give me any answer at all. After I get the q=any, it simply pointed me up the change (or down if you like) to the angelichost.net servers... From there I can get the host. server ns9.angelichost.net Default server: ns9.angelichost.net Address: 216.240.154.246#53 set q=any www.u2ug.org Server: ns9.angelichost.net Address:216.240.154.246#53 Name: www.u2ug.org Address: 216.240.154.254 Those are the only 2 servers that can answer authoritatively. I've got at least a dozen nameservers under my control... Network Solutions has access to none of them. If they were to request a propagation of a domain (aka a zone transfer) it would be denied by the nameserver as it would not recognize their servers as having rights to do so (nor do they need it for dns resolution to work). This is a common security measure. I (or my clients) make DNS zone updates all the time, and N.S. isn't involved... The only zone transfers that take place are between the SOA namservers (those listed as nameservers for the domain) the upper level DNS servers only get involved when there's a change
Re: [U2] u2ug.net Website
Bill, You missed something =). Network solutions does not host the domain only redirects to the specified named server(s) (ns9.angelichost.net), i.e. doesn't host the A or MX record directly. Respectfully, Don V. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Wednesday, April 04, 2012 12:57 PM To: U2 Users List Subject: Re: [U2] u2ug.net Website Robert: [snipped..] When I looked at the whois record for u2ug.org, the sponsoring registrar and the Tech organization for the u2ug.org domain is Network Solutions, LLC. I may have missed something here, which is quite possible. :-) Bill - Original Message - *From:* ropor...@ochsner.org *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 4/4/2012 9:08 AM *Subject:* Re: [U2] u2ug.net Website Pointing the WWW host isn't so much about where/who the registrar is, but where the nameservers are. Network Solutions does offer DNS services, but the u2ug.org domain appears to use angelichost.net nameservers. Not sure if Don has direct control over the A records or not. Plus a few hosts frown on records pointing to other providers (mainly paranoid ones)... He may have to ask them to do it, and possibly explain why he'd want it that way. Robert ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Detecting idle time in INPUT statement.
Hello all, We are running Universe 10.1 on AIX with about 500 users. We have a problem with users opening up a record which puts a lock on it and just letting it sit at the INPUT statement for a long time. Most of the locking within the application does not use the LOCKED clause so when a second person needs the locked record, their session waits. What is the best way to detect the user hasn't typed anything for a period of time, say 2 minutes? This needs to be simple as we have no desire to rewrite the application! IIRC, some other MV systems have a timeout on the INPUT but I can't find anything about this in the UV manual. Thanks, Don Robinson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Detecting idle time in INPUT statement.
Thanks to all who responded. At the point in the programs where this is a problem for us, we know the user has a lock, we just want to release the lock. This will be done where they already have the option of aborting so no problem with partial updates, etc. The only gotcha on this is if they type one character, the INPUTIF will wait forever on the Enter key but this isn't too likely. The following code does this pretty well. * Don Robinson * Testing the INPUTIF statement. * PROMPT '' * ZZ = '' TIME.OUT.TIME = INT(TIME()) + 10 ;* Wait 10 seconds. LOOP INPUTIF ZZ THEN EXIT NAP 100 IF INT(TIME()) TIME.OUT.TIME THEN CRT 'The user is sleeping' STOP ;* Do whatever you want here. END REPEAT * * User entered something, proceed as usual. * CRT CRT 'User entered: ': ZZ * STOP END Regards, Don Robinson From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org Sent: Tuesday, March 27, 2012 1:53 PM Subject: Re: [U2] Detecting idle time in INPUT statement. Right, you don't care if they are at input exactly. You care if they are squatting on a lock. So your periodic lock checker thingie, has to be combined with a nasty email-o-gram campaign Until the users are well edumacated. -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Mar 27, 2012 10:44 am Subject: Re: [U2] Detecting idle time in INPUT statement. I guess you would need to merge this with the routine to detect who has locks pen (except running every two mins, not five) To determine who is sitting at an input prompt at a menu (which might be ok), s someone who is sitting at an input Prompt and hogging the locks! George -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Tuesday, March 27, 2012 12:18 PM o: donr_w...@yahoo.com; u2-users@listserver.u2ug.org ubject: Re: [U2] Detecting idle time in INPUT statement. Timed* activity on a *line* is controlled by the O/S not within Universe per e. Or at least you shouldn't expect Universe to keep you informed when lines re idle, natively. So (being on AIX a type of Unix) you are going to need to write a onstantly-running background task which queries the last modified timestamp on he lines and reports on idle lines. This is something controlled in AIX you now. Not just the timestamps but the timeout conditions. But *acting* on these in an automatic fashion would be quite dangerous to the ntegrity of your database, I'm sure you know. his should be used for informational purposes only. You get your reports, itch at the users involved, and gradually they learn to stop doing it. That's the best approach, IMHO, having lived through this exact scenario in many ompanies. Original Message- rom: Don Robinson donr_w...@yahoo.com o: U2 listserver u2-users@listserver.u2ug.org ent: Tue, Mar 27, 2012 6:26 am ubject: [U2] Detecting idle time in INPUT statement. ello all, e are running Universe 10.1 on AIX with about 500 users. We have a problem with ers opening up a record which puts a lock on it and just letting it sit at the PUT statement for a long time. ost of the locking within the application does not use the LOCKED clause so en a second person needs the locked record, their session waits. hat is the best way to detect the user hasn't typed anything for a period of me, say 2 minutes? This needs to be simple as we have no desire to rewrite the plication! IRC, some other MV systems have a timeout on the INPUT but I can't find ything about this in the UV manual. hanks, on Robinson _ -Users mailing list -us...@listserver.u2ug.org tp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Detecting idle time in INPUT statement.
David, Good idea. Revised code. * Don Robinson * Testing the INPUTIF statement. * PROMPT '' * ZZ = '' FOR X = 1 TO 100 ;* Loop for 10 seconds. INPUTIF ZZ THEN EXIT NAP 100 NEXT X * IF ZZ = '' THEN CRT 'The user is sleeping' STOP ;* Do whatever you want here. END ELSE * * User entered something, proceed as usual. * CRT CRT 'User entered: ': ZZ END * STOP END Thanks, Don Robinson From: David A. Green dgr...@dagconsulting.com To: 'Don Robinson' donr_w...@yahoo.com; 'U2 Users List' u2-users@listserver.u2ug.org Sent: Tuesday, March 27, 2012 2:31 PM Subject: RE: [U2] Detecting idle time in INPUT statement. Don, You should at least optimize the code by just checking a counter and not messing with TIME(). Your NAP command automatically takes care of the amount of time spent in each loop. You just need to count how many NAPs it takes to equal the amount of wait time you wish to have. David A. Green (480) 813-1725 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Robinson Sent: Tuesday, March 27, 2012 11:07 AM To: U2 Users List Subject: Re: [U2] Detecting idle time in INPUT statement. Thanks to all who responded. At the point in the programs where this is a problem for us, we know the user has a lock, we just want to release the lock. This will be done where they already have the option of aborting so no problem with partial updates, etc. The only gotcha on this is if they type one character, the INPUTIF will wait forever on the Enter key but this isn't too likely. The following code does this pretty well. * Don Robinson * Testing the INPUTIF statement. * PROMPT '' * ZZ = '' TIME.OUT.TIME = INT(TIME()) + 10 ;* Wait 10 seconds. LOOP INPUTIF ZZ THEN EXIT NAP 100 IF INT(TIME()) TIME.OUT.TIME THEN CRT 'The user is sleeping' STOP ;* Do whatever you want here. END REPEAT * * User entered something, proceed as usual. * CRT CRT 'User entered: ': ZZ * STOP END Regards, Don Robinson From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org Sent: Tuesday, March 27, 2012 1:53 PM Subject: Re: [U2] Detecting idle time in INPUT statement. Right, you don't care if they are at input exactly. You care if they are squatting on a lock. So your periodic lock checker thingie, has to be combined with a nasty email-o-gram campaign Until the users are well edumacated. -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Mar 27, 2012 10:44 am Subject: Re: [U2] Detecting idle time in INPUT statement. I guess you would need to merge this with the routine to detect who has locks pen (except running every two mins, not five) To determine who is sitting at an input prompt at a menu (which might be ok), s someone who is sitting at an input Prompt and hogging the locks! George -Original Message- rom: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] n Behalf Of Wjhonson ent: Tuesday, March 27, 2012 12:18 PM o: donr_w...@yahoo.com; u2-users@listserver.u2ug.org ubject: Re: [U2] Detecting idle time in INPUT statement. Timed* activity on a *line* is controlled by the O/S not within Universe per e. Or at least you shouldn't expect Universe to keep you informed when lines re idle, natively. So (being on AIX a type of Unix) you are going to need to write a onstantly-running background task which queries the last modified timestamp on he lines and reports on idle lines. This is something controlled in AIX you now. Not just the timestamps but the timeout conditions. But *acting* on these in an automatic fashion would be quite dangerous to the ntegrity of your database, I'm sure you know. his should be used for informational purposes only. You get your reports, itch at the users involved, and gradually they learn to stop doing it. That's the best approach, IMHO, having lived through this exact scenario in many ompanies. Original Message- rom: Don Robinson donr_w...@yahoo.com o: U2 listserver u2-users@listserver.u2ug.org ent: Tue, Mar 27, 2012 6:26 am ubject: [U2] Detecting idle time in INPUT statement. ello all, e are running Universe 10.1 on AIX with about 500 users. We have a problem with ers opening up a record which puts a lock on it and just letting it sit at the PUT statement for a long time. ost of the locking within the application does not use the LOCKED clause so en a second person needs the locked record, their session waits. hat is the best way to detect the user hasn't typed anything for a period of me, say 2 minutes? This needs to be simple as we have no desire to rewrite the plication! IRC, some other MV systems have a timeout on the INPUT but I can't find ything about this in the UV manual. hanks, on Robinson _ -Users mailing list -us
Re: [U2] Detecting idle time in INPUT statement.
Wj, You are right, I'm a hired gun and try to do what the *boss* wants. As far as adding LOCKED clauses, that would only solve a part of it. The second user would know why they can't update a record but would still have to call support to kick the first person out. The goal is to reduce user aggravation and calls to the support group. We shall see how the time out thing work outs. Thnaks, Don Robinson From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org; dgr...@dagconsulting.com Sent: Tuesday, March 27, 2012 3:37 PM Subject: Re: [U2] Detecting idle time in INPUT statement. On your system, as you said, versus in the rest of the programming world, where a programmer works for a manager, who works for another manager, who reports to a committee, who reports to the CEO, who gets funded by sometimes not so understanding money guys. Rex we don't have the luxury of being in the decision chair to make such changes :) That's the world. In addition to the non-hot-dog approach of actually testing your changes... on three hundred programs, or three thousand. -Original Message- From: Rex Gozar rgo...@gmail.com To: dgreen dgr...@dagconsulting.com; U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Mar 27, 2012 12:30 pm Subject: Re: [U2] Detecting idle time in INPUT statement. It does not matter if a system is old or not, you gotta keep it up to ate. Maintenance programming means adding LOCKED clauses that hould have been there in the first place. I doubt it would take more han a few hours; probably less time than writing and debugging some ff-the-wall input timer routine. There probably aren't that many ritical READU's. On my system, for the number of programs I have in he system, I only have a third as many READU's. ex __ 2-Users mailing list 2-us...@listserver.u2ug.org ttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Turn a device and inode into file name
Try ls -li |grep inode# in the directory where the file is likley to be or ls -liR / |grep inode# to look everythere. You may need root permissions to check some files. NO warranty! Don Robinson From: Wjhonson wjhon...@aol.com To: u2-users@listserver.u2ug.org Sent: Friday, March 16, 2012 3:23 PM Subject: [U2] Turn a device and inode into file name Anyone have an easy way to do this? In the past I've run a batch routine to just query each and every Universe file for it's inode and device and build a table of these Every week Seems like a great amount of overkill to me. You could also mod the CREATE-FILE command to sniff it and make an xref entry but Any suggestions? This is NOT for the case where you know the file and want to find the inode and device It's for the case where you know the inode and device (only) and want to find the file. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Where can I get UniAdmin?
Tony, When I had to install U2 (Unidata stuff) after some years of not using on a Win7 machine (although it's not specifically related to Win7) I tried to install some stuff under the traditional C:\Program Files (x86) instead of the default c:\u2 and ran into the same issues Tony did. In this day and age U2 needs start to understand spaces in paths, etc. and Windows standards. I hate having to specify rogue program files outside the windows standard location for such data (i.e. C:\Program Files [x86]\ in my backup plan. [end rant]. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Friday, March 02, 2012 7:44 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Where can I get UniAdmin? I'm providing notes about XAdmin since we're here. Bottom line, it's working fine. I installed the DBTools but originally put them under: C:\Program Files\Rocket Software\U2\U2Tools The first startup failed, saying I should look for a log under U2Tools\v3. That log wasn't there. I suspect a W7 permissions issue and figured this is why the installer wanted to install under the c:\U2 directory in the first place. But after so many years isn't it clear yet that products should be installed under Program Files, not root, and that should be written to %AppData% (different for W7/XP, etc)? I uninstalled but the Program Files tree remained. Apparently the uninstall doesn't remove the JRE6 that it installed. OK, that's another issue. First, why not mandate the JRE get installed into a common location first? Second, if you're going to install software, uninstall it too. I put my second installation under C:\Databases\U2\U2Tools, since I have all of my databases in that tree as well. On startup I did get the XAdmin. Yay. I created a Server reference and attempted to Connect, got error 39202. Recognized this as an RPC error and ... oops, I had shutdown Universe. Start services, got connect. Yay. On first connect got message that the Server programs are out-of-date with option to update XTOOLSUB to v3.100.0. Click OK. Wait. Nothing. Is something happening? Guess not. Move on. Open Tasks/Network Services to change telnet/ssh ports (avoid conflicts with other MV products). Change my Universe service to use the new telnet port for debugging. Now set Windows Firewall to allow the new ports. Connect in from outside. Yay! I hope that helps someone (whether U2Tools developers or fellow users). Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products Worldwide, and provides related development services Remove.pleaseNebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno http://groups.google.com/group/mvdbms/about From: Daniel McGrath Hi Tony, We are aware of the delta in functionality between UniAdmin and XAdmin. This delta is addressed in our upcoming U2 DBTools for which you won't have long to wait. For anyone using UniAdmin, I encourage you to keep a look out for this release and check out XAdmin. We are always looking for customer feedback on our products. Dan McGrath U2 Product Manager | Rocket Software ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Building an Excel File [AD-FREE]
David W. and others, I also have a perl script that will parse a Excel worksheet from a workbook (Excel 97-2003) if anyone is interested. It returns back a Variable in SheetDatarow,col automatically converts dates/times from the excel number to the pick date time number. I haven't look at in years, because it was solid as a rock. =). As I'm sure Tony G also has a product. I (have) could turn this into a (.NET) webservice that could run on any IIS server that handles both .XLS and XLSX format, but that will cost ya (not too much). David, I should have told you about TU.FORM.OPENDOS [SAVEDOS], we used it in Outsmart forever but I'm old and I forgot. Don Verhagen -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Thursday, February 09, 2012 10:39 AM To: 'U2 Users List' Subject: Re: [U2] Building an Excel File [AD-FREE] Thanks Don! This is quite nice -- and well documented! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Wednesday, February 08, 2012 9:15 PM To: 'U2 Users List' Subject: Re: [U2] Building an Excel File [AD-FREE] [AD] Completely free http://www.southeast-florida.com/ud/UD2EXCEL_CREATE_V2.zip Contains: - Perl Script to create XLS binary (97-2003) - Unidata Programs including a demo program - Limited Documentation Some features - Headers - Columns Headings - Sorting - SubTotaling and Outlining - Justification (Left / Right / Center) - Footers [/AD] This was written by me about 7 years. It's free, so please keep your comments about the horrible code to yourself. =) Additional Software need: PERL 5.8+ - PPM Module Spreadsheet::Write 2.20+ - PPM Module GetOpt::Long 2.3.7+ I will gladly answer questions offline at u2-usersrem...@thissoutheast-florida.com. Regards, Don Verhagen -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, February 07, 2012 10:15 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Building an Excel File Wil, while the OP asked about reading Excel on an iPhone, the title of the thread is Building an Excel File. That prompted suggestions for how to create Excel, including use CSV. Yes, all spreadsheet clients including Excel will open a CSV file. But that led to my assertion that CSV is not Excel and that CSV is not acceptable when people want Excel, though that is a common belief amongst MV developers because most end-users will just take what you give them ... and then they'll quietly start looking for people who will give them what they really want, Excel. This is a digression that you are welcome not to follow. About your statements - I'm intimately familiar with internals of Excel (Office in general), XML, CSV, and related document standards, and I have no idea what kind of middleware you're talking about below. CSV has no information about formatting, it's pure data. It's therefore impossible for any utility to do anything but autosize the columns, and that's trivial. As I said above, if all you're doing is opening the file, sure, that should work, but the result is hardly Excel outside of being text in columns and rows. You can't just simply 'change the Excel files into csv files'. Your statement doesn't survive the first attempt. Excel will warn you that it's going to lose detail if you do that. Again, CSV is not Excel. It doesn't provide borders, colors, images, cell references, merged cells, fonts, type styles, multiple sheets, named sheets, named ranges, file properties, page formatting, print pagination, fixed col/row settings, custom col/row sizes, or data typing. And while you can provide formulas in CSV, you'll lose them if you save Excel as CSV. [AD] And _that_ is the reason I created NebulaXLite, to allow programmers to do all of that from BASIC, on any OS, any DBMS, and with no underlying libraries. It's real workbooks for Excel, Open Office, and Google docs - when everyone else is ready to provide a delimited text file. T From: Wjhonson I think somewhere this jumped the track. No one is saying that CSV is Excel Rather the OP wanted a way to read an Excel file on the Iphone. Can the Iphone natively read Excel files? I know that it can natively read csv files, because we're doing it. It puts the csv file into a neat table with a border, with columns and rows all autosized and pretty with no effort whatsoever. So the solution could be simply to change the Excel files into csv files and voila you have no problem anymore for the Iphone. This doesn't address the issue of whether existing Excel files, or Excel files you receive from others can be handled. It only addresses the issue of reading Tables (of some kind) on the Iphone. ___ U2-Users mailing list U2
Re: [U2] Building an Excel File [AD-FREE]
[AD] Completely free http://www.southeast-florida.com/ud/UD2EXCEL_CREATE_V2.zip Contains: - Perl Script to create XLS binary (97-2003) - Unidata Programs including a demo program - Limited Documentation Some features - Headers - Columns Headings - Sorting - SubTotaling and Outlining - Justification (Left / Right / Center) - Footers [/AD] This was written by me about 7 years. It's free, so please keep your comments about the horrible code to yourself. =) Additional Software need: PERL 5.8+ - PPM Module Spreadsheet::Write 2.20+ - PPM Module GetOpt::Long 2.3.7+ I will gladly answer questions offline at u2-usersrem...@thissoutheast-florida.com. Regards, Don Verhagen -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Tuesday, February 07, 2012 10:15 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Building an Excel File Wil, while the OP asked about reading Excel on an iPhone, the title of the thread is Building an Excel File. That prompted suggestions for how to create Excel, including use CSV. Yes, all spreadsheet clients including Excel will open a CSV file. But that led to my assertion that CSV is not Excel and that CSV is not acceptable when people want Excel, though that is a common belief amongst MV developers because most end-users will just take what you give them ... and then they'll quietly start looking for people who will give them what they really want, Excel. This is a digression that you are welcome not to follow. About your statements - I'm intimately familiar with internals of Excel (Office in general), XML, CSV, and related document standards, and I have no idea what kind of middleware you're talking about below. CSV has no information about formatting, it's pure data. It's therefore impossible for any utility to do anything but autosize the columns, and that's trivial. As I said above, if all you're doing is opening the file, sure, that should work, but the result is hardly Excel outside of being text in columns and rows. You can't just simply 'change the Excel files into csv files'. Your statement doesn't survive the first attempt. Excel will warn you that it's going to lose detail if you do that. Again, CSV is not Excel. It doesn't provide borders, colors, images, cell references, merged cells, fonts, type styles, multiple sheets, named sheets, named ranges, file properties, page formatting, print pagination, fixed col/row settings, custom col/row sizes, or data typing. And while you can provide formulas in CSV, you'll lose them if you save Excel as CSV. [AD] And _that_ is the reason I created NebulaXLite, to allow programmers to do all of that from BASIC, on any OS, any DBMS, and with no underlying libraries. It's real workbooks for Excel, Open Office, and Google docs - when everyone else is ready to provide a delimited text file. T From: Wjhonson I think somewhere this jumped the track. No one is saying that CSV is Excel Rather the OP wanted a way to read an Excel file on the Iphone. Can the Iphone natively read Excel files? I know that it can natively read csv files, because we're doing it. It puts the csv file into a neat table with a border, with columns and rows all autosized and pretty with no effort whatsoever. So the solution could be simply to change the Excel files into csv files and voila you have no problem anymore for the Iphone. This doesn't address the issue of whether existing Excel files, or Excel files you receive from others can be handled. It only addresses the issue of reading Tables (of some kind) on the Iphone. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Building an Excel File
Amen Tony. I don't know how many times I get a call from a user saying for some reason my XLS/XLSX parser doesn't work with the Excel file they have. What the user really has is a CSV/TSV file with a XLS file extension that some programmer decided to name the file. This is because EXCEL doesn't bring up the CSV/TSV layout when the file has a .xls extension. However, my engine expects a true binary xls or x-zip xlsx envelope when the file has the xls/xlsx extension. Now the engine reads the first 20-50 bytes to determine if it's really an Excel file before attempting to parse it. It's NOT only U2/Pick programmers who do this little trick on the users. I have well known insurance company that does this, and it annoys the hell out of me. I've created excel files with PERL and the spreadsheet::write module when I worked on a HPUX/UD server and windows server for the past 12 years. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Monday, February 06, 2012 10:06 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Building an Excel File Not responding to any particular quote here, just the CSV topic in general. Respected colleagues, CSV is not Excel. If you have an end-user that asks for Excel and you give them a CSV you're just perpetuating the myth that Pick is a dinosaur. They will gladly spend tens of thousands of dollars to replace your application with something that creates real Excel (and PDF) despite the fact that such things can be attained at low cost or no cost right now. Trust me, I've seen it happen. This dove-tails with the reasons why people get 20 people to support Oracle when they can have 3 working on Pick. The reason is that the Oracle people say yes, and give them pretty reports, when their Pick guys say no, and give them plain text in columns and rows and call it Excel. Please don't let that happen to you. Be sure you are properly responding to end-user requests. Just ask them what they do with the documents after you generate them. If they really just want raw data, OK. But if they go on to tell you how many days it takes to reformat the data, assemble the multiple CSVs into a single workbook, etc, then you have found a great deal of room for improvement. Yeah, I've been there too. Off the soapbox, thanks. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UD Win 7.2 / Line Number with warning messages
Wally, Thanks, HUSHBASIC OFF was the key. I put it in my LOGIN paragraph that calls a basic program that executes UDTEXECUTE HUSHBASIC OFF since I didn't see a UDT.OPTION to set to override SBXA setting of this. Excerpt for sbxa_getting_started.pdf The following UniData environment options are set as part of the SB/XA Application Server logon procedure: - BASICTYPE 'P' - Sets the current BASICTYPE to be Pick-compatible. - HUSHBASIC ON - Suppresses UniBasic error messages, leaving only UniQuery error messages to display for UniQuery statements that execute from a UniBasic program. I'm not sure why this only seems to affect window versions of SB. Thanks again for the clue, Don Verhagen -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Monday, January 09, 2012 8:35 PM To: U2 Users List Subject: Re: [U2] UD Win 7.2 / Line Number with warning messages Run ECL HUSHBASIC OFF May be set ON in SB+ Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Monday, January 09, 2012 4:53 PM To: U2 Users List Subject: [U2] UD Win 7.2 / Line Number with warning messages When I was working with UD 6.x on an HP-UX (Unix) machine I remember warning messages such as uninitialized variables gave the line number in program. I just installed UD 7.2 for Windows and the warning messages just give the message no line number. Am I missing some secret config option? I should mention I'm also running SB 6.1. Any help would be greatly appreciated. Thanks, Don Verhagen ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UD Win 7.2 / Line Number with warning messages
When I was working with UD 6.x on an HP-UX (Unix) machine I remember warning messages such as uninitialized variables gave the line number in program. I just installed UD 7.2 for Windows and the warning messages just give the message no line number. Am I missing some secret config option? I should mention I'm also running SB 6.1. Any help would be greatly appreciated. Thanks, Don Verhagen ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] MS-SQL Question
You can't use the Column alias directly in a where cause, you need to put in
a derived dataset (table)
i.e.
SELECT *
FROM
(
SELECT
substring(colname ,charindex('|',colname)+1, charindex('|',colname,
charindex('|',colname)+1) - charindex('|',colname) -1) as PID
FROM SomeTable
) as DerivedTable
WHERE DerivedTable.PID = something
Don Verhagen
www.REMOVEemjackTHIS.com
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Wednesday, December 28, 2011 3:38 PM
To: U2 Users List
Subject: Re: [U2] MS-SQL Question
It came back with unknown column error. I'll have to play with it
again, it's possible I typed something wrong,
But at least for now, it's working the other way I set it up.
Thanks
George
-Original Message-
From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-
boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Thursday, 29 December 2011 2:51 AM
To: U2 Users
Subject: [U2] MS-SQL Question
I'm querying a sequel server , I have a column in one table that the
data is in the form of X|Y|Z.
I have the following in my SELECT:
substring(colname ,charindex('|',colname)+1, charindex('|',colname,
charindex('|',colname)+1) - charindex('|',colname) -1) as PID
Is there anyway that I can then use the PID designation in a where
clause, without having to retype the string again?
I can't add a virtual column to the table , and I can't add a procedure
either.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Testing . . .
4 ... 5 ... 6 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Thursday, November 24, 2011 8:34 AM To: U2 Users List Subject: [U2] Testing . . . 1 ... 2 ... 3 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Green Screen - Wide Screen
We've just manually changed the column setting by highlighting the 132 and entering 160, 190, etc. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, October 18, 2011 11:04 AM To: U2 Users List Subject: Re: [U2] Green Screen - Wide Screen Inside DC, I tried a bunch of terminal emulator settings but for all of them it indicates... 80 or 132. How do I get it to show more? Do I need one of those Extensions showing up in the right panel? --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Monday, October 17, 2011 6:41 PM To: U2 Users List Subject: Re: [U2] Green Screen - Wide Screen FYI, The limit with DC is 255 chars wide - you can change it from the Terminal setup dialogue box. There may be other emulators which can handle it - but the Universe /unix / windows drivers may also have difficulties with 600+ characters. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Tuesday, 18 October 2011 08:57 To: U2 Users List Subject: [U2] Green Screen - Wide Screen We have a large application that runs in Dynamic Connect... and needs more in the way of columns. DC is limited to approx. 132 characters. I believe that wIntegrate (when in text mode) is the same. We need maybe five times that. While I have almost concluded that this app needs to be re-written in GUI... before punting... are there any other angles worth consider... such as AccuTerm or some other text-based terminal emulator. Is there a way to do this in DC or wIntegrate? --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Databasic conversion
Symeon, Hum, I'd offer the guy $200.00 to do the job if he thinks it's that easy! I've worked on a couple of conversion between MV systems and there are a lot of differences. In my opinion D3 if very different from Unidata or Universe or jBASE or Reality or you name it. I just inherited a D3 system and it's awful switching between it and Universe because of all the differences. Not to disappoint you, just my 2 cents. Don Robinson Universe and D3 programmer. From: Symeon Breen syme...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, April 6, 2011 5:14:15 PM Subject: [U2] Databasic conversion Hi I am looking at a little side project to convert an entire system written in databasic on D3 to run on unidata. The guy i work with says it is a couple of hours work - I am not so sure myself. Anyone done this and know what the 'gotchyas' are ? Cheers Symeon. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Opinions on Cache
First I like to thank all that have responded to my query. I knew that posting a question that may lead me to dropping U2 as a database may cause some concern as to whether that is appropriate for this list. I believe it is, because I want the opinions of people who have experience/exposure in both U2 and Cache. There was a bit of confusion about U2 and SB. If I decide to go with Cache, I would abandon the SB platform for GUI UI. I was interested if there was any conversion utilities between SB and .NET forms. Specifically if Cache has .NET DLLs/providers for connectivity and databinding in .Net controls, etc. I haven't looked at SB/XA yet, which I believe is the XAML (WPF) replacement for SB. The candidate application is approx 15 years old (last used 3 years ago) and is due for a major rewrite/overhaul. I have used WebDE (Redback) in the past and was satisfied with it as middleware. After the comments from this forum, I am going to request an evaluation version from Intersystems. Again, I just wanted to thank all for their comments, both online and offline. Thanks, Don Verhagen Emjack Group LLC. u2-us...@southeast-florida.com -Original Message- Various Posters =) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Opinions on Cache
Group, I want to ask if anyone has had any experience with Cache and also has experience with U2 and SQL. I have been out of the MV (U2) since then of 2008, currently .NET (C#) and MSSQL. I have a large MV application written in SB and Unidata that I would like to re-develop. The basic roundup: Entity Files - Employees (1M+ records) - Customers (1M+ records) Transactons: - Payroll/Timecard/Invocing related files (10M+ records each file). Binary Files: - Photos, Documents (resumes, HR Forms) (2-3M records) This will be a small/midsize enterprise application that will have both desktop, web, and mobile modules. Areas of interest: - Speed (I know this is difficult without hardware/etc). - File / Program Architecture - Development Language/Environment - Change Management (SDLC) - Deployment I just looking for an over feel and professional opinions as compared to other platforms. The biggest issues I have with SQL is the shear about of tables and their inflexibility with max sizes and such. The toughest question I hate to answer what is: The maximum size for column/field Last Name/Surname, Answer: How the hell do I know! Thank you in advance for any and all opinions related to Cache, online or offline. P.S. I have been on this list for at least a decade, please don't hold that against me. =) Don Verhagen Emjack Group, LLC. Email: u2-us...@southeast-florida.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Git and U2
David My favorite is Perforce. It' not open source but a two user, five workspace version is free. I use one workspace on development and one on production so five is plenty for me. It is not MV aware but I've used it with Unidata, Universe and jBASE. It has command line and GUI interfaces for Windows, Linux and several others. Don From: DavidJMurray (mvdbs.com) nab...@mvdbs.com To: u2-users@listserver.u2ug.org Sent: Wed, March 2, 2011 3:18:37 PM Subject: [U2] Git and U2 Has anyone used Git and U2 - either UniVerse or Unidata - together? Or any other suggestions for a version control - open source is preferred? Thanks in advance, djm - Learn and Do Excel and Share http://mvdbs.com http://mvdbs.com -- View this message in context: http://old.nabble.com/Git-and-U2-tp31053109p31053109.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Dinosaurs
I started on Microdata systems back in 1982. Same big 'ol washtub drives, 1/2 reel tapes and Interrupt-Reset-Interrupt or Interrupt-Reset-Clock-Interrupt paddle-switch sequences. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Monday, February 07, 2011 8:39 AM To: U2 Users List Subject: Re: [U2] Pick Dinosaurs The first machine I worked on was a Microdata 1600 with 4 50 MB Winchester washtub drives. It ran 16 users on 64K of core memory. That was back in 1981. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Pick Dinosaurs
Everybody loved cold starts... the equivalent of Ctl-Alt-Del -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Roy Beard Sent: Monday, February 07, 2011 8:56 AM To: 'U2 Users List' Subject: Re: [U2] Pick Dinosaurs I really miss the GFEs and Ultimate's answer to everything Do a cold start and let us know if it happens again -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, February 07, 2011 11:51 AM To: U2 Users List Subject: Re: [U2] Pick Dinosaurs and we had to walk to work in bare feet uphill both ways! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of charles_shaf...@ntn-bower.com Sent: Monday, February 07, 2011 11:52 AM To: U2 Users List Subject: Re: [U2] Pick Dinosaurs I started on Microdata systems back in 1982. Same big 'ol washtub drives, 1/2 reel tapes and Interrupt-Reset-Interrupt or Interrupt-Reset-Clock-Interrupt paddle-switch sequences. The first machine I worked on was a Microdata 1600 with 4 50 MB Winchester washtub drives. It ran 16 users on 64K of core memory. That was back in 1981. Wow. You guys are really old. Charles Shaffer Senior Analyst NTN-Bower Corporation ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Sockets problem
David, 1024 and below are considered well known ports and are reserved for things like telnet, ftp, http, etc. You need to be careful assigning private ports so you don't tramp on other assignments. netstat will show you your current assignments. Don Robinson From: Dan McGrath dmc...@imb.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, January 10, 2011 10:25:27 PM Subject: Re: [U2] Sockets problem That is correct. If you are in the Unix/Linux world and you need to bind to ports below 1024, you need to run/start as root, then (generally you should) drop the rights of root once you have done it. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Drew William Henderson Sent: Tuesday, 11 January 2011 2:14 PM To: U2 Users List Subject: Re: [U2] Sockets problem It's been a couple years, but i believe ports in the lower range can only be linked to root processes. Drew -Original Message- From: Norman, David (Health) david.nor...@health.sa.gov.au Sent: Monday, January 10, 2011 9:55 PM To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Subject: [U2] Sockets problem We are trying to establish a Server Side Socket Connection using initServerSocket (UniVerse 10.0.16 HP-UX 11) for a third party system to connect. We are finding that using a port less than 1024 results in an error 34 SCK-EACCESS Attempt to connect datagram socket to broadcast address failed because setSocketOption Broadcast is not enabled. Ports from 1024 upwards don't have this error. Anyone have an idea what's going on ? Thanks, David Norman Senior Software Engineer - SA Ambulance Service ICT Services SA Health Government of South Australia Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 * fax +61 8 8271 4844 * david.nor...@health.sa.gov.au This e-mail may contain confidential information, which also may be legally privileged. Only the intended recipient(s) may access, use, distribute or copy this e-mail. If this e-mail is received in error, please inform the sender by return e-mail and delete the original. If there are doubts about the validity of this message, please contact the sender by telephone. It is the recipient's responsibility to check the e-mail and any attached files for viruses. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] PORT.STATUS questions.
Manu, The INTERNAL option looks promising for what I need. I do read manuals but somehow missed it. It doesn't solve the One user at a time issue but will make parsing the output easier. Your other suggestions may be useful, too. Thanks to you and the others that responded. Don Robinson From: Manu Fernandes e...@infodata.lu To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, January 3, 2011 11:47:21 AM Subject: Re: [U2] [UV] PORT.STATUS questions. Hi group, You can use uv provided subroutine !GET.USERS; search the uvdoc. If you use in basic EXECUTE PORT.STATUS INTERNAL CAPTURING VAR you get the port.status output in a dynamic array VAR ; @am,@vm You can also use in basic VAR=SYSTEM(1301) which return a dynamic Array, each attribute has 4 values: v1: Userno, v2:effective user name, v3: pid, v4: login type similar to what PORT.STATUS would show. Undocumented, but used by APP.PROGS GET.USERS.B No specials ; on uv. I hope this help. Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Don Robinson Envoyé : jeudi 30 décembre 2010 17:46 À : U2 Users List Objet : [U2] [UV] PORT.STATUS questions. Hello all, We are running Universe 11.1.17 on Aix 5.3. I use PORT.STATUS for several function within programs by capturing the output and parsing it. I have a couple of problems with this. First, only one user at a time can run the command and this causes random failure of the programs. Second, the output can vary depending on options and success or failure of the command. So, is there a callable routine to get the same info in a cleaner way? I need things like is port ### logged in or a list of ports logged in with a specific login id, etc. In others words, the same info but in a more usable format. Also, PORT.STATUS from within Universe gives an error for options like PID and FILEMAP but works ok from the AIX prompt, why? Thanks in advance, Don Robinson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] PORT.STATUS questions.
Manu, Correction. The SYSTEM(1301) is really SYSTEM(1302) in GET.USERS.B. It only returns info for your login id not all users. Don From: Don Robinson donr_w...@yahoo.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, January 3, 2011 1:06:41 PM Subject: Re: [U2] [UV] PORT.STATUS questions. Manu, The INTERNAL option looks promising for what I need. I do read manuals but somehow missed it. It doesn't solve the One user at a time issue but will make parsing the output easier. Your other suggestions may be useful, too. Thanks to you and the others that responded. Don Robinson From: Manu Fernandes e...@infodata.lu To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, January 3, 2011 11:47:21 AM Subject: Re: [U2] [UV] PORT.STATUS questions. Hi group, You can use uv provided subroutine !GET.USERS; search the uvdoc. If you use in basic EXECUTE PORT.STATUS INTERNAL CAPTURING VAR you get the port.status output in a dynamic array VAR ; @am,@vm You can also use in basic VAR=SYSTEM(1301) which return a dynamic Array, each attribute has 4 values: v1: Userno, v2:effective user name, v3: pid, v4: login type similar to what PORT.STATUS would show. Undocumented, but used by APP.PROGS GET.USERS.B No specials ; on uv. I hope this help. Manu -Message d'origine- De : u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] De la part de Don Robinson Envoyé : jeudi 30 décembre 2010 17:46 À : U2 Users List Objet : [U2] [UV] PORT.STATUS questions. Hello all, We are running Universe 11.1.17 on Aix 5.3. I use PORT.STATUS for several function within programs by capturing the output and parsing it. I have a couple of problems with this. First, only one user at a time can run the command and this causes random failure of the programs. Second, the output can vary depending on options and success or failure of the command. So, is there a callable routine to get the same info in a cleaner way? I need things like is port ### logged in or a list of ports logged in with a specific login id, etc. In others words, the same info but in a more usable format. Also, PORT.STATUS from within Universe gives an error for options like PID and FILEMAP but works ok from the AIX prompt, why? Thanks in advance, Don Robinson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [UV] PORT.STATUS questions.
Hello all, We are running Universe 11.1.17 on Aix 5.3. I use PORT.STATUS for several function within programs by capturing the output and parsing it. I have a couple of problems with this. First, only one user at a time can run the command and this causes random failure of the programs. Second, the output can vary depending on options and success or failure of the command. So, is there a callable routine to get the same info in a cleaner way? I need things like is port ### logged in or a list of ports logged in with a specific login id, etc. In others words, the same info but in a more usable format. Also, PORT.STATUS from within Universe gives an error for options like PID and FILEMAP but works ok from the AIX prompt, why? Thanks in advance, Don Robinson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ViaDuct problem
Harold, I see that Peter replied and he is the Accuterm guru so I'll give you a user's perspective. The GUI designer was easier for me to learn than Visual Studio and mv.net. The GUI designer creates the MV Basic code to display the form and stub sections for each control (prompt) and event. You then need to send data to the form and get data from it. It supports grids and tabbed windows. The form is controlled from the MV Basic program so you don't need to know Windows basic. Since the round trip from the form to Basic and back takes a finite amount of time, if you do it wrong, it gets a little slow. As with any tool, it takes a few wrong turns to get it right. I have never used Viaduct so I don't have any idea if the Accuterm subroutines are similar. Contact me off list if you want. Good luck, Don Robinson donr_w...@yahoo.com From: Oaks, Harold harold.o...@clark.wa.gov To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, December 27, 2010 6:56:53 PM Subject: Re: [U2] ViaDuct problem Charlie- Wow - sorry to hear that. Thanks for the info! I've always considered AccuTerm the 'other' main player in the MV terminal emulator market, and thought about going to them but conversion of the programs to use their forms would be a lot of workwheras the code to run Viaduct forms is embedding subroutine calls in the Basic code. That is, they are quite different. Do others have an opinion of AccuTerm versus SecureCRT? Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charlie Noah Sent: Monday, December 27, 2010 3:46 PM To: U2 Users List Subject: Re: [U2] ViaDuct problem Harold, I just Googled Via Systems and got this: *Via Systems Inc. has ceased trading.* If you would like information or have enquiries relating to either the UniVision DBMS or ViaDuct Terminal Emulation software, please visit the EDP Website by clicking here http://www.edp.co.uk/index.html. It sounds like they are all but kaput. I suggest you bail ASAP. I know it will be a pain, but it appears inevitable. May I suggest you take a look at SecureCRT? It is a very robust, full-featured emulator, and the folks at VanDyke are extremely competent and helpful. Charlie Noah Charles W. Noah Associates cwn...@comcast.net The views and opinions expressed herein are my own (Charlie Noah) and do not necessarily reflect the views, positions or policies of any of my former, current or future employers, employees, clients, friends, enemies or anyone else who might take exception to them. On 12-27-2010 5:26 PM, Oaks, Harold wrote: All: I wouldn't ask the list this question except Via Systems told me they no longer have a programmer on staff so can't answer this question. Does anyone besides me use Viaduct and make use of programming with Visual Data/Basic to manipulate Windows forms? I really like Viaduct and the forms capability, but there is one problem that's driven me crazy for years: after so many calls to the gui capability, a form will simply freeze when a control, for example a button, is clicked. After some sleuthing I know it's that the VTW.RESPONSE routine is looping thru code where it is waiting for End to be returned from the form. Normally this is returned, but when things go haywire it's not returned and the loop spins forever. All is fixed ONLY by rebooting the PC. Nothing else I've found works. This is obviously a real hinderance for the user community. Has anyone seen/solved this problem? Thanks- Harold D. Oaks Sr. Analyst/Programmer Office of the Budget and Information Systems Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mac Connection to UniVerse
Thanks for all the suggestions for connecting a Mac to UniVerse. 'Much appreciated! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Mac Connection to UniVerse
Has anyone installed Dynamic Connect on a Mac to connect to a UniVerse server via telnet? Thanks. Don ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mac Connection to UniVerse
Actually I've never used a Mac so the built in terminal is news to me! We have a client that may decide to deploy a Mac or two so we'll give it a go. Thanks for the terminal emulator info as well. _ From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rob Sobers Sent: Tuesday, November 30, 2010 6:03 PM To: U2 Users List Subject: Re: [U2] Mac Connection to UniVerse Hey Don, I believe Dynamic Connect, wIntegrate, and the other client tools that Rocket makes are Windows only. Can you just use Mac's built in terminal to telnet or ssh to your UniVerse server? What type of terminal emulation does your server expect? Here are some resources that might help: http://en.wikipedia.org/wiki/List_of_terminal_emulators#Mac_OS http://en.wikipedia.org/wiki/List_of_terminal_emulators#Mac_OS http://www.macwise.com/ Regards, http://superuser.com/questions/105009/most-efficient-terminal-emulator-for- unidata-universe-or-other-mv-based-systemsRob Sobers http://accidentalhacker.com On Tue, Nov 30, 2010 at 8:36 PM, Don P. Nagai dpna...@nei-pro-info.comwrote: Has anyone installed Dynamic Connect on a Mac to connect to a UniVerse server via telnet? Thanks. Don ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1170 / Virus Database: 426/3288 - Release Date: 11/29/10 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UniVerse DOS Command - Batch File Error
I have a batch file on a server running UniVerse. This file can be executed from Windows Explorer with no problems. If I attempt to run the same batch file using the UniVerse DOS command, the batch file will not process. The DOS command line is displayed, there is a slight delay (2 sec or so) before the EXIT command is issued and the system returns to TCL, but the batch file doesn't run. The UV User Ref is pretty vague on details for the DOS command. Any ideas on what I might be missing? TiA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse DOS Command - Batch File Error
Thanks. I'm using a different folder name to contain the batch file so I'll try moving it back to TEMP proper and see if it makes a difference. I'll also have a look at the environment variables. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Woodward Sent: Tuesday, November 02, 2010 4:12 PM To: U2 Users List Subject: Re: [U2] UniVerse DOS Command - Batch File Error Something I've run into before is location of the TEMP directory. I had a C:\tmp but was pointed to C:\TEMP in the environment variables. This caused a problem with executing DOS commands from within Universe. Long time ago, though. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don P. Nagai Sent: Tuesday, November 02, 2010 4:05 PM To: 'U2 Users List' Subject: Re: [U2] UniVerse DOS Command - Batch File Error Yes. I've actually moved the .bat file to the C:\ root directory and tested it there as well with the same results. The test have been: Executing .bat from Windows Explorer - Works OK. Triggering DOS and typing in the batch command manually - fails Placing the batch file in a variable and using EXECUTE to trigger it - fails This is really weird -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Richard Lewis Sent: Tuesday, November 02, 2010 3:57 PM To: U2 Users List Subject: Re: [U2] UniVerse DOS Command - Batch File Error Is the path set correctly, so that the application can be seen from the cmd or EXECUTEd environment? Best Regards, Richard Lewis On Tue, Nov 2, 2010 at 4:33 PM, Don P. Nagai dpna...@nei-pro-info.comwrote: Thank you for all the suggestions. I do appreciate them. I've tried the cmd.exe and EXECUTE STMT options and they both appear to run the batch file, but it looks as if something is preventing the app within the batch file from processing... which seems strange since the app runs if the batch file is triggered directly from Windows Explorer. The app is Print Wizard 4. I've been able to use the DOS command from UniVerse on a 2003 Server system. The failure is occurring on a W2K machine. I'll have a go at the GCI approach next. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don P. Nagai Sent: Tuesday, November 02, 2010 12:35 PM To: 'U2 Users List' Subject: [U2] UniVerse DOS Command - Batch File Error I have a batch file on a server running UniVerse. This file can be executed from Windows Explorer with no problems. If I attempt to run the same batch file using the UniVerse DOS command, the batch file will not process. The DOS command line is displayed, there is a slight delay (2 sec or so) before the EXIT command is issued and the system returns to TCL, but the batch file doesn't run. The UV User Ref is pretty vague on details for the DOS command. Any ideas on what I might be missing? TiA ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniVerse DOS Command - Batch File Error
Thank you. I'll give this a try right after testing to see if the Temp folder issue has an impact. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Whitehorn Sent: Tuesday, November 02, 2010 4:17 PM To: U2 Users List Subject: Re: [U2] UniVerse DOS Command - Batch File Error Rather than double clicking to run the bat, have you tried opening a dos command prompt (Start Run cmd) and then cd'ing to the directory the batch file is in and running the bat from there, as this should keep the window open and hopefully display a message that may point to why the uv shell isn't running as expected? HTH. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Woodward Sent: Wednesday, 03 November 2010 10:12 AM To: U2 Users List Subject: Re: [U2] UniVerse DOS Command - Batch File Error Something I've run into before is location of the TEMP directory. I had a C:\tmp but was pointed to C:\TEMP in the environment variables. This caused a problem with executing DOS commands from within Universe. Long time ago, though. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] how to round to 2 decimals?
How about this? X = 2596 * 8.333 ;* [X will contain 21632.468] ANS = INT((X * 100) + .5) / 100 PRINT ANS The (X * 100) changes X to 2163246.8 The + .5 changes X to 2163247.3 The INT() changes X to 2163247 The / 100 changes X to 21632.47 The output will displays 21632.47 Using a FOR NEXT loop, I run INT((21632.468 * 100) + .5) / 100 and the OCONV(21632.468,'MR20') versions one million times and got .84 seconds for the INT version and 4.9 seconds for the OCONV version. I doubt that 4 seconds would make a difference to most programs but every little helps. I also run the OCONV(ICONV(21632.468,'MD2'),'MD2') version and it took 5.1 seconds. My point: There is more than one way to skin a cat! Don Robinson From: Chris Austin cjausti...@hotmail.com To: u2-users@listserver.u2ug.org Sent: Thu, October 14, 2010 12:34:36 PM Subject: Re: [U2] how to round to 2 decimals? Are you sure DROUND() is a UniVerse function? When I do the following code: X = 2596 * 8.333 * PRINT DROUND(X,2) I get the following error: Array 'DROUND' never dimensioned. From: lar...@wcs-corp.com To: u2-users@listserver.u2ug.org Date: Thu, 14 Oct 2010 09:25:23 -0700 Subject: Re: [U2] how to round to 2 decimals? What's so difficult about ANS = DROUND(N1 * N2, 2) ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam Sent: Thursday, October 14, 2010 8:59 AM To: U2 Users List Subject: Re: [U2] how to round to 2 decimals? Hi Never heard of the DROUND() function in Universe. Anyway, why would I want to use a function syntax when I can do ANS = N1 * N2 'R2' and it is the answer that gets rounded? Easy to write. Easy to read... John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 14 October 2010 16:49 To: 'U2 Users List' Subject: Re: [U2] how to round to 2 decimals? Does UniVerse not support the DROUND() function? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam Sent: Thursday, October 14, 2010 1:02 AM To: U2 Users List Subject: Re: [U2] how to round to 2 decimals? Hi I've always used 'R2' e.g. ANS = N1 * N2 'R2' No scaling, just rounding Regards John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: 13 October 2010 22:22 To: u2-users@listserver.u2ug.org Subject: [U2] how to round to 2 decimals? I'm trying to figure out how to round to 2 decimal places with a floating point in UniVerse For example 2596 x 8.333 = 21,632.468 How would you round that in UniVerse to 21,632.47? Thanks! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This message is attributed to the sender and may not necessarily reflect the view of Travis Perkins plc or its subsidiaries (Travis Perkins). Agreements binding Travis Perkins may not be concluded by means of e-mail communication. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'E-mail transmissions are not secure and Travis Perkins accepts no responsibility for changes made to this message after it was sent. Whilst steps have been taken to ensure that this message is virus free, Travis Perkins accepts no liability for infection and recommends that you scan this e-mail and any attachments. /SPAN/P P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'Part of Travis Perkins plc. Registered Office: Lodge Way House, Lodge Way, Harlestone Road, Northampton, NN5 7UG. /SPAN/P /BODY /HTML ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] how to round to 2 decimals?
:-) Yep, no one would notice a half cent!! Don Robinson From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, October 14, 2010 2:07:00 PM Subject: Re: [U2] how to round to 2 decimals? so, when the bank rounds everyones bank balances down the cent, the system would barely pause.maybe noone would noticehmmm. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Thursday, October 14, 2010 2:05 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] how to round to 2 decimals? oops.. I should have read your post closer. ' one million times' - so yeah that wouldn't make a huge difference but it's still good to know! -Chris Date: Thu, 14 Oct 2010 11:00:08 -0700 From: donr_w...@yahoo.com To: u2-users@listserver.u2ug.org Subject: Re: [U2] how to round to 2 decimals? How about this? X = 2596 * 8.333 ;* [X will contain 21632.468] ANS = INT((X * 100) + .5) / 100 PRINT ANS The (X * 100) changes X to 2163246.8 The + .5 changes X to 2163247.3 The INT() changes X to 2163247 The / 100 changes X to 21632.47 The output will displays 21632.47 Using a FOR NEXT loop, I run INT((21632.468 * 100) + .5) / 100 and the OCONV(21632.468,'MR20') versions one million times and got .84 seconds for the INT version and 4.9 seconds for the OCONV version. I doubt that 4 seconds would make a difference to most programs but every little helps. I also run the OCONV(ICONV(21632.468,'MD2'),'MD2') version and it took 5.1 seconds. My point: There is more than one way to skin a cat! Don Robinson From: Chris Austin cjausti...@hotmail.com To: u2-users@listserver.u2ug.org Sent: Thu, October 14, 2010 12:34:36 PM Subject: Re: [U2] how to round to 2 decimals? Are you sure DROUND() is a UniVerse function? When I do the following code: X = 2596 * 8.333 * PRINT DROUND(X,2) I get the following error: Array 'DROUND' never dimensioned. From: lar...@wcs-corp.com To: u2-users@listserver.u2ug.org Date: Thu, 14 Oct 2010 09:25:23 -0700 Subject: Re: [U2] how to round to 2 decimals? What's so difficult about ANS = DROUND(N1 * N2, 2) ? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam Sent: Thursday, October 14, 2010 8:59 AM To: U2 Users List Subject: Re: [U2] how to round to 2 decimals? Hi Never heard of the DROUND() function in Universe. Anyway, why would I want to use a function syntax when I can do ANS = N1 * N2 'R2' and it is the answer that gets rounded? Easy to write. Easy to read... John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Larry Hiscock Sent: 14 October 2010 16:49 To: 'U2 Users List' Subject: Re: [U2] how to round to 2 decimals? Does UniVerse not support the DROUND() function? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Woollam Sent: Thursday, October 14, 2010 1:02 AM To: U2 Users List Subject: Re: [U2] how to round to 2 decimals? Hi I've always used 'R2' e.g. ANS = N1 * N2 'R2' No scaling, just rounding Regards John Woollam | Group Function Support 1 (Finance Systems) | Travis Perkins PLC | 01604 682751 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: 13 October 2010 22:22 To: u2-users@listserver.u2ug.org Subject: [U2] how to round to 2 decimals? I'm trying to figure out how to round to 2 decimal places with a floating point in UniVerse For example 2596 x 8.333 = 21,632.468 How would you round that in UniVerse to 21,632.47? Thanks! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users html head meta http-equiv=Content-type content=text/html; charset=UTF-8 /head body P style=MARGIN-TOP: 0pt; MARGIN-BOTTOM: 0ptSPAN style=FONT-SIZE: 8.2pt; FONT-FAMILY: 'MS Sans Serif'This e-mail and any attachments are confidential and intended solely for the use of the addressee only. If you have received this message in error, you must not copy, distribute or disclose the contents; please notify the sender immediately and delete the message. /SPAN/P P style
Re: [U2] how to round to 2 decimals?
ROUNDED.VALUE = ICONV(ORIGINAL.VALUE,'MD2') Will convert original to 2163247 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Wednesday, October 13, 2010 2:22 PM To: u2-users@listserver.u2ug.org Subject: [U2] how to round to 2 decimals? I'm trying to figure out how to round to 2 decimal places with a floating point in UniVerse For example 2596 x 8.333 = 21,632.468 How would you round that in UniVerse to 21,632.47? Thanks! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] EMailing from Universe
We've used the email product for UniVerse from Advanced Ware (AWMail) with success. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Warner Sent: Saturday, September 11, 2010 8:31 PM To: u2-users@listserver.u2ug.org Subject: [U2] EMailing from Universe We're started a project where a client wants to email statements to their customers. Has anyone done this with success, and if so, can you point me in a direction? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] SOAP Submission Issues
In the meanwhile, can't you manually add the host header using setRequestHeader function: ReturnCode = setRequestHeader(RequestHandle,'host','www.host.com') ReturnCode 0 - Success 1 - invalid request handle 2 - Invalid header (incompatible with method) 3 - Invalid header value -- from the Ud7.1 Basic Reference Manual Syntax setRequestHeader(request_handle, header_name, header_value) Note: This function is case-sensitive. If you want it to be case-insensitive, you must compile your programs using the BASIC command with the -i option. Description The setRequestHeader function allows the user to set additional headers for a request. Parameters The following table describes each parameter of the syntax. The following table describes the status of each return code. Parameter / Description request_handle The handle to the request returned by createRequest(). header_name The name of the header. header_value The value of the header. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Wally Terhune Sent: Tuesday, July 27, 2010 11:41 AM To: U2 Users List Subject: Re: [U2] SOAP Submission Issues Not my area of expertise, but I wonder if this issue from the 7.2.6 readme applies: Issue 12972 - Problem Description UniBasic -- Prior to this release, a secure CallHTTP (https), or Secure SOAP connection through a proxy server failed with HTTP error 400. The secure HTTP request to the proxy did not comply with RFC 2616, as the 'Host header was missing. With protocol logging enabled, a message similar to the following example appeared in the U2 Protocol Log: CONNECT xxx.com:443 thru proxy... Error writing socket in proxy_connect() Error making proxy CONNECT If you enabled proxy-side logging, a message similar to the following example appeared in the Proxy error log: client sent HTTP/1.1 request without hostname (see RFC2616 section 14.23): The header has been added to the HTTP CONNECT method when Wally Terhune U2 Support Architect Rocket Software 4700 S. Syracuse Street, Suite 400 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Steve Long Sent: Monday, July 26, 2010 11:29 PM To: u2-users@listserver.u2ug.org Subject: [U2] SOAP Submission Issues Hi all - I have a client that I have done some work submitting SOAP requests to existing web services for utilization in their application. I have never had a problem before and submissions have been reliable until now. I have run into an issue with one particular web service where it is reporting an invalid hostname is being submitted. I have enabled Protocol Logging and per the logs, the host is being set to what their web service expects, but when they receive it, it is not in the submission parameters where they expect it. They say the expected info is formatted like this: POST /ws/service.asmx HTTP/1.1 Accept-Encoding: gzip,deflate Content-Type: application/soap+xml;charset=UTF- 8;action=urn:webService/webServiceCall User-Agent: Jakarta Commons-HttpClient/3.1 Host: webservice.server.com Content-Length: 1692 What is actually being submitted is: POST /ws/service.asmx HTTP/1.0 Date: Tue, 27 Jul 2010 05:13:12 GMT SOAPAction: urn:webService/webServiceCall User-Agent: UniData 7.1.x Content-Type: text/xml; charset=utf-8 Content-Length: 1623 Notice the missing Host (among other differences). According to the web service, if I include the Host statement, it will work. I have tested from a SOAP testing app and it does construct it with the Host statement in place, and it does indeed work. Nothing I have tried has enabled me to get past this. Has anyone encountered this or have an suggestions for me to try to get this working? Thanks, Steve Long Spyderweb Techincal Services, Inc. (360) 687-8797 Office (866) 354-5913 Fax www.spyderwebtech.net ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Don Robinson is available for part time work.
Hello, I'm available 2 (or more) days per week to help you with your programming projects. I have experience with several MV databases including Universe, Unidata, jBASE, Reality and AREV. I have experience with AIX, Linux, Windows server and desktop OS's, Apple Macs, networking, Perforce source control and Accuterm GUI screen programming. I live in Cincinnati, Ohio. I have speed internet for remote access and can handle an occasional on-site visit. If interested, contact me directly at donr_w...@yahoo.com or the number below. Thanks, Don Robinson 513-706-6149 (Cell) ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.9 and .Net DLL
DW, Yes, I currently use the Vertex EI interface with the .NET application I'm working on. So do you know just link directly (add voc entry) with the vptrei.dll (enhanced integration) directly in Unidata? And yes, the XML is pretty sweet. Robert, Thanks for the heads-up about regasm. Tony, I did a quick google, but got a bit of search overload. I've written plenty of web services so that's not a huge huddle. I'll take a look at your articles for some refreshers on BASIC and WS. Thank you all for your ideas and helpful advice. Don Verhagen u2-usersrem...@thissoutheast-florida.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Wednesday, July 21, 2010 12:31 AM To: 'U2 Users List' Subject: Re: [U2] Unidata 7.1.9 and .Net DLL Vertex's new code for passing XML is pretty sweet -- it's a different interface, but worth checking out. It's called their 'Enhanced Interface' version. DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Tuesday, July 20, 2010 9:21 PM To: 'U2 Users List' Subject: [U2] Unidata 7.1.9 and .Net DLL Does anyone know if you can hook/link a .NET dll (Managed code) into Unidata 7.1.9 (Windows). I know you can with COM .DLL by creating an E type voc entry. Sample COM DLL Voc entry 1 E 2 E:\Vertex\VertexUtils\VertexDriver.DLL 3 v_LocConnect 4 POINTER 5 CHAR_PTR 6 CHAR_PTR 7 CHAR_PTR 8 CHAR_PTR 9 INT I was hoping to update the VertexDriver.DLL (Currently COM/_cdecl) to a .Net dll. I really hate writing c code. David Wolverton, you out there? I know you have some experience writing c - Vertex utils. I may just end up writing a webservice to handle this and have Unidata call the webservice. Just want to check before I start writing this. Thanks for any assistance. Donald Verhagen u2-usersrem...@thissoutheast-florida.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.9 and .Net DLL
David, I sent you an offline email at your flash.net account from my work email. But I'm glad you detailed it out here. Good news, I sent a support ticket into Vertex about the missing Geocoder functionality in the EI XML interface and was told that it will be in Release 2.9.8 due to be released around September 2010. This means the entire Vertex logic will be able to use request/response XML model that the tax calculation currently uses. (sidenote to those who are wondering what is Vertex) Vertex is a (payroll) tax calculation engine that is updated monthly with changes in the US/Canadian payroll tax tables for Federal, State, Local, County, and School District taxes). I haven't created a tax table in over 15 years with the help of Vertex. This isn't an ad, just an endorsement. Don Verhagen u2-usersrem...@thissoutheast-florida.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Wednesday, July 21, 2010 10:55 AM To: 'U2 Users List' Subject: Re: [U2] Unidata 7.1.9 and .Net DLL Ultimately we are calling a routine as a 'service' passing the XML and receiving back the 'answer' XML - this logic will allow abstraction off the 'core database' machine since the service call can point to any machine -- if they would complete all GeoCode actions with an EI XML interface, we'd be able to be C free... They are a bit slow getting this done -- the whole EI started as a 'skunkworks' project that ended up being marketable, but the GeoCode stuff is another group. On the tax side, the hardest thing was 'mapping' all the fields to a 'file' so the XML translations could just be handled by UniData -- lots of data in the 'EI request'! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Wednesday, July 21, 2010 6:27 AM To: 'U2 Users List' Subject: Re: [U2] Unidata 7.1.9 and .Net DLL DW, Yes, I currently use the Vertex EI interface with the .NET application I'm working on. So do you know just link directly (add voc entry) with the vptrei.dll (enhanced integration) directly in Unidata? And yes, the XML is pretty sweet. Robert, Thanks for the heads-up about regasm. Tony, I did a quick google, but got a bit of search overload. I've written plenty of web services so that's not a huge huddle. I'll take a look at your articles for some refreshers on BASIC and WS. Thank you all for your ideas and helpful advice. Don Verhagen u2-usersrem...@thissoutheast-florida.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Wednesday, July 21, 2010 12:31 AM To: 'U2 Users List' Subject: Re: [U2] Unidata 7.1.9 and .Net DLL Vertex's new code for passing XML is pretty sweet -- it's a different interface, but worth checking out. It's called their 'Enhanced Interface' version. DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Sent: Tuesday, July 20, 2010 9:21 PM To: 'U2 Users List' Subject: [U2] Unidata 7.1.9 and .Net DLL Does anyone know if you can hook/link a .NET dll (Managed code) into Unidata 7.1.9 (Windows). I know you can with COM .DLL by creating an E type voc entry. Sample COM DLL Voc entry 1 E 2 E:\Vertex\VertexUtils\VertexDriver.DLL 3 v_LocConnect 4 POINTER 5 CHAR_PTR 6 CHAR_PTR 7 CHAR_PTR 8 CHAR_PTR 9 INT I was hoping to update the VertexDriver.DLL (Currently COM/_cdecl) to a .Net dll. I really hate writing c code. David Wolverton, you out there? I know you have some experience writing c - Vertex utils. I may just end up writing a webservice to handle this and have Unidata call the webservice. Just want to check before I start writing this. Thanks for any assistance. Donald Verhagen u2-usersrem...@thissoutheast-florida.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.1.9 and .Net DLL
Tony, You can find documentation for it the following manual: Unidata 7.1.x Manual: Developing UniBasic Applications (BASD.pdf) Section: Linking C Programs (Windows Platforms Only) Page: 226-325 I don't use Universe enough to know if it works on that platform. Feel free to contact me offline with any specific questions/details. Don Verhagen u2-usersrem...@thissoutheast-florida.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Wednesday, July 21, 2010 2:22 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unidata 7.1.9 and .Net DLL From Don Verhagen: Does anyone know if you can hook/link a .NET dll (Managed code) into Unidata 7.1.9 (Windows). I know you can with COM .DLL by creating an E type voc entry. Sample COM DLL Voc entry 1 E 2 E:\Vertex\VertexUtils\VertexDriver.DLL 3 v_LocConnect 4 params... I really didn't know that this call-out functionality existed. I know GCI allows for invoking COM from UV. UCI has been equated to GCI but I don't think they're the same at all. Does Unidata support GCI? What is this E item syntax called, and where can I find a doc on it? Does Universe support this E item syntax? Does anyone have any performance data for this E syntax? I'm wondering if DLLs are truly linked and they stay in memory, or if they're dynamically referenced on every invocation. The former is painful only on first execution. The latter would alwould be painful and we might as well Execute/SH. Heck, I can see entire libraries of new functionality being created with this mechanism. Deployment would be Muuuch easier than GCI. Thanks. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Nebula RD sells mv.NET and other Pick/MultiValue products worldwide, and provides related development services remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata 7.1.9 and .Net DLL
Does anyone know if you can hook/link a .NET dll (Managed code) into Unidata 7.1.9 (Windows). I know you can with COM .DLL by creating an E type voc entry. Sample COM DLL Voc entry 1 E 2 E:\Vertex\VertexUtils\VertexDriver.DLL 3 v_LocConnect 4 POINTER 5 CHAR_PTR 6 CHAR_PTR 7 CHAR_PTR 8 CHAR_PTR 9 INT I was hoping to update the VertexDriver.DLL (Currently COM/_cdecl) to a .Net dll. I really hate writing c code. David Wolverton, you out there? I know you have some experience writing c - Vertex utils. I may just end up writing a webservice to handle this and have Unidata call the webservice. Just want to check before I start writing this. Thanks for any assistance. Donald Verhagen u2-usersrem...@thissoutheast-florida.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Copying Universe files with an Index.
Perry, THANKS! I just didn't look in the right manual, it's in userref. Don Robinson From: Perry Taylor perry.tay...@zirmed.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, July 1, 2010 9:27:49 AM Subject: Re: [U2] Copying Universe files with an Index. Have a look at the SET.INDEX command. The path to the index files is store in the file header and you'll need to use SET.INDEX to change it to reflect the new location of the index files. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Don Robinson Sent: Thursday, July 01, 2010 7:26 AM To: u2-users@listserver.u2ug.org Subject: [U2] Copying Universe files with an Index. Hello all, I'm using Universe on AIX and I have a need to copy an Universe file from one account to another for historical usage. Using the AIX cp command takes a couple of minutes but the Index is not useable. Using Universe COPY or Basic read and write takes much longer. I believe the problem is due to Universe storing the full path to the Index files in the header of the data file. Is there anyway to fix the header without corrupting the file? What's the best way to handle this? Thanks, Don Robinson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Printing images
Harold, If you or someone else can pay for it, Print Wizard will do the job plus a lot more. If this isn't an option, then a couple of observations about the code the other person give you. I have been working to get a full page overlay to print. To create the overlay image, I setup a printer in Windows using an HP PCL-5 generic driver and printed the pdf form to a file. Do not use a pcl-6 driver as it's output is very different. As HTH said, the resulting file needs the trailing reset (ESCAPE E) and other stuff removed. A hex editor works best for this. To read the image into Universe, use READBLK instead of READSEQ, just use a big number for the ending byte position. It will ignore line feeds, attribute marks, etc. One PRINT statement will print the whole form/logo. Also, I had to use cursor positioning commands to set the starting position for the data following the printing of the overlay. Without these, I was getting the form on one page and the data on the next. You may contact me directly if you want. donr_work at yahoo.com Don From: iggch...@comcast.net iggch...@comcast.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, May 10, 2010 3:20:46 PM Subject: Re: [U2] Printing images A long time ago, someone shared a way of doing this. Here is what I can recollect... * Create BitMap image * Place image On a document in desired position (ie msword) * Create a new print to File printer using HP PCL type driver * Print document * Using a hex editor, delete last x number of characters * Determine x by starting at the end and locating *rB. Everything * after that is printer reset string. (escEesc%-12345X...) * Save image file from the previous step to a directory accessible from your program * Open and print each line from previous step * sourcepath='/blablabla/':LOGO.ID * openseq sourcepath to file then * loop * readseq line from file else li...@am * until li...@am do * print line * repeat * closeseq file * end Pretty rough but I remember that it was functional. HTH - Original Message - From: Harold Oaks harold.o...@clark.wa.gov To: U2 Users List u2-users@listserver.u2ug.org Sent: Monday, May 10, 2010 2:00:35 PM GMT -06:00 US/Canada Central Subject: [U2] Printing images All: In Universe I am able to use PCL commands to customize printing, fonts, spacing, orientation, etc. I'm sure many of you do this. For example by issuing CHAR(27):'(10U':CHAR(27):'(s1p09v0s6b16602T' in front of text the printing is Arial 9 bold. However, I have been unable to figure out how to print images from within Universe. Something to do with 'bit map', but I can't seem to get it. I have a file containing JPG format images. I can copy a record from this file to a windows directory and easily display the image using windows tools. But, how to get the same binary sent to a printer and print that image? Has anyone been able to do this? Thanks! Harold Harold D. Oaks Sr. Analyst/Programmer Clark County, Washington ph: (360) 397-6121 x4132 fax: (360) 397-2342 This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Writeseq - getting to the EOF
George, Have you tried the SEEK statement, ie, SEEK filehandle, 0 , 2 The 0 (zero) is the offset and the 2 is relative to the end of the file. Caution, untested code! Good luck, Don Robinson From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, March 24, 2010 5:25:31 PM Subject: [U2] Writeseq - getting to the EOF ok. UV 10.0.2 Is there a quick way to get to the end of a file to start appending after an OPENSEQ Otherthan, a loop to READSEQ until it hits the EOF. Right now, that is not a problem, but this file could grow to some considerable size, and that loop might take a little bit to cycle through. I didn't see any options for the OPENSEQ to start at the EOF, and didn't find any commands that would set the eof (other than WEOFSEQ which doesn't seem likely to help). Thanks George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I'm looking for PICK
I will happily accept everyone's wrath. I will also repair anyone's credit for a small fee no matter how bad it is, just send a check for $100.00 to an anonymous PO Box and I'll be sure to get back with you or just email me at my gmail account. If you believe that, you'll probably believe this recruiter can find you a job. The company mentioned has no address, no telephone listing, and no web presence. It's precisely in this economy you want to go with a reputable company and a professional recruiter, otherwise, it may actually prolong someone's unemployment rather than shorten it. The company mentioned has no address, no telephone listing, no web presence. If anyone needs the contact information of professional recruiters at some reputable companies in the US, free to email me. =) As for the future, if it ever becomes that bad to go with this dude, I'll take my chances working the fryer. Don V -Original Message- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] I'm looking for PICK, Universe Unidata professionals for nationwide openings...
1) I do not appreciate the unsolicited email. 2) DON'T send an email with NO BODY and an attachment that is just a freaking word document that you could have typed in body of the email. 3) The use generic free email addresses of roy...@att.net and roycontre...@charter.net is very unprofessional. You should really spend a hundred or two and get a real domain and email address for your company. 4) You list NO COMPANY INFORMATION and/or ADDRESSS. 5) You should not harvest email addresses from the U2UG.org website. If you want to recruit join the email list. 6) This response has been posted on the U2UG email list to warn other members you may spam. 7) I will not now, nor in the future, be in need your services. From: Roy Contreras [mailto:royc...@att.net] Sent: Wednesday, March 17, 2010 2:35 PM To: x...@xx.xxx Subject: I'm looking for PICK, Universe Unidata professionals for nationwide openings... Text of Word Attachment: Pick/Unix Personnel Agency My name is Roy Contreras and I run a Company called Pick/Unix Personnel. I find positions for Pick, Unidata, Universe, UNIX and other Pick related professionals, nationally. If you are open to hearing about new positions available or know of anyone who is considering other opportunities, please let me know. I currently have full-time and consulting position available. I can be contacted via e-mail roycontre...@charter.net or at (817) 449-2038. Thank You. Roy Contreras ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AccuTerm File Transfer
Kevin, As OP suggested, the FT program can be used from the command line. To run from within another program, use the FTX subroutine. Example program: * open and read data to be transfered into ITEM variable. MODE = 'S,K' ;* Send from server to PC using Kermit protocol. FNAME = 'XYZ' ;* Filename on PC. PATH = 'c:\transfer\' ;* aka Windows folder. STAT = '' ;* Will be set if error occurs. CALL FTX(MODE, '', FNAME, PATH, ITEM, '', '', '', '', '', '', STAT) This will send the data in ITEM to the PC with a file name of XYZ in the c:\transfer directory/folder. The PC directory must exist. The following will start the WORDPAD program and display the file. PRINT CHAR(27): CHAR(2): 'wordpad.exe ': PATH: FNAME By changing the mode, you can read the data back into the server and save it, etc. DISCLAIMER! Some of this is from memory so there is no guarantee. See http://www.asent.com/ for more info. Contact Peter Schellenbach, he's been very helpful to me. Good luck, Don Robinson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2UG Elections
Are you logging into mvopen.org? Cheers, Don Robinson From: Symeon Breen syme...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thu, February 4, 2010 4:24:07 PM Subject: Re: [U2] U2UG Elections Sorry it is deffo not there ! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mark Eastwood Sent: 04 February 2010 20:20 To: U2 Users List Subject: Re: [U2] U2UG Elections I voted yesterday - after you Log in, under Membership (left side) you'll see a link for 'U2UG Elections', click it, then go to bottom of page. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, February 04, 2010 1:15 PM To: lbc7...@gmail.com; 'U2 Users List' Subject: Re: [U2] U2UG Elections I have the same i cannot see a link on the home page, I am logged in - u2ug.org ? -Original Message- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Migrating OS
On Unidata the byte conversion program are: In [ud install]\ud\bin convdata.exe - Data files convidx.exe - Indexes (you may be better off rebuilding indexes). convcode.exe - the compile code/object files just type the command with no arguments for their usage. Don Verhagen People 2.0 Global -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Butera Sent: Friday, November 20, 2009 7:23 PM To: Ray Wurlod Cc: U2 Users List Subject: Re: [U2] Migrating OS You need to byte-swap data as part of the migration process. For example, what's stored as (hex) 004E on the Solaris machine (unless it uses Intel chips) is stored as (hex) 4E00 on the Intel-chipped Linux machine. UniVerse, as someone else noted has a utility called fnuxi (also known as format.conv) for implementing byte swapping - like that poster I am not familiar enough with UD to advise on the equivalent utility for that product. Thanks. To my knowledge, Unidata does not have fnuxi, but I know others have tackled this problem so it's solvable. Jeff Butera, Ph.D. Administrative Systems Hampshire College jbut...@hampshire.edu 413-559-5556 I'm just having a conversation with myself - it's about that time. Catherine Butera ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Unidata/SBClient/SBServer Pricing - USA
Group, I'm looking for ballpark pricing for the following Unidata/SB setup for development. I used to deal with IBM directly not a var. I prefer this arrangement but it's not mandatory. I have lost all my US IBM contacts over the last 2 years. What I need is pricing for the following: 5-User Development license for Unidata 7.x for Windows Development License for SBServer or whatever the most current incarnication is. I know there was talk about making SB a .Net component(s). 1-5 SBClient licenses (if the .Net components aren't production ready). Plus Annual support/maintenance for the above. Please feel free to contact me OFFLINE as I don't want to make your pricing info public. =) Thanks, Don Verhagen (donrem...@thissoutheast-florida.com) (please make sure to remove the rem...@this from the email address). ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Converting from mvBase to Universe
Curt, RE: nailed ports. After a lot of hair pulling, I solved this problem on Unix but I don't know if it can be done on Windows and certainly not the same way. On Unix, UV uses a file named unohist but IIRC, on Windows, it uses the PID as the port #. I have a couple of ideas so contact me directly and I may be able to help you. Don Robinson donr_w...@yahoo.com From: Curt Stewart cstewa...@earthlink.net To: u2-users@listserver.u2ug.org Sent: Sunday, July 19, 2009 5:43:05 PM Subject: [U2] Converting from mvBase to Universe I have a client that is considering moving from an mvBase system to a Universe (Windows) system. A lot of their processes are tied to specific ports and ranges. Is there an easy solution in Universe to nail the telnet ports for the users? Also, they use UREAD and UWRITE and take advantage of the MVClients ability to read and write to the local workstation, instead of the server when not using MVClient. I haven't heard of this separation being available in Universe, other than using something like Accuterm, am I right? Or is there an easy way to distinguish between writing to the local drive vs. the server? How has others handled this conversion issue? Right now we're planning on assigning each user a directory on the server to write to, does anyone have any alternate ideas? Thanks for the help, I appreciate hearing your solutions. Thanks, Curt TRI-SYS Consulting u2-users@listserver.u2ug.org ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] More questions on indexing
In Unidata (v6.x) you can issue the command BUILD.INDEX MYFILE ALL. With the KEYWORD ALL it's builds/rebuilds all the indexes that have been created on the file. I would hate to have to remember that INDEX_1 is say, Customer Name, verus a dictionary named CUST_NAME. I would agree with others, I rarely had any need to rebuild any indexes with Unidata, other than part of a file resizing/space considerations. Donald Verhagen People 2.0 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Haskett Sent: Thursday, July 16, 2009 4:52 PM To: U2 Users List Subject: Re: [U2] More questions on indexing Brad: I've defined indexes in my files with dictionary items like INDEX_1, etc. Thus only these dictionaries are ever used for indexing. A file may have 4 or 5 indexes (INDEX_1 - INDEX_4). I wrote another program to do the indexing for a single file or an entire account by executing the command... :ACCT-INDEX CUSTFILE -IINDEX_ ...which will create all the indexes on the CUSTFILE. Also, my dictionary listing will show these indexes separately so it looks like: Dictionary of File: APPO 13:48:38 Jul 16 2009 Dict Name.. Typ # Col-Heading Field-Def... Conversion.. Formt Assoc... @UQ Phr VENDNO CLIEN TNO DISSUE A UTH DESCT DC LOSED INDEX_1 Indx IF DCLOSED N 18L S E THEN CL IENTNO R(%4 ) : UNITNO R(%7) : SE QNO R(%7) @ID D 0 APPO 6RS PONOD 0 PO# 7RS VENDNO D 1 VEND# 5RS CLIENTNOD 2 CLNT 4RS We don't normally rebuild indexes on UD v7.1 or v7.2. HTH, Bill -- -- bradley.sch...@usbank.com said the following on 7/16/2009 1:18 PM: Thanks, Rod. One more thing. I've written a test program to simplify index creation and building. When I run it under type U or type P using BUILD.INDEX or BUILD-INDEX, it gives me the Enter New line to continue... prompt after each screen of *'s. Definitely not desirable for an automated process. It doesn't do this at TCL. How can I work around this? I'd rather not throw a bunch of DATA statements in there. EXECUTE 'DELETE.INDEX LS.INV.NUM N.CONTRACT.KEY' DATA 20 EXECUTE 'CREATE.INDEX LS.INV.NUM N.CONTRACT.KEY' EXECUTE 'BUILD.INDEX LS.INV.NUM N.CONTRACT.KEY' TIA, Brad. Please respond to U2 Users List I think Oracle's indexing scheme is much more complicated that Unidata's, so I don't think you can compare the two. I do rebuild some of the dynamic files on occasion to get some space back. Other than that, I leave them alone and haven't had problems. - Rod Research continues and I have more question for the group: my Oracle buddies rebuild their indexes at least weekly. Seems to be a best practice. Seems odd to not be able to trust that your index is correct. Is this a concern for ud 7.1? TIA, Brad. ud 7.1 AIX 5.3 U.S. BANCORP made the following annotations U.S. BANCORP made the following annotations - Electronic Privacy Notice. This e-mail, and any attachments, contains information that is, or may be, covered by electronic communications privacy laws, and is also confidential and proprietary in nature. If you are not the intended recipient, please be advised that you are legally prohibited from retaining, using, copying, distributing, or otherwise disclosing this information in any manner. Instead, please reply to the sender that you have received this communication in error, and then immediately delete it. Thank you in advance for your cooperation. - ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Simple Export to Excel
Group (I didn't see who the OP was), I have a perl script/unidata program which will do XLS (Excel 2003 and before). It requires that perl be installed and a few *excel.ppms* freely available. The black box unidata driver program handles column heading, formatting, justification, sorting, subtotaling and grouping. I'm working through the OpenXML formats for Office, I've conquered Word 2007 and moving onto Excel 2007 (openxml) next. I will update the group when I finish. If anyone wants the perl/excel2003 scripts and unidata programs let me know. (email: u2ex...@remove-thissoutheast-florida.com) south east (dash) florida dot com Don Verhagen (Plugging along in SQL and .Net where a simple generic empty validation ain't so simple!) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, July 06, 2009 12:55 PM To: U2 Users List Subject: Re: [U2] Simple Export to Excel On Mon, Jul 6, 2009 at 9:59 AM, Larry Hiscock lar...@wcs-corp.com wrote: Or, you can create your export in the Office XML format, and tell excel explicitly what to do with each column of data. Absolutely. But what a time-consuming chore that can be... :-) -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [u2u] UV on Windows question
My Outlook Express 2003 directs replies directly back to the list. -- Don V -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jpb-u2ug Sent: Monday, June 01, 2009 6:51 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [u2u] UV on Windows question How interesting, you can't just reply to the email anymore, you have to change the to address. Jerry Banker From: Dave R [mailto:dave.ra...@juno.com] Sent: Monday, June 01, 2009 3:54 PM To: jpb-u...@hotmail.com Subject: Re: [u2u] UV on Windows question Unix has it's own set of administration tools different the windows administration tools, I don't believe they require about the same knowledge to use, if you are a windows engineer you would like a windows platform and if you are a Unix engineer you would prefer Unix. Even thought I use a Windows platform I prefer Unix systems as a platform for a Multi-Value system. If you want to purchase a new system then I would go to Reality (contact Northgate-IS, John Semen or Mark Pick). It is the rated by the experts as the best of the systems, Unidata would be next, and UniVerse would be 3rd. The first reason is that Unix systems are not susceptible by Windows viruses. The second reason is security, Most windows hackers are complete lost in UNIX. The Unix systems are more robust. The file management is improved in Unix and The Unix OS was designed for multi users and by mainframe software engineers who have a far more knowledge of multi user environments. Most companies hire windows network engineers and they don't like the idea of Unix platforms. However most large companies run Unix or Aix or Hpux for the platform for Reality or U2. Some other considerations would be if you are coming from a different Multi-Value package like Pick D2 or mvBase, Reality and UniVerse have switches to creating an environment to run that flavor of Multi-Value, requiring little to no conversion of the software and database. A big cost factor in the conversion. Dave R. 949 757 8519 (work) eFax (815)4259364 -- Original Message -- From: JPB-U2UG jpb-u...@hotmail.com To: u2-users@listserver.u2ug.org Subject: [u2u] UV on Windows question Date: Sat, 30 May 2009 16:00:37 -0500 I've never worked with UV on Windows so I would like to know, apart from the obvious differences of the operating system, is there much difference in administering the database in Windows as compared to Linux/Unix. Criminal Lawyers - Click here. http://thirdpartyoffers.juno.com/TGL2142/fc/BLSrjpTOVoK8MNQ2j cygQ1UHaGxeSYzU7qCu4EnncAfGU1lK5Ikr5JJDuhy/ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Another probably simple SB+ issue.
Jeff, Of course the goal here, according to management, is to migrate to Oracle so that's probably a moot point. You will have much BIGGER problems then! ;-) Don Robinson 513-706-6149 (Cell) donr_w...@yahoo.com From: Jeff Ritchie jritc...@lawsocnsw.asn.au To: u2-users@listserver.u2ug.org Sent: Thursday, May 7, 2009 12:22:18 AM Subject: RE: [U2] Another probably simple SB+ issue. G, Advice at this stage would be not to replicate as there appears to be a bug in SBClient, i.e. once you get the issue happening there's no way to reverse it that I know of. 1. Double click an SB+ item to bring up the oonnect screen, the one with the telephone, computers, satelite et al images. 2. From the top window menu select File. 3. From the drop down menu select Print Options. 4. Tick Use Windows Print Drivers 5. Click the OK button. Note even after leaving and returning to the Print Options window the Use Windows Print Drivers appears unclicked, that's a bug. 6. Connect to an SB+ session, selecting GUI mode. 7. Once in SB+ select a menu to go one down from the first menu you see. 8. You should now be seeing an icon bar below the top drop down menu, think this may have to be setup. 9. Click on the printer icon to do a page dump and it no longer goes direct to the printer. We have managed to reproduce on three machines but no one can work out how to fix it. Thinking if we canned the whole SB+ thing and went with a web interface this would be a whole bunch easier in the long run. Of course the goal here, according to management, is to migrate to Oracle so that's probably a moot point :( Cheers, Jeff -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of apogee79 Sent: Thursday, 7 May 2009 1:47 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Another probably simple SB+ issue. Hi, I am not able to duplicate the problem. Can you please outline the exact steps. I am not able to find the small printer icon on the top. Is it application related or SB+ client window related? G -- View this message in context: http://www.nabble.com/Another-probably-simple-SB%2B-issue.-tp23399884p2341973 0.html Sent from the U2 - Users mailing list archive at Nabble.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] U2 Application / Solutions providers list? PICK / U2 Hits? Any ERP Light applications out there?
Scott, If you aren't aware of OHM systems, give them a look. I'm not sure I would call it light but that is for you to decide. http://www.ohmworld.com/ Yes, there was a Pick hits book, I just threw away a early 90's copy. I haven't seen anything like it for a long time. Maybe Spectrum could/should do one. I know of another package (not mine) that is available on a sort of one of a kind basis, contact me directly at donr_w...@yahoo.com if interested. Regards, Don Robinson 513-706-6149 (Cell) From: Scott Richardson cheetah...@comcast.net To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org Sent: Tuesday, April 21, 2009 8:08:23 AM Subject: [U2] U2 Application / Solutions providers list? PICK / U2 Hits? Any ERP Light applications out there? Hello folks, A good number of years ago, there used to be a published list / document / book of various PICK / U2 Solutions Providers or Value Added Resellers and ISV (aka Independent Software Vendors) listing the VAR or ISV, their vertical markets served, and descriptions of the applications they provided, (I think it was called PICK HITS or something like that?). Is there anything similar produced/published these days? It would appear that such a document would be an excellent vehicle for the continued proliferation of the multi-valued market. (IBM U2 Marketing - where are you?) I too am out of work, but in discussions with a small local MFG type operation about an IT Manager opportunity. One of the main aspects they're looking for in this IT Manager position is someone to find, and implement an ERP Light application. It should be noted these folks have previously attempted a Epicor solution that they were sold that when it came time to implement, they discovered that this Epicor product did not do what this company needed at all. This company was promised what they wanted it to do could be done, but then learned well AFTER shelling out big $$, (after expected delivery time of the mod's), that what they wanted was not currently possible, but could be attained with 10X the previously shelled out big $$ and a couple of years of development time from the Epicor development team. Needless to say, that implementation fell flat on its face, and now they're out looking again. Looking for something that does Sales Orders and Sales History, Inventory Control, AP / AR Financials and maybe a few other basic MFG type related applications. Surprisingly, these folks are not using any pre-existing package, but using a lot of home grown type spread sheet based improvised solutions. Ideas? Suggestions? Thank you. -- Regards, Scott Richardson ** Sr. Systems Engineer * IT Consultant Marlborough, MA 01752 CheetahFTL can be contact at comcast.net ** --- 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 Application / Solutions providers list? PICK / U2 Hits? Any ERP Light applications out there?
Norman, I don't know anything about Ohmart but Google brings up an Ohmart/Vega manufacturing co. in Cincinnati. I don't think OHM Systems has any connection to it but it's possible since I've heard that it was converted from Cobol way back when. OHM was called Mandata in the 70's or 80's. The president is Suresh Anbil. They have a number of modules for a range of manufacturing companies. Regards, Don Robinson From: Norman Morgan nmor...@brake.com To: u2-users@listserver.u2ug.org Sent: Tuesday, April 21, 2009 4:51:05 PM Subject: RE: [U2] U2 Application / Solutions providers list? PICK / U2 Hits? Any ERP Light applications out there? If you aren't aware of OHM systems, give them a look. I'm not sure I would call it light but that is for you to decide. http://www.ohmworld.com/ What do you know about the history of this company? Could they be a spinoff from Ohmart, a manufacturing company in Cincinnati? If so, that sure brings back some memories. Back in 1978 I worked for Honeywell Information Systems in Cincy and one of the first accounts I worked at was Ohmart, helping them convert from an NCR Century series to a Honeywell Level-62. I still have nightmares about the Neat/3 to COBOL conversion. Norman Morgan nmor...@brake.com http://www.brake.com Why would I want to be normal? Normal is DULL. --- 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] UV to SAP migration disaster
Hello all, This is an interesting subject. I remember reading several years ago that TI (Texas Instruments) spent $50 million on SAP and gave up. SAP must be a bear to implement but TI should have known better. I have personal knowledge of several migrations/conversions that didn't go so well. All of them suffered due to under estimating the amount of work involved. Of course, a lot of the work was due to the sloppiness of the old code, multiple and obsolete programs, program bugs, etc. But the primary cause of the under estimate was the eagerness of the sales person(s) to get the deal and not listen to the programmers. An Universe to jBASE migration project was abandoned after many months for several reasons. An Ultimate to Universe migration is alive and running but took several times as long as estimated. A GUI frontend addition to a UV system took a lot longer than the customer thought it should due to scope creep and a lack of planning and control. An Unidate to SQL migration is in production but still doesn't do all the things the Unidata system did. A Reality to Oracle migration dragged on for 5 years and then the company was bought out by a company using SAP so they switched to SAP. They are still in business so I guess that it's working for them. In another case, the programmer has built a very well organized and functional system but the PHB's are switching to something else. I don't know why but I bet it's not due to a favorable ROI. Why does MV lose out to the SAP's of the world? Marketing! Even IBM does a poor job of promoting U2 and they have the money to do so. The others in general have very little marketing money compared to Oracle and Microsoft. Other factors include too many vendors, each with a share of a rather small pie. Even when systems are brought together like Unidata and Universe or Mvbase and D3, the vendors choose to maintain separate versions. As long as there are so many versions, one of them will never have the resources to have effective marketing. Of course, there are a lot of other factors. Perhaps a bigger push into the open source space would help. I recently read that MySQL has a long history of bugs, like losing all your data, and some of them will not be fixed. Yet it remains the most popular free database. We have a better mouse trap, why doesn't the world know it? Just, my 2 cents worth. BTW, I'm looking for programming work! Universe, Unidata, jBASE, etc. Linux, Aix, Windows, Mac. Don Robinson donr_w...@yahoo.com From: John Hester jhes...@momtex.com To: u2-users@listserver.u2ug.org Sent: Friday, April 17, 2009 3:18:28 PM Subject: [U2] UV to SAP migration disaster There were a few posts back in January about Denver jewelry retailer Shane Co. and their disastrous migration from UV to SAP. Today they're starring in an eWeek slideshow about I.T. disasters: http://www.baselinemag.com/c/a/IT-Management/Dirty-Dozen-Inside-12-IT-Di sasters-874085/?kc=EWKNLEDP04172009A They're in slides 7 and 8. The slideshow itself isn't good for much more than a little gee, I'm sure glad that didn't happen to me shadenfreude, but I thought it was interesting that a failed migration away from UV caught the attention of the mainstream I.T. press. -John --- 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] Leaving U2 World to the Dark Side (SQL)
Brian, Thanks for book suggestions as this is one of the concepts that I am having issues with. Understanding the database/languages, SQL and Csharp, are just a how-to problem which I've got a pretty decent grasp of. However, RECORD LOCKING and concurrency seems to be the white elephant in room that I have seen less written about and worse even less thought out in the application(s) that I'm having to deal with. Thanks, Don Verhagen -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Sunday, February 22, 2009 12:39 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Leaving U2 World to the Dark Side (SQL) Hi Don I'm sure you'll excel there - especially with your depth of real-world (ie multivalue) knowledge behind you! But I would highly recommend reading whatever is the latest book on SQL Server and .Net by Roger Jennings before you do (check out Wrox press). Apart from the stuff pointed out here about maintaining three tier architectures and not just using data binding (actually, data binding to classes is fine, just binding to data sets is crap) the real bitch is concurrency control and how to handle it when you need to start looking at merge processing. There's a lot of good advise on that in the Roger Jennings books - and details on some hidden language features to make SQL Server access in .Net a lot more performant... Best of luck. Brian -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Don Verhagen Sent: 19 February 2009 11:04 To: u2-users@listserver.u2ug.org Subject: [U2] Leaving U2 World to the Dark Side (SQL) To those that know me on this group. I have been using the Unidata databases since 1998 when introduced to it by my former CIO. Over the years and throughout my IT career, it has served me well. Decreasing software production and maintenance costs, while at the same time increasing the value of the software I (we) developed to solve complex business solutions. I have accepted an Application Development management position with a company here in the Philadelphia area. However, they are not a U2 shop. I view this opportunity as a chance to build my skills in and around the .NET platform and evaluate the use MSSQL in a true business application that I myself have built on a U2 platform in a previous time. While this doesn't exclusively rule out U2 in the future, for now, I'll be in SQL-land. Just wanted give a heads up to those that know me here. Don Verhagen Application Development Manager People 2.0 www.people20.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/
[U2] Leaving U2 World to the Dark Side (SQL)
To those that know me on this group. I have been using the Unidata databases since 1998 when introduced to it by my former CIO. Over the years and throughout my IT career, it has served me well. Decreasing software production and maintenance costs, while at the same time increasing the value of the software I (we) developed to solve complex business solutions. I have accepted an Application Development management position with a company here in the Philadelphia area. However, they are not a U2 shop. I view this opportunity as a chance to build my skills in and around the .NET platform and evaluate the use MSSQL in a true business application that I myself have built on a U2 platform in a previous time. While this doesn't exclusively rule out U2 in the future, for now, I'll be in SQL-land. Just wanted give a heads up to those that know me here. Don Verhagen Application Development Manager People 2.0 www.people20.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PCL Help
Is the column width on the SETPTR command large enough? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Caminiti, Marc Sent: Friday, November 28, 2008 8:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] PCL Help I was wondering if anyone could help We recently upgraded to Universe 10.2.7 on Red Hat Enterprise Linux 5.2 and are now having problems printing out compressed reports on a HP LaserJet 4050 For the compressed reports, I send the PCL codes to switch the printer to landscape and to compress to 17cpi. When the report prints, it is only printing the first line of data and nothing else. It is compressing and in landscape. If I send it to a file, all of the data is there. Below is what is being sent. The only thing that is printing is the MC 10:41:09am 28 Nov 2008 BIKE NASHBAR PAGE 1 Within RedHat (CUPS) the make Model is Local Raw Printer. Even when I try without any compression codes, it only prints the first line of data. When I have the RedHat (CUPS) make model to HP LaserJet 4050, the non-compressed/non-landscaped print, prints fine. But when I try and send the PCL codes, it just spits out plan sheets of paper. Any suggestions will be greatly appreciated. Already spend 3 1/2 hours of different combinations and cannot come up with anything that works. Thanks in advance Marc l1O(s22H MC 10:41:09am 28 Nov 2008 BIKE NASHBAR PAGE 1 DAILY PURCHASING REPORT AS OF 28 Nov 2008 BYR PGC ITEM NUMBER. DESCRIPTION QAV.. QOR. QOH.. ONORD DLD.. WK1.. WK2.. WK3.. WK4.. YACT YTD LY DMD.. MSRP $ CAT $. WEB $. LAST. EXT'D COST MARGIN PO #'S. VEND# ST INV PIC. LS. COST. LIFE TKV N IS-TEST2-A BLAH 0 0 0 0 0 0 0 0 0 0 2.50 2.500 *** 0.500 0.000 80.00% A JB N IS-TEST-DEVON IS TEST SKU 0 0 0 0 0 0 0 0 0 0 2.00 2.000 2.00 0.001 0.000 99.95% 6103 A TKV N IS-TEST-JIM IS TEST SKU 0 0 0 0 0 0 0 0 0 0 2.00 2.000 2.00 0.001 0.000 99.95% 6103 A JB N IS-TEST-MARC IS TEST SKU 0 0 0 1 05/15 0 0 0 0 0 0 0 2.00 2.000 2.00 0.001 0.000 99.95% 20325 9 A 1 03/31 20390 6103 1 10/21 21120 6103 1 07/09 6103-12 6103 3 1 11/03 6103-MC 6103 1 11/19 6103MAR 6103 C TKV N IS-TEST-TAMMY IS TEST SKU 0 0 0 0 0 0 0 0 0 0 2.00 2.000 2.00 0.001 0.000 99.95% 6103 A *** 0 0 0 6 0 0 0 0 0.000 Marc Caminiti IS Manager Nashbar Direct, Inc 6103 State Route 446 Canfield, OH 44406 330.533.1989, ext 336 330.702.9733, fax Reality is merely an illusion, albeit a very persistent one CONFIDENTIALITY NOTICE: This e-mail and any attachments may contain confidential information that is legally privileged. The information is solely for the use of the intended recipient(s). Any disclosure, copying, distribution, or other use of this information is strictly prohibited. If you have received this e-mail in error, please notify the sender by return e-mail and delete this message. --- 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] Green Software - Green Business
Susan, While the below changes may result in green results I tend to believe the main motivation behind most of the changes were monetary not environmental. Every green change has monetary benefit to the business owner. 1) Software and Documentation - No CD production costs / No Reams of Paper 2) Don't commute / Employees don't commute -- No office building rent/lease, a/c, water, etc. 3) Travel -- Obvious, however, it may be like me and I like to keep me shoes on in public. =) I think the question is what really motivated the change. Money (and convenience) or green? Would you make a green change if it *cost you more* money than not going green. And as a side note, I hate green, the movement, the color. Can't we go blue? The sky is blue, so is the ocean, so is the porn..., damn it, blue is out. Don Verhagen Commuting 60 miles a day in 5.7L Hemi SUV with the a/c on high and the windows open. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Friday, July 25, 2008 7:25 AM To: u2-users@listserver.u2ug.org Subject: [U2] Green Software - Green Business This idea is interesting, though. Is this bordering - or boldly going - into an off-topic discussion? Software companies (and departments) are among the types of organizations that can most easily lend themselves to Kermit-chrome. I can't say that I require payment by Paypal - my customers' are businesses that have accounting departments and pay cycles and all kinds of things that I don't feel are my right to force them to circumvent in order to do business with me. But I do provide the software and the documentation via electronic media, I avoid unnecessary paper, I don't commute and the folks that do work for me also do it from home. I do upgrades and training remotely with more and more use of web-based meetings. So less flying my carbon footprint around (which also conserves my more personal energy!) So far my efforts to go green have been very easy. They corresponded with technology advances, good sense budget monitoring and convenience. That's a triple win! I would be interested in hearing about other companies who are making any efforts and what kind of efforts to go green. Replacing monitors? Lowering the power settings? (I'd have a hard time seeing my laptop screen!) What else is anyone doing or thinking of doing? Curiously and even spuriously yours, Susan J. --- 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] Multiple columns from a LIST statement?
Edward,
Take a look at the LIST-LABEL command.
I don't have an Unidata system
handy so I did this in jBASE.
jsh ~ --LIST-LABEL MD
Cols,Rows,Skip,Indent,Size,Spaces{,C} :4,1,0,0,15,2
PAGE
110:10:02 16 JUL 2008
ENTER.FLDSPLYWIN.FTTOASC BLOCK-TERM NSELECT
LOADT
AUX.PGM SELECT-INDEX PIX.GUI.FORM.F
TERM
ECOPYPIX.GUI.CONTROL F/REALLOC
L/UPDENTER.VAL
WIN.DDE MEMO.ENTRY
WIN.TWUSESET-STACKCUSTOM.OPTIONS
WO.OPTIONS
CREATE-FILE S/AMCLFQ*0LOGOFF
.
.
.
The
LIST-LABEL command allows sorting, selecting, etc.
Good luck,
Don Robinson
Ashwood Computer Co.
513-563-2800
- Original Message
From: Edward
Brown [EMAIL PROTECTED]
To: u2-users@listserver.u2ug.org
Sent: Wednesday,
July 16, 2008 7:34:32 AM
Subject: [U2] Multiple columns from a LIST statement?
Hello,
This is a unidata (7.1) reporting question, and I'm asking because
although I can't find the answer in the documentation, I do think I've
seen it
once on another developer's screen.
Suppose I list a file with a command like
LIST ACCOUNTS. I'd get a list
of the IDs down the left hand side of the page
but a lot of wasted space
elsewhere - and a maximum of 22 / 60ish records per
screen / A4 page. So
what I'm wondering is if there's a way to have the report
make use of
multiple columns, using the horizontal space available before
jumping to
the next page?
Thanks
Edward
-
--
Please remember to recycle wherever possible.
Reduce, reuse,
recycle, think do you need to print this e-mail?
-
--
This e-mail and any attachment(s), is confidential and may be
legally
privileged. It is intended solely for the addressee. If you are not
the
addressee, dissemination, copying or use of this e-mail or any of its
content
is prohibited and may be unlawful. If you are not the intended
recipient
please inform the sender immediately and destroy the e-mail, any
attachment(s)
and any copies. All liability for viruses is excluded to the
fullest extent
permitted by law. It is your responsibility to scan or
otherwise check this
email and any attachment(s). Unless otherwise stated (i)
views expressed in
this message are those of the individual sender (ii) no
contract may be
construed by this e-mail. Emails may be monitored and you are
taken to consent
to this monitoring.
Civica Services Limited, Company No.
02374268; Civica UK Limited, Company No.
01628868
Both companies are
registered in England and Wales and each has its registered
office at 2
Burston Road, Putney, London, SW15 6AR.
-
--
---
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] Extra Form Feed from .prn File Followed by Text
We're assuming that there must be some sort of form-feed character (or other sequence that the printer is using to generate a form-feed) but have not actually checked all of the info due to the size of the prn files. We were able to eliminate the form-feed by stripping every occurrence of CHAR(12), but that distorted some of the text box and bitmap output on the form. As is usually done, after converting the prn file to hex, we stripped all the 1B45, 1B252D313233..., 1B266C... printer reset, orientation and paper source sequences, but we must be missing something... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Rasmussen Sent: Friday, July 11, 2008 10:06 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Extra Form Feed from .prn File Followed by Text On Thu, 10 Jul 2008, Don P. Nagai wrote: Help! Im trying to print a form created from Word combined with text. This method has always worked when creating prn files using a PCL5/5e driver, removing the standard escape sequences that trigger form feeds, and then sending the trimmed file in RAW format to an HP printer running either PCL5 or 6. Its worked fine until now. A new customer has Windows Server 2003 x64, an HP P1505n Laser Jet and the prn files were created with XP Pro drivers. Now every time we attempt to print, the form comes out on one page and the text on the next page. If we build the prn files for an older HP model (say Laser Jet 1300 PCL5e) we get a single page, but the text and portions of the form are garbled. Ive contacted HP and their suggestion was to use Laser Jet 6L drivers. The print jobs still generated the extra form feed. Do you know that there's an added formfeed, or might there be something else added which implicitly causes a formfeed? That is, have you looked at the data that the printer is actually getting, by capturing your combined output to a file? Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: [EMAIL PROTECTED] company e-mail: [EMAIL PROTECTED] voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 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/
[U2] Extra Form Feed from .prn File Followed by Text
Help! Im trying to print a form created from Word combined with text. This method has always worked when creating prn files using a PCL5/5e driver, removing the standard escape sequences that trigger form feeds, and then sending the trimmed file in RAW format to an HP printer running either PCL5 or 6. Its worked fine until now. A new customer has Windows Server 2003 x64, an HP P1505n Laser Jet and the prn files were created with XP Pro drivers. Now every time we attempt to print, the form comes out on one page and the text on the next page. If we build the prn files for an older HP model (say Laser Jet 1300 PCL5e) we get a single page, but the text and portions of the form are garbled. Ive contacted HP and their suggestion was to use Laser Jet 6L drivers. The print jobs still generated the extra form feed. Any suggestions? Thanks in advance. Don --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD
John, Try using lower case list, this will force ECLTYPE U (Unidata) flavor. Don Verhagen - Original Message - From: John Kent [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Tuesday, June 03, 2008 6:41 PM Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD | Bill, |not for me though | | LIST STK EVAL DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) 09:01:48 04 Jun 2008 1 | STK... | | Illegal attribute: | select criteria EVAL is not a field. | | whereas an itype will | ED DICT STK JAK | Top of JAK in DICT STK, 6 lines, 50 characters. | 001: I | 002: DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) | 003: MD0 | | i am not familiar with Unidata nor they way this machine is configured but | it annoying when simple things like this dont work | | jak | | - Original Message - | From: Bill Haskett [EMAIL PROTECTED] | To: u2-users@listserver.u2ug.org | Sent: Tuesday, June 03, 2008 7:06 PM | Subject: RE: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD | | | Jak: | | This worked fine for me in an EVAL. UD v7.1 in Win 2K3 with ECLTYPE = | Pick. | | :list APOPEN ACCTS AMTS EVAL DCOUNT(EXTRACT(@RECORD, 9, 0, 0), @VM) | COL.HDG Cnt | | APOPEN ACCT. ACCT/AMTS Cnt... | | 69*7 2090270.06 1 | 830*38779 3060120.64 2 |3070111.13 | 830*38750 3060 63.03 2 |3070 51.78 | 830*38895 3060 37.15 2 |3070 52.51 | | Bill | | -Original Message- | From: [EMAIL PROTECTED] [mailto:owner-u2- | [EMAIL PROTECTED] On Behalf Of John Kent | Sent: Monday, June 02, 2008 8:11 PM | To: u2-users@listserver.u2ug.org | Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD | | Jeff, | what actually worked was... | | DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) | | doesn't seem to work in an EVAL though | eg | LIST STK EVAL DCOUNT(EXTRACT(@RECORD,30,0,0),@VM) A30 | | jak | - Original Message - | From: John Kent [EMAIL PROTECTED] | To: u2-users@listserver.u2ug.org | Sent: Tuesday, June 03, 2008 11:38 AM | Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype @RECORD | | | Jeff, | that'll do, thanks | jak | - Original Message - | From: Jeff Butera [EMAIL PROTECTED] | To: u2-users@listserver.u2ug.org | Sent: Tuesday, June 03, 2008 11:08 AM | Subject: Re: [U2] Is there a UNIDATA equivalent of Universe Itype | @RECORD | | | On Tue, 3 Jun 2008, John Kent wrote: | | Ken, | i want to create a simple dict item like | | ED DICT STK JAK | Top of JAK in DICT STK, 6 lines, 38 characters. | *--: P7 | 001: I | 002: DCOUNT(@RECORD30,@VM) | | Try this: | | DCOUNT(EXTRACT(@RECORD,@AM,30),@VM) | | Jeff Butera, Ph.D. | Administrative Systems | Hampshire College | [EMAIL PROTECTED] | 413-559-5556 | --- | 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] OT: Textpad Syntax File for Unidata
Group, I was wondering if any else out there uses a text editor TEXTPAD and has already created a syntax file for it. If so, please email offline or link. Thanks, Don Verhagen --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Time Travel
I own the domain. It's not hosted by myself here in the frigid 82F degree winter. Donald Verhagen ([EMAIL PROTECTED]) Chief Information Officer - Tandem Voice: 561.226.8261 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Monday, November 26, 2007 2:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel I thought that the list server was located in Australia but when I looked it up in whois it shows up in Florida and administered by Donald Verhagen!? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 26, 2007 10:56 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel I have to add my two bits. Okay, I don't 'have' to... I use the exact same email group software (majordomo 1.94.5) on my 'home' system with over 7000 subscribers to over 180 different email groups. Our groups never see the delays the members of this group see, so with all due respect, there's something different happening that's causing the lags. We often see as many as 200 emails a second going out of our server, which is an 800mghz PIII with 120GB disk, no mirroring (I know, bad idea) and running fedora core 4 (old...). Our group members get their emails back within seconds, literally. I send an email to this group, and it sometimes takes an hour or so before I see it come back to me. I send an email to one of my groups at home, and I get it back within seconds. Now then, with that said, I've also added bulk_mailer to my email group server so maybe that speeds things up a great deal. I don't know. I did it so I would quit getting the annoying 'too many email connections from your server' errors I see from aol, hotmail, msn, yahoo, netscape, netzero, juno, gmail, . . . ad infinitum of the 'big' email hosts. My point? none really, other than to show that Charles' nice numerically explained _time travel_ doesn't match my real-life experience with my own majordomo server... I don't know why, they just aren't the same. Karl quote who=Symeon Breen Or upgrade to a forum based group - just my standard gripe about email lists ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator Sent: 26 November 2007 06:03 To: u2-users@listserver.u2ug.org Subject: [U2] Time Travel To fix this problem, you'd have to redesign the methods under which the internet manages and routes mail. - Charles Barouch, Moderator --- 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/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- 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 Travel
Let me rephrase that. I donated the funds for the domain name and registered it. U2UG owns the domain in whole. I love whois..I should have paid for that privacy thingie too. Donald Verhagen ([EMAIL PROTECTED]) Chief Information Officer - Tandem Voice: 561.226.8261 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Banker Sent: Monday, November 26, 2007 2:33 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel I thought that the list server was located in Australia but when I looked it up in whois it shows up in Florida and administered by Donald Verhagen!? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, November 26, 2007 10:56 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Time Travel I have to add my two bits. Okay, I don't 'have' to... I use the exact same email group software (majordomo 1.94.5) on my 'home' system with over 7000 subscribers to over 180 different email groups. Our groups never see the delays the members of this group see, so with all due respect, there's something different happening that's causing the lags. We often see as many as 200 emails a second going out of our server, which is an 800mghz PIII with 120GB disk, no mirroring (I know, bad idea) and running fedora core 4 (old...). Our group members get their emails back within seconds, literally. I send an email to this group, and it sometimes takes an hour or so before I see it come back to me. I send an email to one of my groups at home, and I get it back within seconds. Now then, with that said, I've also added bulk_mailer to my email group server so maybe that speeds things up a great deal. I don't know. I did it so I would quit getting the annoying 'too many email connections from your server' errors I see from aol, hotmail, msn, yahoo, netscape, netzero, juno, gmail, . . . ad infinitum of the 'big' email hosts. My point? none really, other than to show that Charles' nice numerically explained _time travel_ doesn't match my real-life experience with my own majordomo server... I don't know why, they just aren't the same. Karl quote who=Symeon Breen Or upgrade to a forum based group - just my standard gripe about email lists ;) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Moderator Sent: 26 November 2007 06:03 To: u2-users@listserver.u2ug.org Subject: [U2] Time Travel To fix this problem, you'd have to redesign the methods under which the internet manages and routes mail. - Charles Barouch, Moderator --- 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/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- 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] RE: Populating Excel Templates from Universe
A big thank you to all who responded to my question. I really appreciate your suggestions and Im sure with your help well get this problem solved. Thanks again. Don --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Populating Excel Templates from UniVerse
Hello All: Just wondering what methods would be suggested for populating Excel templates (invoices, work orders, etc.) with data from UniVerse. Weve run into problems with the newer HP printers no longer supporting PCL commands and are looking for alternative forms printing options. Thanks in advance for any suggestions. Don --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] SQL query locks
Take a look at the nolock query hint. On 8/27/07, Pamela J Robbins [EMAIL PROTECTED] wrote: Hi, We have a Cold Fusion app that is using SQL queries. It's locking records, unfortunately as many as 100 at a time. Is there a way to do the query without locking records? We're not updating anything. Pam -- Pamela J Robbins New Bolton Center Senior Programmer AnalystSchool of Veterinary Medicine [EMAIL PROTECTED] University of Pennsylvania 610-925-6438 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Don Kibbey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Large-scale scanner / OCR devices and interfaces to UniVerse {Unclassified}
I've been involved with scanning invoices in bulk for years with a large law firm. We don't do any sort of OCR on them, we simply tag them with a barcode value used to link the image with the hand keyed record. UniVerse is simply the data repository. My last experience with OCR type devices was with Hendrix machines way back in the 80's. Even then, they were pretty good at processing OCRA type face documents for our customer (the US Military). Today's OCR products are much imporoved. I would imagine your process will involve three stages, scan to pdf, OCR system and then into UniVerse. All three steps can be linked together with simple directory transfers of the data. Quality control will be the big issue. You may find that you have to task some poor soul to verify the OCR work prior to import into UniVerse. -- Don Kibbey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Socket API problem
As the only problem seems to be the licensing method, I think I would try to engage IBM to see what the options are. Perhaps a per processor license could be worked out. -- Don Kibbey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniData 7.1 vs. MS SQL 2005 performance
Just looked at the copy of Pick BASIC I have on my desktop and sure enough, the technical editor is Mr. Clifton Oliver. So, he sold at least one of those books. -- Don Kibbey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] RE: mv.NET and UO
The current system I work on (not U2 based) uses a vb6 front end that communicates via custom tcp/ip libraries to a backend component running on a windows server within the MKS (unix) environment calling into informix 4gl code that has been compiled against a translation library to work with sql server 2005. Users are currently wondering why it's all so god awful slow :-) There's much to be said for a quick and simple telnet interface. -- Don Kibbey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniData 7.1 vs. MS SQL 2005 performance
Interesting thread. Even though I don't really have much to do with UniVerse these days, I still enjoy reading (and learning from) these forums. I've been a long time user of both UniVerse and SQL Server. Developed many things using one, the other or both db's as data sources. I would say that if your a Java shop, go with UniVerse, if your using .Net go with SQL Server. It's just too easy to work with data in the .Net Sql Server world. Not quite so easy to go .net - UniVerse. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe and virtual machines
I've used vmware for development work and as a means of converting data from one system to another. Works very well if you run it on a machine with dual core's, adequate memory and more than one hard drive. Works best if you can put the vm's files onto their own hard drive. -- Don Kibbey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] ABAP SAP
Sounds alot like the current system I'm working on. It's Informix compiled down to c++ and then run on a sql 2005 server. The front end is done in vb6 and the web servers are a patchwork of asp and vb.net and c#.net. This frankinstien was purchased to replace the old Pick system running on UniVerse. The pointy headed bosses are starting to realize that the elder geek was not just blowing smoke when he warned them the new system would be nothing but trouble. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] List of MV Database Experts
Embrace the dark side Windows .Net SQL Server 2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: Re:[U2] New UV system
This guy wants low cost equipment. If they have been running on a 486 box up until now, speed is certainly not an issue. I'd suggest browsing ebay for a 1-2 year old dual core server or workstation. You'd be surprised at how cheap they are once they come off lease. I do this myself every couple of years. Since this is a business, I'd recommend tossing the drives that come with the system (they will have already been used, misused and abused). Get a couple new scsi type drives to run as a mirrored set. Grab the latest copy of SuSE (or your choice of linux) and your set. If you'd like to increase costs a bit, you can alway's purchase Windows Server 2003. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
