Re: [U2] Read yourself
We have something similar that is built into our Visage product that we call Snippet Technology. It is totally language neutral, and at a pure programming level provides a recursive, extensible pre-compiler that can produce platform specific and optimised code from a single code base, but we also harness the facility to power things like our multi-lingual capabilities and web page generation. However, I still cannot see where Will has explained why/what he will do once he has program code in a variable ... what is the end game/objective? Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Sent: Tuesday, May 13, 2014 3:28 PM To: U2 Users List Subject: Re: [U2] Read yourself I saw on one PICK system, a precompiler language. It was the same as PICK/BASIC, but had a preprocessor to it. So, for example to get the user number on a Universe system you would use USER.NO=@USER.NO On a PICK system, it would be USER.NO=OCONV(0,'U50BB') Rather than write it into the program to check what system it is on (since sometimes it could be different functions or statements used that never even compile), then would do something like: USER.NO=%GET USERNO% The precompiler would look at the control table and translate the '%GET USERNO%' to the appropriate statement, then compile. I've seen software that was so generic it would run on any version of Multivalue system and sometimes even non-Multivalue systems. Robert Norman ROBERT NORMAN AND ASSOCIATES 23441 Golden Springs Dr., #289, Diamond Bar, CA 91765 (323) 285-7272, (951) 541-1668 i...@keyway.net http://universe-basic-programming.webstarts.com/index.html http://users.keyway.net/~ice/ http://www.affordablemultivalueprogramming.i8.com/ Computer programming software development in Universe BASIC for Rocket Universe, in PICK/BASIC for Rocket D3, in UNIBASIC for Rocket Unidata, in R/BASIC (REVELATION BASIC) for REVELATION TECHOLOGIES REVELATION, in JBASIC (JBC or JBASE BASIC) for TEMENOS JBASE, in DATA/BASIC for Northgate REALITY, in MV BASIC (Multivalue Basic) for Intersystems Cache Multivalue, and QMBASIC for Ladybridge OPENQM (QM). On 5/12/2014 4:33 PM, Adrian Overs wrote: What problem are you trying to solve by doing so? After all it's not rocket science (pardon the pun) to OPEN BP TO BP.FV THEN READ R.PROG FROM BP.FV, PROG.ID ELSE ... Whatever END Sent from my iPad On 13 May 2014, at 6:54 am, Wjhonson wjhon...@aol.com wrote: Does anyone have a BASIC program, that will open it's own code in a variable ? So something like this GOSUB RETURN.A.LOCAL.FILE.AND.KEY.FOR.ME READ THIS.PROGRAM FROM F.LOCALFILENAME, K.PROGRAMKEY the program reads itself. Does anyone have a program like that? ___ 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] So, what product is Dan McGrath managing @ Google?
LinkedIn tells me Dan has moved on unless Google are making an MV play (think LaughIn Very Interesting! -- I'll forgo the but stupid, 'cause I'm sure it is not!) Ross Ferris Stamina Software Visage Better by Design! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] Programmatic Verification of Globally Cataloged Subroutine
Knowing how many arguments a subroutine is expecting is a good way to check/confirm that the call you are about to make isn't going to blow up in your face! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, January 29, 2014 10:15 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [UV] Programmatic Verification of Globally Cataloged Subroutine I was just trying to think of a reason why I'd want specifically to know how many arguments the subroutine has. That is, why was this particular fact chosen as the returned status code ? -Original Message- From: Keith Johnson [DATACOM] keith.john...@datacom.co.nz To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Sent: Tue, Jan 28, 2014 3:10 pm Subject: Re: [U2] [UV] Programmatic Verification of Globally Cataloged Subroutine Hi, LeRoy Dreyfuss said that you would have to change 52 to 12 for EXIST to work. The globally cataloged programs have an extra 40 characters put on the front, so that would cause a problem. @RECORD[1,4] is a count of the number of times the program has been used. @RECORD[5,8] is who cataloged it @RECORD[13,4] are the date and time (I think) Regards, Keith ___ 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] Large DICT affecting I/O
So, how many reports or queries do you have that reference all 2000 dict items ... really? When you are working with this 2,000 field item, do you work with the item as a dimensioned array, or a dynamic array? How many of these 2,000 data elements are multi-valued (sub-multi-valued? or worse??) and how many of these are associated multi-values Performance issues are NOT related to the dictionary size (though dictionaries may accumulate debris over time), as the dictionary can be readily resized to be the right size -- I would hypothesise that if you had the tools to perform a field level data analysis of USAGE (how many fields appear grouped on screens reports together, how often these are used) you would find that there are some hot fields that are heavily used every day, whilst others are used sporadically every week/month, which could be used to guide any re-engineering. However, this is probably all academic, because in reality you are probably not in a position to re-structure the database anyway :-( Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Wednesday, August 7, 2013 8:07 PM To: U2 Users List Cc: U2 Users List Subject: Re: [U2] Large DICT affecting I/O Thanks to those who replied. 1) we have tools to easily edit dictionaries of any size (one of the few benefits of Datatel/ Ellucian) 2) we have tools to monitor and resize dictionaries just like any other file ( also a Datatel benefit) It's more of a general question about performance. We import data from the Common Application which has almost 2000 data attributes per person. Thus having a large DICT isn't sloppy or lazy work on our end, it's a necessity of the data. Thus the question is better stated as: Is unidata performance better if we stuff all 2000 elements in a single DICT or break the data into multiple (eg: 4) files of 500 elements each? When we work with this data we need all 2000 elements so is reading 4 or 5 separate tables any more efficient than reading a single large table of 2000 elements? Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 On Aug 6, 2013, at 11:16 PM, Doug Averch dave...@u2logic.com wrote: Hi Jeffery: We have a client with 6,000 dictionaries items and they have no performance problems If the dictionary is sized correctly, there generally is no performance hit. However, editing it with some tools is a pain because it takes quite a long time to read them. Regards, Doug www.u2logic.com XLr8Dictionary Editor for large dictionary editing On Tue, Aug 6, 2013 at 9:08 PM, jeffrey Butera jbut...@hampshire.eduwrote: I'm curious how large of a DICTionary some of you have worked with and, in particular, how very large DICTs can adversely affect applications. We have a DICT approaching 1500 data elements (no idescs) - which is quite large for us. But I'm curious if others have DICTs this large or larger and have no adverse affect on their application performance. This is Unidata 7.3.4 if it matters. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listser ver.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] Large DICT affecting I/O
I would suggest that rather than the DICTIONARY being a performance problem, which can be easily overcome with a suitably sized file, the REAL impact may be in day to day processing where this file might be getting referenced to display a dozen or so fields, but each I/O is actually pulling in much, Much, MUCH more, pulling in 2 orders of magnitude more fields than it needs to Sure, UD/UV/MV ALLOWS you to DO this sort of thing, but I would respectfully suggest that you shouldn't necessarily do so. If people adopt bad habits like this, they tend to just keep on evolving, and I suspect if performance is currently OK (thanks to ever faster hardware), there is probably no desire to go through the pain associated with fixing this (or budget :-) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of jeffrey Butera Sent: Wednesday, August 7, 2013 1:09 PM To: U2 Users List Subject: [U2] Large DICT affecting I/O I'm curious how large of a DICTionary some of you have worked with and, in particular, how very large DICTs can adversely affect applications. We have a DICT approaching 1500 data elements (no idescs) - which is quite large for us. But I'm curious if others have DICTs this large or larger and have no adverse affect on their application performance. This is Unidata 7.3.4 if it matters. -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 ___ 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] CentOS with Universe?
Of course, it is likely to take Rocket LONGER than that to certify U2 on a newly released OS platform, so no real deal breaker! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Porter Sent: Thursday, July 18, 2013 12:31 AM To: U2 Users List Subject: Re: [U2] CentOS with Universe? The only effective difference is that CentOS is that it will always be slightly behind RHEL. This is because it is re-compiled from RHEL sources. Those sources have to be released before work can start. How long? It can be significant... RHEL 6.0 released Nov 10, 2010. CentOS 6.0 release July 10, 2011 - 8 months to the day.This may or may not be a problem for you - just something to be aware of when your trying to decide. Personally, I love CentOS and run it on many machines. 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
Re: [U2] : Evaluating DCOUNT
If order isn't important for dcount(array,@fm) to 1 step -1 *commands here next i Should only have the dcount evaluated once on any platform/release I believe Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Monday, February 11, 2013 4:53 PM To: U2 Users List Subject: Re: [U2] : Evaluating DCOUNT The only way that this could not be an issue is if the compiler and the smarts and determined ahead of time that the array was invariant. My bet is solidly on plan b. -Rick On Feb 10, 2013, at 9:14 PM, Peter Cheney peter.che...@firstmac.com.au wrote: Hi Everyone, Does a DCOUNT get evaluated again for each iteration of a loop? Or is UniVerse these days intelligent enough to keep track of what's going on? e.g. for i = 1 to dcount(array,@fm) *commands here next i versus totalattributes = dcount(array,@fm) for i = 1 to totalattributes *commands here next i Apart from readability and perhaps easier debugging is there an actual internal difference? I know it was an issue on older pick releases but I cannot remember if it ever affected UV? Cheers Peter -- - Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) -- - ___ 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] Sleeping in Basic
On a busy system, NAP 1 may actually take 2 or 3 milliseconds ... thus the time
distortion.
A loop of 100 with a NAP 10 would be closer to the mark
Ross Ferris
Stamina Software
Visage Better by Design!
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Farmer
Sent: Saturday, 29 December 2012 4:32 AM
To: 'U2 Users List'
Subject: Re: [U2] Sleeping in Basic
I guess I am confused on the definition of quantized. NAP 250 seems to do
what I want. Doing a LOOP 1000 and NAP 1 inside the loop, makes it takes quite
a few seconds, where I would assume it would be 1 second (1000 x 1 millisecond
- 1 second). However, loop 20 with NAP 250 in the loop takes 5 seconds, which
is what I would expect (20 x 250 milliseconds = 5 seconds).
Also, the OCONV documentation only shows OCONV(num.expr,MT[H][S][c]) as a
syntax. No option for displaying milliseconds. The only why I know to do that
is to use SYSTEM(12).
I guess I was just using TIME() not SYSTEM(12) as it was easier to visually
scan.
Doug Farmer
952-417-5225
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Friday, December 28, 2012 11:16 AM
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] Sleeping in Basic
Your napping for a quarter of a second is too long :) I was saying that NAP is
quantized. You can't actually NAP for a microsecond.
So loop 1000 and NAP 1
By the way you can return the microseconds, why are you doing MTS
I never bothered to dig into it, to see on what it's quantized.
Without MTS you can see the microseconds.
-Original Message-
From: Doug Farmer dfar...@epicor.com
To: 'U2 Users List' u2-users@listserver.u2ug.org
Sent: Fri, Dec 28, 2012 7:22 am
Subject: Re: [U2] Sleeping in Basic
Wow, thanks of all of the responses. Unfortunately, none of them will seem to
work on UniData. I will be using NAP on UniVerse.
PAUSE and WAKE, I had not heard of. This is only on UniData so not a UniVerse
option. It would seem to be a good way to go, except for if the phantom process
aborts, the WAKE is never executed and the invoking process (UniObjects
subroutine) hangs forever.
David's openSocket suggestion does not wait at all if the socket can be opened.
If it cannot (for example host name is bad), the timeout is sometimes much
longer, probably due to DNS lookup of the bad host name.
I tried these examples in the code below. The results are show below the code.
When I run this, using NAP 250, I get 4 times the same, then another 4 times
the same etc. This seems to show NAP 250 does sleep for a quarter of a second.
Doing NAP 1 for 2000 iterations took 31 seconds. Probably due to overhead of
setting up NAP 2000 times.
The openSocket came right back all the time.
Any other ideas, I am open to testing.
Again, thanks for all of the responses!
Doug Farmer
952-417-5225
Program Listing
0001 PRINT 'Nap 250'
0002 FOR IDX = 1 TO 20
0003 PRINT IDX R#2:' ':OCONV(TIME(),'MTS')
0004 NAP 250
0005 NEXT IDX
0006 PRINT 'Start of 2000'
0007 PRINT OCONV(TIME(),'MTS')
0008 FOR IDX = 1 TO 2000
0009 NAP 1
0010 NEXT IDX
0011 PRINT OCONV(TIME(),'MTS')
0012 PRINT 'DONE WITH 2000'
0013 PRINT 'Open Socket'
0014 FOR IDX = 1 TO 20
0015 SleepTime = 250
0016 ERR = openSocket('loopback',25,1,SleepTime,HBUFF)
0017 PRINT IDX R#2:' ':OCONV(TIME(),'MTS')
0018 NEXT IDX
Output from Program
Nap 250
1 09:11:29
2 09:11:29
3 09:11:29
4 09:11:30
5 09:11:30
6 09:11:30
7 09:11:30
8 09:11:31
9 09:11:31
10 09:11:31
11 09:11:31
12 09:11:32
13 09:11:32
14 09:11:32
15 09:11:32
16 09:11:33
17 09:11:33
18 09:11:33
19 09:11:33
20 09:11:34
Start of 2000
09:11:34
09:12:05
DONE WITH 2000
Open Socket
1 09:12:05
2 09:12:05
3 09:12:05
4 09:12:05
5 09:12:05
6 09:12:05
7 09:12:05
8 09:12:05
9 09:12:05
10 09:12:05
11 09:12:05
12 09:12:05
13 09:12:05
14 09:12:05
15 09:12:05
16 09:12:05
17 09:12:05
18 09:12:05
19 09:12:05
20 09:12:05
This message has been scanned for malware by Websense. www.websense.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
Click
https://www.mailcontrol.com/sr/6lVGIXxG7qjGX2PQPOmvUlpAWghQWIvzb3YGjzkT!7MOUCUpiqnJJoGBzmYgl5U4YPnWx2HtmVnUfE+mA+MlhQ==
to report this email as spam.
___
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
Re: [U2] Problem with openpath in UniVerse on windows server
A couple of obvious ones ... and yet : * assume you are NOT reading/writing to c:\ * assume the directory in question IS local to the server, and NOT a mount point * are the other servers that ARE working part of an AD domain, and these 2 aren't (or visa versa) * from a windows perspective, call up properties of the directory ensure that EVERYONE has Full Control from Windows Security tab (rather than local system users if part of a domain) * delete/re-create directory setup as per above * Is UAC enabled? * could be issues with higher level directories if feasible, maybe simplify path to c:\temp * as per Wills' suggestion how ARE files being created, and has creator process completed/closed down HTH though I'm sure you would have ticked these boxes Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Wednesday, 12 December 2012 1:35 PM To: U2 Users List Subject: Re: [U2] Problem with openpath in UniVerse on windows server Has anyone had a similar problem. Our application uses openpath to read some csv files from a directory on windows server 2008R2. However a couple of sites, only the owner is able to open the directory with openpath, all other users fail. Even with the users given administration rights, it still fails. This is not a problem with all sites, just 2 of them. I run into the same problem with openseq. I tried even setting Authorisation in the program to the owner name and still no luck. I am not sure what else to try. Regards David Jordan ___ 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] converting D3 to UniData
I can share that it depends on a lot on the application. Many years ago (now) there was an outsourced computer logistics company that wanted to install our R5 ERP product only problem was, we used D3 but the company had Unidata, and would NOT contemplate a change. So, the client contracted Unidata (Australia) to undertake the conversion. They had a look at some of the code and came up with a quote of less than a week. The week passed, and the timeframe had grown to a month. They were having issues with some of the dictionary items we had, and they advised client it would take another week, then a month, then 2 months, then our prospect said too hard. Interestingly enough, the company DID end up installing a new ERP system running jBase (from Citadel). I'm sure things have progressed a lot since then, and yet . (like I said, this was quite a few years ago, and I'm sure their interoperability will have improved. Why, I bet any day now even Universe conversions will be a snap ;-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel Ruckel Sent: Thursday, 22 November 2012 2:59 PM To: U2-Users@listserver.u2ug.org Subject: [U2] converting D3 to UniData Can I convince someone in this group to share their experience/s converting D3 to UniData? Thanks, Danny ___ 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] UPLOAD not DOWNLOAD
You would use the dictionary item to know WHERE to put the data in U2 which file, attribute etc. if you are talking multi-values (or deeper) then this could also be driven from the dictionary, which would provide you with the capability of performing some mapping UNLESS you are in the position to dictate the format of the file you are trying to import (aka upload?) into UV. But, if you wanted to be able to map an arbitrary data source, as suggested by George, using a dictionary would allow you to achieve the result in a point click manner -- and depending on the dictionary could also ensure that you don't download incomplete or invalid data into an otherwise (hopefully) clean environment, setup defaults etc Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Saturday, 27 October 2012 11:01 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UPLOAD not DOWNLOAD snip I'm confused about your mention of Dict items because I don't see how you use Dict items for Uploading. I see how you use them for Downloading. Maybe you could give an example of why you would read the Dict for an upload. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] What remote support product do YOU use?
Just posted this to the pick/multivalue Google group, but figure there may be some (larger?) U2 only people who may have valuable insight on the subject, so We have been using TeamViewer (www.teamviewer.com) for the past 18 months or so, and I'm generally very happy with it - I can access Windows, Linux apple hosts from my desktop, or even my iPhone (screen is too small for remote support so will be upgrading to a GalaxyNote 2 Phablet soon, so will have a chance to try out the Android client), and would be happy to recommend others looking for a solution (quote coupon code 95051-42-600991 to get a 3% discount) We had previously used LogMeIn, RDP for server access, and/or even VNC if we had VPN access, but TeamViewer just works for us. Licencing is one off, based on number of people our end that will be running concurrent sessions to clients, rather than paying per client system, and I keep toying with the idea of integrating with Visage as a Support button. We also use TeamViewer to run presentations, though I tend to use Skype rather than integrated VOIP capabilities That said, I'm also curious if anyone has a better product they have used (first hand, rather than just something they have read about which sounded good), and/or especially if you had previously had a commercial TeamViewer licence moved on. Hoping for confirmation of our choice, but happy to have my horizons expanded :-) Ross Ferris Stamina Software Visage Better by Design! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] What remote support product do YOU use?
C'mon Gregor, you should be up on all of this Jargon! Phablet is something that (vaguely) resembles a phone (can fit in a VERY LARGE pocket), and yet isn't quite a tablet. Whilst I can, and have, used the iPhone for support, I figure a bigger screen, plus a throwback to the stylus (aka S-pen) may make it easier when I get a call in shopping centre though I haven't confirmed s-pen will work as I hope/expect waiting until release is more mainstream, rather than the current batch of grey product from people like Kogan (though they do offer 12 month Australian warranty, so possibly not as grey as I thought) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Wednesday, 3 October 2012 5:01 PM To: U2 Users List Subject: Re: [U2] What remote support product do YOU use? Phablet - is that the next Android version? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Wednesday, 3 October 2012 4:49 PM To: U2 Users List Subject: [U2] What remote support product do YOU use? Just posted this to the pick/multivalue Google group, but figure there may be some (larger?) U2 only people who may have valuable insight on the subject, so We have been using TeamViewer (www.teamviewer.com) for the past 18 months or so, and I'm generally very happy with it - I can access Windows, Linux apple hosts from my desktop, or even my iPhone (screen is too small for remote support so will be upgrading to a GalaxyNote 2 Phablet soon, so will have a chance to try out the Android client), and would be happy to recommend others looking for a solution (quote coupon code 95051-42-600991 to get a 3% discount) We had previously used LogMeIn, RDP for server access, and/or even VNC if we had VPN access, but TeamViewer just works for us. Licencing is one off, based on number of people our end that will be running concurrent sessions to clients, rather than paying per client system, and I keep toying with the idea of integrating with Visage as a Support button. We also use TeamViewer to run presentations, though I tend to use Skype rather than integrated VOIP capabilities That said, I'm also curious if anyone has a better product they have used (first hand, rather than just something they have read about which sounded good), and/or especially if you had previously had a commercial TeamViewer licence moved on. Hoping for confirmation of our choice, but happy to have my horizons expanded :-) Ross Ferris Stamina Software Visage Better by Design! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Message protected by DealerGuard: e-mail anti-virus, anti-spam and content filtering. http://www.pentanasolutions.com Click here to report this message as spam: https://login.mailguard.com.au/report/1FFUafXBSo/7KtjoQeo1oK7pQM42Yg6NT/0 This email and any attachments to it are confidential. You must not use, disclose or act on the email if you are not the intended recipient. Liability limited by a scheme approved under Professional Standards Legislation. ___ 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] [u2] Parallel processing in Universe
Could also avoid the lock contention if each phantom had knowledge of the others, so phantom 1 could only process @ID 1, 6, 11 etc., phantom 2 would do 2,7,12 so on Of course, if you are operating with a select list, this already implies that you have processed the file once, so your batch process is actually a re-read, so in the absence of a suitable index, perhaps employing the Drumheller trick would be worth consideration Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, 3 October 2012 3:42 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [u2] Parallel processing in Universe The point of the caching concern is related to the read ahead, and you will still get some benefit from this, if your five phantoms are reading their *portion* of the file in order, which they should. -Original Message- From: George Gallen ggal...@wyanokegroup.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, Oct 2, 2012 10:39 am Subject: Re: [U2] [u2] Parallel processing in Universe If 5 phantoms were running, and read in order but from 5 different starting points, the records would Essentially still be processed in a random order, if you were to layout the record ID's as they get Processed. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, October 02, 2012 1:35 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [u2] Parallel processing in Universe The idea of the phantoms would be to read the file in order, not randomly, just inorder from five different starting points. So you should still get the benefit of some caching. ___ 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] [u2] Parallel processing in Universe
Depends on what you call a no brainer -- to me, $4K for an 800Mb Intel 910 SSD seems reasonable for what you get (10x full drive writes every day for 5 years has the endurance angle covered IMHO - 400Gb is $2K if your database will fit) and by todays standards represents reasonable value. Not quite at the performance level of Fusion IO, but cheap enough to just about be affordable Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Wednesday, 3 October 2012 3:19 AM To: 'U2 Users List' Subject: Re: [U2] [u2] Parallel processing in Universe Great point!! I think we can agree that 'spinning media latency' is the enemy and having phantoms increasing the 'head dance' can make things worse, not better! Many problems go away or become trivial as the spinning media trails to the sunset. I've advised customers that just moving 'code files' to a tiny SSD would likely increase overall system performance on Windows boxes. Just waiting until the price for Enterprise SSDs makes them a no-brainer... Until then, even small SSDs will help! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Daniel McGrath Sent: Tuesday, October 02, 2012 12:05 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe You've highlighted one problem here. By having multiple processes accessing the disk in different locations, you destroy cache optimization and seek times. More phantoms = less performance. This assumes I/O is a bigger concern than CPU, which is generally the case. More phantoms = more communication, which also adds another overhead that reduces performance. Introducing more phantoms than CPU cores, you increase the amount of context switching, which ones again hurts your cache usage as well as adding bigger overheads on the CPU again. In short, except for very specific cases, increasing 'concurrency' through phantoms on a single machine is generally ill-advised, resulting in longer processing times, higher average system loads and worse yet, greater system complexity (and hence ways for things to break). As mentioned earlier, more system-level architectural changes (such as multiple machines, or at least, files storage on different disks/spindles for each process) are required if you want benefit from this sort of work. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Monday, October 01, 2012 4:47 PM To: 'U2 Users List' Subject: Re: [U2] [u2] Parallel processing in Universe OK - I was trying to create a 'smoother use' of the disk and 'read ahead' -- this example the disk would be chattering from the heads moving all over the place. I was trying to find a way to make this process more 'orderly' -- is there one? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Monday, October 01, 2012 4:48 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe Create an index on a dict pointing at the first character of the key, and have each phantom take two digits. (0-1, 2-3, 4-5, 6-7, 8-9) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: October-01-12 2:43 PM To: 'U2 Users List' Subject: Re: [U2] [u2] Parallel processing in Universe So how would a user 'chop up' a file for parallel processing? Ideally, if here was a Mod 10001 file (or whatever) it would seem like it would be 'ideal' to assign 2000 groups to 5 phantoms -- but I don't know how 'start a BASIC select at Group 2001 or 4001' ... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 3:29 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe 0001: OPENSEQ /tmp/pipetest TO F.PIPE ELSE STOP NO PIPE 0002: LOOP 0003:READSEQ LINE FROM F.PIPE ELSE CONTINUE 0004:PRINT LINE 0005: REPEAT 0006: STOP 0007: END Although, not sure if you might need to sleep a litte between the READSEQ's ELSE and CONTINUE Might suck up cpu time when nothing is writing to the file. Then you could setup a printer in UV that did a cat - /tmp/pipetest Now your phantom just needs to print to that printer. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe The only thing about a pipe is that once it's closed, I believe it has
Re: [U2] [u2] Parallel processing in Universe
If the file were big enough, and already had part files, then I believe that you could have a phantom process each of the individual parts. Failing that, get an SSD relatively cheap, and will give your processing a reasonable kick along!! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, 2 October 2012 8:47 AM To: 'U2 Users List' Subject: Re: [U2] [u2] Parallel processing in Universe OK - I was trying to create a 'smoother use' of the disk and 'read ahead' -- this example the disk would be chattering from the heads moving all over the place. I was trying to find a way to make this process more 'orderly' -- is there one? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Monday, October 01, 2012 4:48 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe Create an index on a dict pointing at the first character of the key, and have each phantom take two digits. (0-1, 2-3, 4-5, 6-7, 8-9) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: October-01-12 2:43 PM To: 'U2 Users List' Subject: Re: [U2] [u2] Parallel processing in Universe So how would a user 'chop up' a file for parallel processing? Ideally, if here was a Mod 10001 file (or whatever) it would seem like it would be 'ideal' to assign 2000 groups to 5 phantoms -- but I don't know how 'start a BASIC select at Group 2001 or 4001' ... -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 3:29 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe 0001: OPENSEQ /tmp/pipetest TO F.PIPE ELSE STOP NO PIPE 0002: LOOP 0003:READSEQ LINE FROM F.PIPE ELSE CONTINUE 0004:PRINT LINE 0005: REPEAT 0006: STOP 0007: END Although, not sure if you might need to sleep a litte between the READSEQ's ELSE and CONTINUE Might suck up cpu time when nothing is writing to the file. Then you could setup a printer in UV that did a cat - /tmp/pipetest Now your phantom just needs to print to that printer. George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, October 01, 2012 4:16 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe The only thing about a pipe is that once it's closed, I believe it has to be re-opened by both Ends again. So if point a opens one end, and point b opens the other end, once either end closes, It closes for both sides, and both sides would have to reopen again to use. To eliminate this, you could have one end open a file, and have the other sides do a append To that file - just make sure you include some kind of dataheader so the reading side knows which Process just wrote the data. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of u2ug Sent: Monday, October 01, 2012 4:11 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe pipes -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, October 01, 2012 4:05 PM To: u2-users@listserver.u2ug.org Subject: [U2] [u2] Parallel processing in Universe What's the largest dataset in the Universe user world? In terms of number of records. I'm wondering if we have any potential for utilities that map-reduce. I suppose you would spawn phantoms but how do they communicate back to the master node? ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org
Re: [U2] [u2] Parallel processing in Universe (Unclassified)
Interestingly I'm currently trying to find a definitive answer/correlation between clock speed performance on a single core/thread on Intel CPU's to confirm, or deny, that for grunt batch work if a 4C Intel running @ 3.4Ghz will actually be faster than an 8C running @ 2.7Ghz -- the answer isn't as straight forward (or as easy to find) as I would have hoped, as even within the same family (e5-2600) there can be architectural differences that come into play and if anyone has a definitive answer, please feel free to share ! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of HENDERSON MIKE, MR Sent: Tuesday, 2 October 2012 1:18 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe (Unclassified) I have often thought about this - mostly in an idle moment or as a displacement activity for something less amusing that I ought to be doing. ;-) First of all, Universe is already extremely parallel: there's a separate O/S thread for each TTY and for each phantom, and you can't get more parallel than that for interactive processing. So you want more parallelism for your batch processes. Different applications have different degrees of inherent parallelism. For example in utility billing systems there is frequently the concept of a group of premises - based on the old concept of a foot-borne meter reader with a 'book' of readings to get. Each 'book' can be processed independently of every other. In payroll, each employee's record can be processed independently. Other areas of commerce have different characteristics. I think that whatever unit of parallelism you settle for, you'd need three processes: a 'dispatcher' that selects records for processing and queues them into some structure for processing; a set of 'workers' that take queued work items, process them, mark them as processed and put the results in some common store; and a 'monitor' that looks for unprocessed records and indications of stuck processes, and collates the results for final output. I've seen a couple of versions of this, one for electricity billings and another for overnight batch-processing of report requests, both well over a decade ago, and neither still in use although their underlying packages are still being run. The major issue is that these days the whole entity in the general commercial world is far more likely to be I/O limited than CPU limited, and therefore introducing parallelism will be no help at all if the I/O system is already choked. Even if the system is currently CPU-limited, multi-threading may not produce much improvement without very careful design of the record locking philosophy - introducing parallelism will be no help if all the threads end up contending serially for one record lock or a small set of locks. If you want it to go faster, buy the CPU with the fastest clock you can get (not the one with the most cores), and put your database on SSD like Ross said. The Power7+ chips being announced any day now are rumoured to go to 5GHz+, maybe even more if you have half the cores on the chip disabled. Regards Mike -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Tuesday, 2 October 2012 3:50 p.m. To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe If the file were big enough, and already had part files, then I believe that you could have a phantom process each of the individual parts. Failing that, get an SSD relatively cheap, and will give your processing a reasonable kick along!! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Tuesday, 2 October 2012 8:47 AM To: 'U2 Users List' Subject: Re: [U2] [u2] Parallel processing in Universe OK - I was trying to create a 'smoother use' of the disk and 'read ahead' -- this example the disk would be chattering from the heads moving all over the place. I was trying to find a way to make this process more 'orderly' -- is there one? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Robert Houben Sent: Monday, October 01, 2012 4:48 PM To: U2 Users List Subject: Re: [U2] [u2] Parallel processing in Universe Create an index on a dict pointing at the first character of the key, and have each phantom take two digits. (0-1, 2-3, 4-5, 6-7, 8-9) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: October-01-12 2:43 PM To: 'U2 Users List' Subject: Re: [U2] [u2] Parallel processing in Universe So how would a user 'chop up' a file
Re: [U2] Inverting/Pivoting a table
David, How many rows are there in your source flat file? If you found an intrinsic function to do what you are after, what next? What would you do with the resulting in-memory array? Knowing the size of the data set, and the end use, can impact the best solution to your problem at hand, and at the moment I don't know WHY you think you need this Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dave Laansma Sent: Tuesday, 11 September 2012 6:32 AM To: U2 Users List Subject: Re: [U2] Inverting/Pivoting a table :-) Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, September 10, 2012 4:31 PM To: U2 Users List Subject: Re: [U2] Inverting/Pivoting a table Why is the Kink's song Lola suddenly playing in my mind! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Monday, September 10, 2012 4:21 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Inverting/Pivoting a table Columns become rows Rows become columns ___ 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] RESIZE - dynamic files
I would suggest that then actual goal is to achieve maximum performance for your system, so knowing HOW the file is used on a daily basis can also influence decisions. Disk is a cheap commodity, so having some wastage in file utilization shouldn't factor. Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Wednesday, 4 July 2012 7:38 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RESIZE - dynamic files This is why I'm confused.. Is the goal here to reduce 'overflow' or to keep the 'Total size' of the disk down? If the goal is to keep the total disk size down then it would appear you would want your actual load % a lot higher than 37%.. and then ignore 'some' of the overflow.. Chris But the total size of your file is up 60%. Reading in 60% more records in a full select of the file is going to be much slower than a few more overflows. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Chris Austin Sent: Tuesday, July 03, 2012 2:15 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] RESIZE - dynamic files Dan, I changed the MINIMUM.MODULUS to the value of 23 as you suggested and my Actual Load has really gone down (as well as overflow). See below for the results: File name .. GENACCTRN_POSTED Pathname ... GENACCTRN_POSTED File type .. DYNAMIC File style and revision 32BIT Revision 12 Hashing Algorithm .. GENERAL No. of groups (modulus) 23 current ( minimum 23, 5263 empty, 3957 overflowed, 207 badly ) Number of records .. 1290469 Large record size .. 3267 bytes Number of large records 180 Group size . 4096 bytes Load factors ... 90% (split), 50% (merge) and 37% (actual) Total size . 836235264 bytes Total size of record data .. 287394719 bytes Total size of record IDs ... 21508521 bytes Unused space ... 527323832 bytes Total space for records 836227072 bytes My overflow is now @ 2% My Load is @ 37% (actual) granted my empty groups are now up to almost 3% but I hope that won't be a big factor. How does this look? Chris ___ 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] Regarding: use of I - Descriptor
John, Your cool idea is (was?) actually known as the Drumheller Trick, and along with some smoke mirrors was used to great advantage in years gone by John Drumheller (to show how much faster Information was than classic Pick :-) The actual way you would typically work would be more like SELECT FILE WITH insert conditions SAVING DO.TASK That way your routine only gets fired when needed based on selection criteria Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, 26 June 2012 3:24 AM To: 'U2 Users List' Subject: Re: [U2] Regarding: use of I - Descriptor Satya, Roughly speaking, and I-Desc is a way to manipulate the data so that you can select or display data in other ways. You can get data from another file, perform some math on multiple fields, concatenate data, call a basic subroutine, or any combination of these. You can have multiple commands within an I-Desc with each piece separated by a semi-colon, and then take action based on each piece of the code. You can even put alternate indexes on I-Desc, though this can lead to serious problems if you are indexing a translate. You generally cannot do updates with an I-Desc, though if the I-Desc called a subroutine, you COULD do anything but I have never seen this done (and with very good reason). On a wild tangent to what I just said, I have always thought how easy (in a purest way) that you COULD perform some task like month end by having a file with special record and an I-Desc that DOES run update subroutines (yeah I know, I just said not to do that, but the idea is cool). If set up correctly, you COULD simply run your month end by sorting the special file with the I-Desc. For example: SORT MONTH.END.CTL DO.TASK Where DO.TASK is an I-Desc that calls a subroutine that knows what to do based on the key of each record. Again, NOT a good idea, but the capability is there. John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of satya satya Sent: Monday, June 25, 2012 12:10 PM To: U2 Users List Subject: [U2] Regarding: use of I - Descriptor Hi, Could any one of you explain What is I - Descriptor and What is the use of it. Thank you, Satya ___ 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] Runoff ?
Now THAT takes me back! (Ventura) We did some mods for one of our users (added about 8 additional product categorizations and some images) that allowed them to go build their catalogue programmatically. This was in the days when people sent out paper catalogues (yeah, I know some people still do!) -- used to be a major, 2 year undertaking to produce a new catalogue . suddenly it became something you could compile over a weekend to send off to the printer on Monday I'm all for integrating with the latest productivity tools people have on their desktop - if you are a VAR, and want to sell a solution this is mandatory. If you are supporting an in-house application, the effort may not seem worth it . until your application is replaced by something that isn't as powerful, but DOES allow integration to Word, Excel etc. etc Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Buss, Troy (Contractor, Logitek Systems) Sent: Sunday, 17 June 2012 2:31 PM To: U2 Users List Subject: Re: [U2] Runoff ? I agree with Tony on integrating with current tools if possible. A long long time ago, I used Ventura Publisher and created a really nice template using styles, and drove the entire documentation from within the database by exporting the raw data marked with styles. Ventura publisher would merge the marked up export file along with my template style definitions and produce a really nice typeset finished product complete with screen shots, menus and field by field help.. I'm sure there are still tools today that can take a similar approach by merging marked XML or such. Anyway, it worked well, and looked great along with the simplicity of it being all system generated and quick. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Saturday, June 16, 2012 5:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Runoff ? _ Scanned by IBM Email Security Management Services powered by MessageLabs. For more information please visit http://www.ers.ibm.com This email is intended only for the use of the party to which it is addressed and may contain information that is privileged, confidential, or protected by law. If you are not the intended recipient you are hereby notified that any dissemination, copying or distribution of the email or its contents is strictly prohibited. If you have received this message in error, please notify us immediately, by replying to the message and deleting it from your computer. WARNING: Internet communications are not assured to be secure or clear of inaccuracies as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. Therefore, we do not accept responsibility for any errors or omissions that are present in this email, or any attachment, that have arisen as a result of e-mail transmission. _ ___ 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] U2 accounting software question
Thanks for the memories Brendan! I could be wrong, but I think Wreckair was THE biggest Sanyo ICON site in the world but I was VERY GLAD when you migrated to D3/AIX :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Leverett, Brendon Sent: Thursday, 24 May 2012 5:13 PM To: U2 Users List Subject: Re: [U2] U2 accounting software question A few years back a company I worked for had dealings with Stamina (and Ross directly). We interfaced to the Visage GL - all worked well and support/development requirements were always met. I have had no direct dealings with the product since and have no business relationship with Stamina but I will recommend them for the services they provided 'back in the day'. From the odd word around town in Australia the product is still alive and well. Worth considering. Brendon Leverett -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Thursday, 24 May 2012 1:24 PM To: U2 Users List Subject: Re: [U2] U2 accounting software question Unfortunately the support organization we used to operate with in the USA is no more. If you didn't mind the fact that support would be remote (Australia), our Visage R5 General Ledger Financial Reporting packages might fit the bill. These can be deployed stand alone (ie: without our full ERP offering), though of course you would need to develop interfaces from your subsidiary ledger systems as required -- reasonably straight forward, just throw records into a file pass a select list to our POST routine. There is also scope to include additional modules that you may consider part of the General Ledger banner (eg: Asset Register, Bank Reconciliation/Treasury etc.) if appropriate, now or in the future. Our enquiries typically support drilling through to source transactions, so there may need to be some work done to provide that capability into your existing systems Multi-currency is fully supported if required, as well as multiple consolidations across within corporate boundaries if required. Beyond the basic manual journals auto-reversing accruals there are variety of ratio posting options. Whilst we offer our solution via the cloud, we can also provide on-premise, which I assume is probably what you are after? [ad] If there are any companies, or individuals looking to becomes involved in a broad spectrum ERP product that can encompass Retail/POS, Wholesale/Distribution, Warehouse automation management, Job/Project costing Engineering Services, as well as core accounting functionality, please drop us a line :-) [ad] Regards, Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Wednesday, 23 May 2012 6:45 AM To: U2 Users List Subject: [U2] U2 accounting software question We used to have a Pick general ledger software package called FMS that was sold by Price Waterhouse. At some point the software was purchased by a company named IDEAS. In 2004, they stopped supporting the Pick version and migrated us to a client-server package that uses MS SQL as the underlying database. IDEAS is now owned by a company that services the oil and gas industry (which is not the industry we're in) and future support of the software is less than certain, so we're exploring other options. Can anyone recommend a good GL system? It doesn't necessarily need to be Pick-based, but either UV or MS SQL as the database would be preferred. We currently export the UV GL data as a flat csv file at the end of the month and import it into IDEAS. 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] U2 accounting software question
Hi John, Keep us in mind then, as we offer 24x7 support for clients now :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Friday, 25 May 2012 3:10 AM To: U2 Users List Subject: Re: [U2] U2 accounting software question Thanks, Ross. We are definitely open to cloud options, but 8-5 Pacific time telephone support is also a requirement. Vendor location isn't much of a concern if that requirement can be met. -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Wednesday, May 23, 2012 8:24 PM To: U2 Users List Subject: Re: [U2] U2 accounting software question Unfortunately the support organization we used to operate with in the USA is no more. If you didn't mind the fact that support would be remote (Australia), our Visage R5 General Ledger Financial Reporting packages might fit the bill. These can be deployed stand alone (ie: without our full ERP offering), though of course you would need to develop interfaces from your subsidiary ledger systems as required -- reasonably straight forward, just throw records into a file pass a select list to our POST routine. There is also scope to include additional modules that you may consider part of the General Ledger banner (eg: Asset Register, Bank Reconciliation/Treasury etc.) if appropriate, now or in the future. Our enquiries typically support drilling through to source transactions, so there may need to be some work done to provide that capability into your existing systems Multi-currency is fully supported if required, as well as multiple consolidations across within corporate boundaries if required. Beyond the basic manual journals auto-reversing accruals there are variety of ratio posting options. Whilst we offer our solution via the cloud, we can also provide on-premise, which I assume is probably what you are after? [ad] If there are any companies, or individuals looking to becomes involved in a broad spectrum ERP product that can encompass Retail/POS, Wholesale/Distribution, Warehouse automation management, Job/Project costing Engineering Services, as well as core accounting functionality, please drop us a line :-) [ad] Regards, Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Wednesday, 23 May 2012 6:45 AM To: U2 Users List Subject: [U2] U2 accounting software question We used to have a Pick general ledger software package called FMS that was sold by Price Waterhouse. At some point the software was purchased by a company named IDEAS. In 2004, they stopped supporting the Pick version and migrated us to a client-server package that uses MS SQL as the underlying database. IDEAS is now owned by a company that services the oil and gas industry (which is not the industry we're in) and future support of the software is less than certain, so we're exploring other options. Can anyone recommend a good GL system? It doesn't necessarily need to be Pick-based, but either UV or MS SQL as the database would be preferred. We currently export the UV GL data as a flat csv file at the end of the month and import it into IDEAS. 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] U2 accounting software question
Unfortunately the support organization we used to operate with in the USA is no more. If you didn't mind the fact that support would be remote (Australia), our Visage R5 General Ledger Financial Reporting packages might fit the bill. These can be deployed stand alone (ie: without our full ERP offering), though of course you would need to develop interfaces from your subsidiary ledger systems as required -- reasonably straight forward, just throw records into a file pass a select list to our POST routine. There is also scope to include additional modules that you may consider part of the General Ledger banner (eg: Asset Register, Bank Reconciliation/Treasury etc.) if appropriate, now or in the future. Our enquiries typically support drilling through to source transactions, so there may need to be some work done to provide that capability into your existing systems Multi-currency is fully supported if required, as well as multiple consolidations across within corporate boundaries if required. Beyond the basic manual journals auto-reversing accruals there are variety of ratio posting options. Whilst we offer our solution via the cloud, we can also provide on-premise, which I assume is probably what you are after? [ad] If there are any companies, or individuals looking to becomes involved in a broad spectrum ERP product that can encompass Retail/POS, Wholesale/Distribution, Warehouse automation management, Job/Project costing Engineering Services, as well as core accounting functionality, please drop us a line :-) [ad] Regards, Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Hester Sent: Wednesday, 23 May 2012 6:45 AM To: U2 Users List Subject: [U2] U2 accounting software question We used to have a Pick general ledger software package called FMS that was sold by Price Waterhouse. At some point the software was purchased by a company named IDEAS. In 2004, they stopped supporting the Pick version and migrated us to a client-server package that uses MS SQL as the underlying database. IDEAS is now owned by a company that services the oil and gas industry (which is not the industry we're in) and future support of the software is less than certain, so we're exploring other options. Can anyone recommend a good GL system? It doesn't necessarily need to be Pick-based, but either UV or MS SQL as the database would be preferred. We currently export the UV GL data as a flat csv file at the end of the month and import it into IDEAS. 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
Re: [U2] [mildly ot] - EDI and drop shipments
I apologize if this is too obvious, but just in case ... Taking this one step further, you might also want to consider some flexibility in HOW you implement this by establishing a simple MAP that allows you to vary which information is presented in which tag area for each trading partner -- this can put you in a good trading position, as you can easily customize the documentation sent to each trading partner so that it is consumed by their system The same philosophy for accepting incoming transactions will ease your pain on each side of the interface Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Saturday, 11 February 2012 10:48 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [mildly ot] - EDI and drop shipments George, EDI is more people-oriented than technical. The X12 documents provide a structure, and trading partners can discuss the content used to populate those structures to achieve their business goals. There are few details about the 850, 856, 820, 997, 810, etc that can't be negotiated to accommodate specific business practices. Every discussion with a different partner will yield different results, though your inquiry here may give you more ideas to bring to the table, and can help to establish standards among partners. It's been my experience that more time is spent on the phone, in emails, and in the conference room than in code when it comes to EDI. Getting the agreements documented up front saves huge amounts of coding and retrofitting on the back-end. So I encourage you to take the feedback you get here and bring it to your trading partners to see if it works for them - and ask them if they have ideas about how they have already done this or how they see it happening. That partnership toward a common goal (again, very people-oriented) will really help to make this technical initiative work for everyone. HTH T Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit http://PickWiki.com! Contribute! http://Twitter.com/TonyGravagno NEW! http://groups.google.com/group/mvdbms/about From:George Gallen For those EDIers on the list. Do any of you process drop shipments using EDI for 850's? What method do you use? ___ 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] Including Code - A Best Practice?
There are plenty of reasons to include code, and issues like variable assignment should be able to be addressed with minimal care as to scope of the variables -- if you use I in a for/next loop and include or execute some code in the loop that also uses I, U will get what you deserve. As per other recent discussions, I'd run the includes through a pre-processor so that the object you ultimately produce DOES NOT have includes, but rather has real code, and real line number references, that can be used against the pre-processed source code You can get the same level of re-use from included code as you can from calling external subroutines with appropriate code builds, and the speed gains can be significant from, inline code, though sometimes this can be counter-intuitive if a highly used routine spans frame boundaries frame faults (though few people will bother looking at code for this level of optimization within the runtime environment Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: Wednesday, 8 February 2012 10:05 AM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Including Code - A Best Practice? A friendly discussion arose recently among some U2/MV Developers about whether to include code. If any of you have opinions about the positive aspects or negative aspects of this practice, please respond. Should it be adopted as a best practice, or rejected as special situation use only? Many shops probably include long sections of variable assignments, or perhaps globally opened files. This is pretty much accepted everywhere as a good practice. In question here is the insertion of actual code - business logic or screen I/O programs or code snippets. Maybe you know of methods to overcome some of the obvious downsides: unintended reassignment of local variables, difficulty in debugging, others. What are the positive upsides? Performance gains? What is the longest snippet you think should be included, if allowed? What advantage has included code over a CALL or a Function? Reuse. What else? Can the downsides be mitigated satisfactorily to justify the gains? Thanks so much. -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ 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] Brilliant? or not?
NOT! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Saturday, 14 January 2012 4:42 AM To: u2-users@listserver.u2ug.org Subject: [U2] Brilliant? or not? SMAX = (S1 S2) * S1 + (S2 = S1) * S2 ? ___ 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] Is SB+ object-oriented?
Yes - is also supported for real within Cache QM Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, 13 December 2011 7:17 AM To: u2-users@listserver.u2ug.org Subject: [U2] Is SB+ object-oriented? Can Pick BASIC code simulate an object oriented environment? ___ 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] TAB.TO.UNIVERSE
You are going to end up with key in field 1 with your code Your assumptions in PRINT statements had also better let people know that column # corresponds to field number (with caveat from above) Would also suggest that CONVERT TAB.KEY to @FM IN T.ROW, Followed by a REMOVE for the key may be more efficient Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, 13 December 2011 4:36 PM To: u2-users@listserver.u2ug.org Subject: [U2] TAB.TO.UNIVERSE 0001 * 0002 * Writen Dec 2011 by Will Johnson 0003 * Input tab delimited file, output universe file 0004 * BATCH mode does not ask for input at error messages, so it's 0005 *appropriate for PHantoms or any other COMO generating job 0006 * TEST mode does not WRITE, useful for debugging logic 0007 * 0008 EQUATE FALSE TO 0, TRUE TO 1 0009 EQUATE TAB.KEY TO CHAR(9) 0010 ERROR = '' 0011 GOSUB GET.PARAMETERS 0012 GOSUB OPEN.FILES 0013 IF ERROR = '' THEN 0014 GOSUB READ.AND.PROCESS 0015 END ELSE 0016 CRT ERROR: 0017 IF MODE = BATCH THEN CRT ELSE 0018 CRT Hit enter : ; INPUT CONT,1_ 0019 END 0020 END 0021 STOP 0022 * 0023 GET.PARAMETERS: 0024 CRT THIS PROGRAM WILL PROMPT FOR A TAB-DELIMITED FILE AS INPUT 0025 CRT AND A UNIVERSE FILE TO POPULATE WITH THE DATA 0026 CRT 0027 CRT WARNING: THIS PROGRAM ASSUMES THE PRIMARY KEY: 0028 CRT IS IN COLUMN ONE! 0029 CRT 0030 CRT IS THIS WHAT YOU WANT TO DO (Y/N) : ; INPUT CONT,1_ 0031 IF CONT # Y THEN CRT USER ABORT ; STOP 0032 * 0033 CRT MODE (BATCH/TEST/LIVE) : ; INPUT MODE 0034 CRT MODE IS ':MODE:' 0035 CRT PATH OF TAB-DELIMITED FILE : ; INPUT TAB.PATH 0036 CRT TAB.PATH IS ':TAB.PATH:' 0037 CRT UNIVERSE FILE NAME : ; INPUT N.FILE 0038 CRT UNIVERSE FILE NAME IS ':N.FILE:' 0039 CRT DATE-STAMP KEYS (Y/N) : ; INPUT DATE.STAMP 0040 CRT TIMEDATE-STAMP KEYS IS ':DATE.STAMP:' 0041 IF DATE.STAMP = 'Y' THEN STAMP = DATE():'*':TIME() 0042 RETURN 0043 * 0044 OPEN.FILES: 0045 OPENSEQ TAB.PATH TO SOURCE.FILE THEN 0045AIF DATE.STAMP = 'Y' THEN 0045B OPEN 'DICT',N.FILE TO DF.FILE THEN 0045C WRITE STAMP ON DF.FILE,'LAST.RUN' 0045D END ELSE ERROR = 'Cannot open file DICT ':N.FILE:'' 0045EEND 0046 OPEN N.FILE TO F.FILE ELSE 0047 ERROR = 'Cannot open file ':N.FILE:'' 0048 END 0049 END ELSE ERROR = 'Cannot open file ':TAB.PATH:'' 0050 RETURN 0051 * 0052 READ.AND.PROCESS: 0053 DONE = FALSE ; CNT = 0 0054 LOOP 0055 READSEQ T.ROW FROM SOURCE.FILE ELSE DONE = TRUE 0056 UNTIL DONE DO 0057 CNT += 1 ; R.FILE = '' ; S.ROW = DCOUNT(T.ROW,TAB.KEY) 0058 FOR I.ROW = 1 TO S.ROW 0059 R.FILEI.ROW = FIELD(T.ROW,TAB.KEY,I.ROW) 0060 NEXT I.ROW 0061 *ASSUME PRIMARY KEY IN FIELD ONE 0062 K.FILE = R.FILE1 0063 IF DATE.STAMP = 'Y' THEN K.FILE := *:STAMP 0064 IF MODE # TEST THEN WRITE R.FILE ON F.FILE,K.FILE 0065 REPEAT 0066 RETURN 0067 * 0068END -Original Message- From: Wjhonson wjhon...@aol.com To: WJhonson wjhon...@aol.com Sent: Mon, Dec 12, 2011 1:59 pm Subject: TAB.TO.UNIVERSE 0001 * 0002 * Writen Dec 2011 by Will Johnson 0003 * 0004 * BATCH mode does not ask for input at error messages, so it's 0005 *appropriate for PHantoms or any other COMO generating job 0006 * TEST mode does not WRITE 0007 * 0008 EQUATE FALSE TO 0, TRUE TO 1 0009 EQUATE TAB.KEY TO CHAR(9) 0010 ERROR = '' 0011 GOSUB GET.PARAMETERS 0012 GOSUB OPEN.FILES 0013 IF ERROR = '' THEN 0014 GOSUB READ.AND.PROCESS 0015 END ELSE 0016 CRT ERROR: 0017 IF MODE = BATCH THEN CRT ELSE 0018 CRT Hit enter : ; INPUT CONT,1_ 0019 END 0020 END 0021 STOP 0022 * 0023 GET.PARAMETERS: 0024 CRT THIS PROGRAM WILL PROMPT FOR A TAB-DELIMITED FILE AS INPUT 0025 CRT AND A UNIVERSE FILE TO POPULATE WITH THE DATA 0026 CRT 0027 CRT WARNING: THIS PROGRAM ASSUMES THE PRIMARY KEY: 0028 CRT IS IN COLUMN ONE! 0029 CRT 0030 CRT IS THIS WHAT YOU WANT TO DO (Y/N) : ; INPUT CONT,1_ 0031 IF CONT # Y THEN CRT USER ABORT ; STOP 0032 * 0033 CRT MODE (BATCH/TEST/LIVE) : ; INPUT MODE 0034 CRT MODE IS ':MODE:' 0035 CRT PATH OF TAB-DELIMITED FILE : ; INPUT TAB.PATH 0036 CRT TAB.PATH IS ':TAB.PATH:' 0037 CRT UNIVERSE FILE NAME : ; INPUT N.FILE 0038 CRT UNIVERSE FILE NAME IS ':N.FILE:' 0039 CRT DATE-STAMP KEYS (Y/N) : ; INPUT
Re: [U2] U2 - Universe - Sage MAS90 - Experiences?
Perhaps it would be better to find a replacement for the AP that had a decent AR module as well that runs on u2 :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Friday, 11 November 2011 12:21 AM To: U2 Users List Subject: [U2] U2 - Universe - Sage MAS90 - Experiences? So I'm in a situation, probably not unlike some of you have found yourselves in before. Our financial department was unhappy with the Accounts Payable system some years back when we were on Ultimate Plus. They purchased an Accounting Package called Sage MAS 90 to run the payables piece and we just dumped data to it every night, etc. Of course, since then, we have long moved to Universe. In that time, we've known some of the Accounts Receivable apps are outdated, but, its just been one of those projects in the heap. And of course priorities seem to always change. Lately, management hopes that they can use the A/R module of Sage MAS 90. However, our POS is still a set of BASIC programs communicating directly with Universe. In my mind, I would think real time communication between the two would be essential. We are a wholesale auto parts business, and when a customer calls for a part, or orders online, our people need to know whether they have credit with us or not. So the credit balances being on another system, and being a day behind would not work. I'm told that Sage MAS 90 uses Providex as a database, and some newer versions use SQL Server- for an extra fee of course. I'm fairly ignorant of the Sage software... Has anyone done any kind of integration like this, where you have made U2 talk to a Sage MAS 90 server in real time for Accounts Receivable purposes? Or do you know of anyone who knows Sage MAS 90, because our current consultant, seems to be clueless? -- John Thompson ___ 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] FAST (File Analysis and Sizing Tool)
Personally I'd be more than a little worried about a product that had s many bugs it required fixes every 3-4 weeks, OR was s feature poor that it needed that many tweaks I would have thought if you were selling a product in this space, given that the fundamentals of the file structure haven't been undergoing any major enhancements recently that I'm aware, an offering should be bug free feature complete. Just a casual observation YMMV Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Doug Averch Sent: Wednesday, 5 October 2011 2:52 PM To: U2 Users List Subject: Re: [U2] FAST (File Analysis and Sizing Tool) Hi Eric: At the U2 University meeting in 2009, one FAST user told me they paid $40,000.00. Yes, that is 40k for FAST. The pricing was based on the number of users the had on their machine. Obviously, they had a lot of users. In today's world if you are paying Oracle pricing for this tool from written in the 80's with a VBA Client Server interface. There web site is talks about Windows NT/2000. Windows NT support stopped in 2004. Come on, let's use a tool made for this century. No wonder no understands U2 outside of our world. You guys and gals are extolling to virtues of a company that has not even updated their web site in 7 years. [ad] Try XLr8Resizer plug-in for Eclipse on a trial basis for FREE, or pay U2logic only $99.00 per year. Save you and your company thousands and thousands of dollars. This tool is state of the art. We update all of our tools every 3 to 4 weeks with enhancements and fixes. [/ad] Regards, Doug www.u2logic.com U2 Tools for the rest of us ___ 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 11.1 64-bit on Cisco UCS with NetApp Filer?
U exactly what makes you think that moving from a dedicated piece of iron that was (essentially) just servicing a single application (UV?? Right??) was going to faster when you went to a virtualized environment, where resources are being shared between who knows how many other virtual environments, with unknown resource loads? At one level I can understand the assumption that 64 bit MIGHT be faster than 32 bit (you did some benchmarks with your data before the move, right?), but what CPU, memory disk/network bandwidths were you working with before after the migration? I assume the telnet initiation is just to the OS rather than UV, so this should tell you something ... Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adam Taylor Sent: Wednesday, 10 August 2011 12:17 AM To: u2-users@listserver.u2ug.org Subject: [U2] UV 11.1 64-bit on Cisco UCS with NetApp Filer? All, We recently upgraded and virtualized our UniVerse servers to UV 11.1 64-bit on a Cisco UCS B Series platform with a NetApp 3040A/A Filer. Going to 64-bit with an upgrade in the virtualized environment, we expected to see a noticeable (if not significant) increase in performance than we were achieving on our old physical 32-bit server. However, not only has performance not notably increased, we are having random slowdowns in various areas of the system that were not occurring before. I say random, because while it does seem to affect certain areas more, it is not consistent. Some examples of behavior that has changed since the virtualization: An SB screen that has some calculated fields on it will take a minute to load, but the next time it loads it loads in just a couple seconds for the same record. An ASP webpage with 10+ queries against different files (heavy-duty processes) using Web DE to connect will takes 5-6 minutes to load that was only taking a minute before. Randomly, saving a change in the SBClient screen designer on our Dev environment will hang for 20-30 seconds. (Same virtualized specs, but far less traffic due to being a dev environment.) Simply initiating a telnet session, sometimes it will be 10-15 seconds before the login prompt appears to enter username and password. Does anyone out there have any experience with any of these pieces (UV 11.1 64-bit, Cisco UCS, NetApp Filer) that could shed some light on why we are now seeing these performance issues? Thanks. Adam Taylor Director of Software Development O: (713) 795-2352 www.INXI.com IMPORTANT/CONFIDENTIAL: This message from INX Inc. is intended only for the use of the addressees shown above. It contains information that may be privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient of this message, you are hereby notified that the copying, use or distribution of any information or materials transmitted in or with this message is strictly prohibited. If you received this message by mistake, please immediately email or call us collect at (469) 549-3800 and delete/destroy 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] Document Management
Tony, Drop me an email - we have a system in Visage that might fit the bill. Actually we have done a few different varieties around the same theme, and have integrated aspects of this across our R5 ERP system, so people can store an original faxed order and a scanned copy of signed invoice for POD against an invoice etc. etc. We have done document control stuff for ages, initially as part of our QA system (http://www.stamina.com.au/R5/QualityAssurance.htm), and more recently (apart from R5 integration above) as part of an integrated OHS system, as well as some workflow automation stuff. We also did a stand-alone VB version at one stage. Nothing overly fancy, but as you indicated, eye candy, tweaks leveraging 3rd party capabilities are fairly straight forward Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno If anyone is familiar with a Pick-based package that fits the above description, please contact me. If you have the budget to create one in preference to buying one, I'm open to that as well. Thanks! Tony Gravagno ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Server Hibernation
Perhaps once you have the initial user input, then fire the backend off as a phantom - if you need to check progress, write progress inf out to a file that you could LIST from another session Ross Ferris Stamina Software Visage Better by Design! Ross, thanks; the processes run in serial from a paragraph list - unfortunately it needs some user data inputs to start up thus the need for a telnet session on the server console to start it; we learnt years ago it's not good to run this lot from a networked session! No SAN / NAS - just a proper RAID system in the server itself. The console telnet session is my main concern though... I might have to see if we can start the processing off from a local UV shell; that might be more feasible than a local telnet session. Kind Regards Arnold Bosch IT Administrator Taeuber Corssen SWA (Pty) Ltd -- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universe Server Hibernation
Obvious any connections (telnet, UO etc.) would be broken in the hibernation. Likewise, if you have process being fired off at specific times, and you miss these cause system is off, you will have issues. BUT/IF the only processes running are phantoms, AND they are not accessing data across a network (*warning* may include a SAN HBA!!) you should be fine Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Boydell, Stuart Sent: Wednesday, 20 July 2011 11:31 AM To: U2 Users List Subject: Re: [U2] Universe Server Hibernation I have hibernated UV on linux and also suspended a VM running UV/linux and even hibernated the VM server running the client running UV with no issues - but this is a single user dev system. I would be very cautious of putting a production system to something not explicitly supported by Rocket - but by necessity it may be worth looking into. It may solve your situation nicely and if you do a properly managed clean reboot the next morning you'd probably be in pretty good shape. You could do a simple smoke test - download a copy of the PE edition of UV to a PC, run up a few sessions (up to 2 or 10 with device licencing on PE?) running a program doing logged read/writes (I'd try a few different types of R/W readu, readv, sequential, transaction bounded etc) and hibernate and wake it and see if you get any issues. Let us know how you go. Cheers, Stuart -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Arnold Bosch Sent: Wednesday, 20 July 2011 01:31 To: U2 Users List Subject: [U2] Universe Server Hibernation Hi Has anybody ever tested how Universe behaves if the server is hibernated to disk ? Does it work and resume locally logged on sessions properly when the server is brought back up again? Obviously all network sessions will be aborted, but I'm not concerned about that. For background: We're running Universe 10.2.10 on Windows 2003 Enterprise X64 Server. Every night we have backups, a lot of batch update jobs and reporting that runs on the UV server. During this time period, there are no users connected to the system; only administrators can connect. Last week one night we had a power failure that outlasted the 4 hours run-time we have on our UPS, resulting in the server going down without a proper shutdown; fortunately not while in the middle of doing updates. I am concerned that something similar might happen while the system is processing; during the day it is OK as there are IT staff on-site that can make sure that user sessions are terminated as normally as possible and the server brought down gracefully during long-running outages. Why I'm asking about the hibernation: If there are local UV processes running, and the server is suspended to disk, will such processes carry on from where they left off when the server is brought up again ? - this could save us a lot of recovery time in such cases - rare as they are. Currently we have to look at at what point of the nightly jobs the server went down; if it was during backups no processing would be done; if it was during processing, we have to restore the backup to get the server back to a known state and so on. Kind regards Arnold Bosch IT Administrator Taeuber Corssen SWA (Pty) Ltd -- - Disclaimer: This email message is intended solely for the use of the individual or entity to whom it is addressed and may contain confidential information which may be privileged and protected by law. If you are not the intended recipient, please notify us at our email address, delete this message and do not disclose the contents of this email message to any other person use it for any purpose or store or copy this email in any manner or form. Opinions, conclusions and other information contained in this email message that do not relate to our official business shall be understood as neither given nor endorsed by us. We do not represent, warrant and/or guarantee that the integrity of this communication has been maintained or that this communication is free of errors, virus, interception or interference. ___ 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] Record Locks - How long should they last for? (Opinion)
why haven't the MV DBMS vendors created a READUO Possibly in part because of the need to then have resolution mechanism for when 2 processes change the same data (assuming of course that the data wasn't, say, an accumulation total) -- what interface would you use telnet will not work nicely with the web app described, nor with someone using, say UOJ Still, extend a bit, and it could throw an error with the differences to be handled by whatever application layer -- but of course the real kicker in all of this is, and always has been, the wealth of legacy code that WOULDN'T use the new mechanism without a major rewrite and if you get to THAT point, refer to why U2 thread :-( Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Thursday, 14 July 2011 8:46 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Record Locks - How long should they last for? (Opinion) After all of these years, why o why haven't the MV DBMS vendors created a READUO mechanism which allows us to optimistically lock records in exactly the way that George, Rex, and a hundred other app developers have indicated over the last 15 years? Design tip: For all new development, abstract your file IO and all OS access into separate functions, Includes, and/or subroutines, away from the business code. This way you can change your datastore interaction without messing with your application logic, and you can re-use the routines for a lot of different work. The application needs to be aware of whether you're moving forward with a pessimistic or optimistic lock, but your app code shouldn't have to manage those mechanisms. T From: George Gallen ... instead of the checksum token method, I was going to write the record to a holding file with an ID that was a combination of file/record/transaction token And do a comparison using the saved item to see if record changed, but only if the record lock had expired - I still wanted to keep the locks since the system could be used by local users as well, which is easier using the READU locally to test for locking. ___ 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] Windows DFS Replication
I have no direct knowledge, but I suspect that the remote differential compression used by DFS would need to examine the entire file to determine changed blocks, and with a non-trivial UV file of a couple of hundred megs, I imagine that the overhead would be LARGE. However, if you were looking at this as a periodic update mechanism for a mirrored server (say, on a nightly basis), rather than attempting real time database replication changes, you might be in business :-) All speculation on my part, and happy to defer to someone with firsthand knowledge, but if you could share an insight to the result you are trying to achieve, others may be able to provide a more accurate response. Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jerry Banker Sent: Tuesday, 28 June 2011 8:04 AM To: U2 Users Group Technical Subject: [U2] Windows DFS Replication Is anyone using Windows DFS Replication with UniVerse on Windows Server 2008? Jerry ___ 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] Emulate SQL MAX() function at TCL
Create an index on the @ID makes it easy/faster to find :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, 27 May 2011 11:33 PM To: U2 Users List Subject: Re: [U2] [UV] Emulate SQL MAX() function at TCL I am going to assume we are talking about a HUGE file, otherwise efficiency wouldn't much matter. I don't know a GOOD way outside basic or sql to prevent a sort-selected list from being created. For humongous files, that may be painful. Here is a way, not a GOOD way, just a way. I just can't help myself: 1. Use an I-descriptor to compare last max to current id and set new max if necessary. 2. Use REFORMAT to continually overwrite the same record with the newly found max. (737 is the biggest id in this example): CLEAR.FILE TINYWORK File TINYWORK has been cleared. REFORMAT BIGDATA EVAL 'BIGDATA.MAXID' EVAL @2; IF @1 @ID THEN @1 ELSE @ID BIGDATA.MAXID @2 ; IF @1 @ID THEN @1 ELSE @ID File Name = TINYWORK CT TINYWORK BIGDATA.MAXID BIGDATA.MAXID 0001 737 DISPLAY -- or if you prefer F(TINYWORK,BIGDATA.MAXID,1) -- or if you prefer 737 QED (That's Latin for Quirky Example Demonstrated) A related I-desc could be used as REFORMAT selection criteria to limit the writes to only when the max changes. On average, that would halve the writes. A huge sort-select is going to be writing to uvtemp anyway, but I'd bet your money it will be faster than the above. __ If you're going to do it inside basic, like some others have suggested, you might as well try this to avoid creating a sorted select list in memory / uvtemp: SELECT FVAR MAXID = LOOP WHILE READNEXT ID IF ID MAXID THEN MAXID = ID REPEAT But test to see if it is a good idea. I'm continually surprised by RetrieVe's efficiency compared to what I can do in Basic. On 5/27/2011 5:40 AM, Wols Lists wrote: On 27/05/11 07:03, Boydell, Stuart wrote: Just wondering if anyone has a neat trick for picking up the highest ID from a file. Where the file ID is an integer. With UVSQL I would SELECT MAX(@ID) FROM TABLE; - however, the program I need to do this within has the file (table) open and if I try to execute it returns the error 'Non-SQL re-entrant query calls are not allowed.' The best I have so far is: st = 'SELECT FILE @ID BY.DSND @ID' st-1 = 'LIST ONLY FILE SAMPLE 1' exec st capturing cap maxId = trim(cap4) Any other ideas? Extending your idea ... SELECT FILE @ID BY.DSND @ID SAMPLE 1 READLIST Not quite sure whether SAMPLE is the correct keyword, because I think one keyword samples then sorts (that might be SAMPLING), but I'm sure there is one that sorts then samples. If you can't find the keyword, the other trick could be SELECT FILE @ID BY.DSND @ID READNEXT CLEARLIST ___ 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 to Remote Warehouse
Something like AccuTerm will still support all of your AUX code to operate in pretty well the same manner as the dumb terminal. IS the site permanently connected ... or are you using something like a Windows based PPTP connection? Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Thursday, 26 May 2011 8:36 AM To: U2 Users List Subject: Re: [U2] Printing to Remote Warehouse Probably a HP JetDirect print server could be connected to the LPT port of the printer. If yes, there are some steps to perform that me and others on this list could help with. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bryan Evans Sent: Wednesday, May 25, 2011 5:23 PM To: U2 Users List Subject: [U2] Printing to Remote Warehouse I apologize upfront if this is more related to Unix rather than UniVerse. We have a remote warehouse that connects to us via telent on a dumb terminal. They have a line printer hooked up to the dumb terminal. When we print packing lists, we open up the aux port and send the print job to the printer. We are looking to eliminate the dumb terminal, but we are stuck on how to send a print job to a local printer hooked to a PC. Has anyone done this before? Is it possible? The remote warehouse is not on our network - the only way they can connect is via telent. We are running UniVerse 10.2 on HP-UX and use AccuTerm as our emulation software. Thanks in advance, Bryan Evans ___ 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] Pondering recent thread on compact framework
I certainly agree with the concept of pro-actively pushing information to people via email. Information can be readily accessed from virtually any device (even the desktop!), and if these notifications are triggered by critical business events, as well as standard daily reports, then it just helps the overall feature set of the system The same technology can then also be used to push SMS to mobiles, as there are a myriad of email -- SMS solutions available. We have clients who have been doing this for over a decade, especially in industries where your customers are pretty well guaranteed to have a phone on their hips (anyone seen a locksmith WITHOUT a mobile :-) Ross Ferris Stamina Software Visage Better by Design! SNIP Finally the issue is the cost benefit analysis. Do I write an app that allows executives to access KPIs from my application. Would sending them an email with the KPIs be far cheaper and simpler. At what point is it productivity and at what point is it playing with 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] Redback Limit
You said you were making XML no stray or in the data you are generating that could throw things off? Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: 31 March 2011 6:33 AM To: 'U2 Users List' Subject: Re: [U2] Redback Limit There were 13 columns with 970 rows (including a header). These columns included: E-mail address User Name Domain User Type Last Login Date Last Login Time AR Inq (1/0) Sales Inq (1/0) RMA Inq (1/0) Products Inq (1/0) Storefront (1/0) USA Companies (svm) Canadian Companies (svm) The last 2 columns contain the company # and name. Everything worked find for a while. At some point, we noticed that it was no longer working. I suspect this was when we reached a certain number of users thus hitting a limit. Using a SAMPLE XXX on my SELECT, I was able to determine the last record that would work. I looked at it and the following record for bad info, but there was none. I skipped over the offending record, but it simply blew up on the next record (thus hitting the suspected size limit). Taking the names out of the last 2 columns (thus only returning just the customer numbers) worked, but was not meaningful. I have since redesigned this whole process to created an XML file on the UNIX box then E-mailed it to the user as an attachment. Thus, the exact same info is received by the user, but no data is actually passed back to the web page. Just one of life's little mysteries. Thanks for all the input. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Holt, Jake Sent: Wednesday, March 30, 2011 2:16 PM To: U2 Users List Subject: Re: [U2] Redback Limit How many fields do you have? From what I remember reading, there was a field limit on RBOs, it was like a thousand fields though. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, March 30, 2011 10:33 AM To: 'U2 Users List' Subject: Re: [U2] Redback Limit It was not timing out. I have other pages that take longer. It really seemed to be a size limit. I develop with FF with a Web Developer plug-in that helps a lot. I validate with IE, Chrome, Opera and Safari, but FF is my preferred browser. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Glen Batchelor Sent: Wednesday, March 30, 2011 11:03 AM To: 'U2 Users List' Subject: Re: [U2] Redback Limit Try using cURL or wget, with an unlimited timeout, and get the real headers from the server. Assuming you're using IE, it rarely tells a true story when it comes to server connection issues or HTTP errors. Glen Batchelor IT Director/CIO/CTO All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: webmas...@all-spec.com Web: http://www.all-spec.com Blog: http://blog.all-spec.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Wednesday, March 30, 2011 8:33 AM To: 'U2 Users List' Subject: Re: [U2] Redback Limit I was exporting all the user info we track with Avanté's ePortal from ePortal back to a web page which rips the data apart and automatically opens it in Excel. Over 900 records with all kinds of info (name, company, access, etc.) I was never able to find any corruption in the data. I did find that by capping the number of records OR not loading the company names of the users the problem went away. If I wrote the data to a temp file prior to loading up the RBO to pass back to the web page, there was nothing wrong. I think there is simply a limit somewhere. I am not sure if the limit is on a specific property (mv list of company/name the user has access to see) or the RBO in general. Either way, I could not wait on this and I have had to re-engineer this export. What used to automatically build an Excel file for the user via an ASP web page will now create an XML file of the same info in ePortal (on the UNIX box), then E-mail it to the user. Granted, this was a lot of data, but with today's technology, I did not think it was THAT bad. John Israel Senior Programmer/Analyst Dayton Superior Corporation 1125 Byers Road Miamisburg, OH 45342 -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent
Re: [U2] U2UG Elections 2010 - Request For Comment
Could we make it a hover-board rather than a skateboard :-) My 16 year old son has just come up with a working design . just very unfortunate that it only works with super conductors cooled to around absolute zero, so better throw in a pair of socks! I've always liked the idea of socks as a gimmick (here is a pair of socks you'll need them after we knock your socks off when you see what we can do), but Rocket Socks work just as well :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: 23 March 2011 5:39 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2UG Elections 2010 - Request For Comment In a message dated 3/21/2011 3:43:59 PM Pacific Daylight Time, da...@dacono.com.au writes: First Fft2001 Can we have your name. How do we know that you are not someone from a competitor like Oracle trying to make Rocket look bad. Secondly the focus on money is pointless. We don't need money we need ideas. If anyone has a good idea and it needs some money from Rocket to make it happen, then I am sure that Rocket will consider it. Rocket is not like IBM who were sucking money out of U2 to push DB2, Rocket brought U2 to grow the business and if you have any ideas that will grow the business they will listen. Throwing money at a problem does not solve it. The board have racked their brains trying to come up with ideas to touch base with all users, if anyone has ideas let us know. Thirdly the directors don't have the time to do everything that is required, many hands make light work and we need more involvement of other users. Here's twelve hundred and thirty google pages, to tell you who I am http://www.google.com/search?hl=q=fft2001%40aol.com The focus on money is not pointless. Here's an idea (which costs money), send a postcard to EVERY person on Rocket's tickler file. And when I say every, I do mean every, saying Please join U2UG and we'll send you a free skateboard... or whatever. I got a skateboard from a vendor with whom I *don't even do business*. No business with this vendor, ever. From Rocket I don't even get a phone call. AND I PROMOTE THEM! :)~~~ so there. That will grow the business by not shrinking the business. I just had another encounter, with *yet another* Mv prospect who is completely disconnected from the mv world except through their VAR. What that means is that if the VAR pisses them off, they will be completely disconnected. That means, the executive level will then say, Oh this system is old, nobody uses it, lets get something bright and shiny... and off we go. The board has racked their brains... how about an actual phone call from an actual Rocket salesperson? The last time anyone from universe under Ardent or under IBM or under Rocket has even *called* me was probably back in 2001. The internet makes people foolish, thinking that they can continue to do business, easier now all by email. What happened to the days when salespeople actually visited sites? Anyway to what kind of outreach are you actually referring here? Throwing money at a problem *does* solve the problem, if the problem requires money in order to make it happen. Not everything is free. W ___ 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 Elections 2010 - Request For Comment
I'd suggest that in part it would be driven by the clients VAR's -- they want to protect their client base from poachers, which is why I think the mvcommunitymap website may ultimately fail -- I mean, it is good for Tri-Sys, as they will generate a list of end users to solicit, but I'd suggest it is unlikely that a VAR is going to make his customer list public ... Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: 16 March 2011 8:17 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] U2UG Elections 2010 - Request For Comment If as one person remarked, he is the only one in a sea of twenty multi-value employees who knows about U2UG or is a member, than I would humbly suggest that it doesn't. In the vast majority of the multi-value environments in which I've worked in my *cough twenty six cough* years in Pick, even finding a copy of Spectrum is a rare experience. So I think there is really an enormous amount of outreach that could be done, which isn't. I don't know why that is. -Original Message- From: Wols Lists antli...@youngman.org.uk To: u2-users u2-users@listserver.u2ug.org Sent: Tue, Mar 15, 2011 2:07 pm Subject: Re: [U2] U2UG Elections 2010 - Request For Comment On 15/03/11 20:04, fft2...@aol.com wrote: In a message dated 3/15/2011 5:10:43 AM Pacific Daylight Time, br...@brianleach.co.uk writes: Plus of course, since we don't charge fees, we don't have any budget to advertise our presence! Why isn't Rocket themselves giving a budget? Let's ask a slightly different question - where and how would we advertise ourselves? This mailing list probably reaches the widest target audience ... 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] unidata triggers and record locks
So, does your trigger actually handle LOCKED case correctly? If not, I'd suspect that you probably find that sometimes people will have a session that just hangs (on the READU!?!) and you have to log them off/kill process to get them back ring any bells? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: 26 January 2011 7:07 AM To: U2 Users List Subject: [U2] unidata triggers and record locks Unidata 7.2.x on RedHat. We use update triggers a lot, often so that data changes in file A are written/accumulated in file B. I've found cases where the data in file B is incorrect - if I look at file A, the trigger should've updated B but did not. Moreover, if I pull the offending record from file A into an editor and save out with no changes, the trigger properly updates file B as it should. My guess is that record locks on file B may cause the update trigger to fail, but I'm open to other suggestions. -- Jeffrey Butera Manager of ERP Systems Hampshire College 413-559-5556 ___ 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] Migration
I assume you aren't talking about just ANY old BOM, but one with 10 or 15 levels of nesting, right ;-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, 23 December 2010 8:36 AM To: U2 Users List Subject: Re: [U2] Migration Might be great for a specific web app, but just try to build a Bill Of Material with that kind of data structure. ;-( And wouldn't that just be a prime example for being application specific? On 22/12/2010 21:04, Shawn Hayes wrote: I realize there is a bit more to MV database design then just parent- child relationships. The lack of constraints is both a curse and a blessing in the MV world. However, I don't accept that you wouldn't want a product category file that holds all the product information in MV fields or order and invoice data as MV fields in a customer file. A single read sounds intriguing in a web app?!?!?!? 'We act as though comfort and luxury were the chief requirements of life, when all that we need to make us happy is something to be enthusiastic about.' ___ 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] Connectivity issue with ODBC - SQL.
I assume that SOME of *** represent machine addresses are these actual IP addresses, or DNS entries? I've seen situations where DNS entries will intermittently fail when they are being resolved. If you are using nice machine readable names, possibly add a hard coded entry to your hosts file (buried in system root\windows\system32\drivers\etc IIRC), or, BETTER YET, plug in a fixed IP address and avoid the lookup entirely -- you may even save a few useless cycles I'm also with David knowing something about the workload could shed more light, and also check event viewer for other unrelated errors being thrown immediately prior HTH Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, 24 November 2010 5:13 PM To: 'u2-users@listserver.u2ug.org' Subject: Re: [U2] Connectivity issue with ODBC - SQL. You don't mention the nature of the processing you're doing...so here's some 'potential' scenarios... :) But in reality it could be lots of things... 1) Lost connection to UV Is it possible you connection is timing out? That is, your UV ODBC connection is timing out - possibly? Check the timeout in your unirpcservices file for ODBC connections and check what your application is doing - perhaps it is opening the connection first, doing a MS SQL query and in the mean time the connection is lost? 2) UV SQL Query failure due Check the log files on the UV side in the account where you queries are connecting to for any log files (uvodbc.log or uverror.log, etc) applicable for your UV release. Is the files/tables you're querying dynamic hashed files (are they OK? Not need of repair/fixing) and have you checked by manually doing the same SQL query from UV itself using the CONNECT verb or at the TCL prompt in the account you're connecting to? Are there any SQL Updates going on? If so I'd be thinking that there is locking contention issues may be happening (such things you can't reproduce on demand)... I also wonder if your process is running out of memory or the like (any core files?)...perhaps consider explicitly setting up the buffers in the uci.config. But that seems unlikely and perhaps should be a last resort type change! Yet, again speculation unless we really know what you're query is doing... It may be worth while to turn on some UVODBC logging if you still have problems - beware of log file sizes though! :) Regards, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Ken Ford Sent: Wednesday, 24 November 2010 12:44 PM To: u2-users@listserver.u2ug.org Subject: [U2] Connectivity issue with ODBC - SQL. From: Ken Ford Sent: Wednesday, 24 November 2010 11:37 AM To: 'u2-users@listserver.u2ug.org' Cc: Angel Frost Subject: Connectivity issue with ODBC - SQL. Could anyone shed light on the following problem we are having? We have a Windows 2003 R2, running SQL Server 2008R2 connecting to Universe 10.3 on AIX 5.3, via UniVerse ODBC driver 3.7 And are getting the error below intermittently (sensitive details represented with '*'s): Message: Executed as user: ***. The OLE DB provider MSDASQL for linked server ** reported an error. The provider reported an unexpected catastrophic failure. [SQLSTATE 42000] (Error 7399) Cannot initialize the data source object of OLE DB provider MSDASQL for linked server **. [SQLSTATE 42000] (Error 7303). The step failed. We have checked the user group list archives, and couldn't find anything matching this completely. Thanks for any help you can provide, Ken Ford Senior Software Engineer - Universe Today, the Universe - tomorrow, the world! ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ 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] Accuterm Historical question
So celebrating 21 years! Finally come of age!! **!! CONGRATULATIONS !!** on an iconic product!! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Peter Schellenbach Sent: Friday, 5 November 2010 8:47 AM To: U2 Users List Subject: Re: [U2] Accuterm Historical question Hi Charles - AccuTerm is an independent project - the original DOS version was released in 1989, and it has been updated many times over the years, to its current incarnation as AccuTerm 7. Hope you are enjoying the product! Thanks, Peter Schellenbach p...@asent.com At 01:14 PM 11/4/2010, you wrote: I recently started using Accuterm. When I checked out the multivalue stuff, a bell went off. FTTCL reminds me of something I fooled with a long time ago. Did Accuterm come out of an earlier software package? WIN something? 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
Re: [U2] Licensing
Would depend on the TYPE of licences you have as to wether device licencing would work for you I believe Ross Ferris Stamina Software Visage Better by Design! -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: Friday, 22 October 2010 6:34 AM To: U2 Users List Cc: U2 Users List; u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Licensing There has been a lot of discussion about that. If there is a way to take advantage of device licenses or connection pooling, we would like to take a look at that. Charles Shaffer Senior Analyst NTN-Bower Corporation George Gallen ggal...@wyanokegroup.com Sent by: u2-users-boun...@listserver.u2ug.org 10/21/2010 02:28 PM Please respond to U2 Users List To: U2 Users List u2-users@listserver.u2ug.org cc: Subject:Re: [U2] Licensing Shorten the autologout limit? -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: Thursday, October 21, 2010 3:28 PM To: U2 Users List Cc: U2 Users List; u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Licensing I think there is some of that, but for the most part they are real. Some folks like to keep 4 or 5 sessions open at a time instead of moving around between screens. 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
Re: [U2] Licensing
I thought Enterprise licences included device licences, Server didn't ...? Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Friday, 22 October 2010 2:34 PM To: 'U2 Users List' Subject: Re: [U2] Licensing As I understand, some of it depends on whether you have WorkGroup, Server, or Enterprise. You can have X count of device licenses allowed per IP address, with 10 I think being the maximum (10 is the 'standard count' for WorkGroup level licenses as well I think - it's 'built in' to WorkGroup licenses.) For server you 'choose' you Device License 'count'. And your example is correct - only thing to note is that if one machine has 12 connections and you have '10' as you Device License count, I think you'd end up being dinged 3 seats (1 for the first 10, then 1 for every seat used past 10). That's why if you are 'choosing' your device license count (as you would on the server licensing) you want to choose wisely! DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Marcos Sent: Thursday, October 21, 2010 10:22 PM To: U2 Users List Subject: Re: [U2] Licensing Not sure if I read DW's message correctly, but we have device licensing here and it works as follows; 1 device license means from 1 IP/device you can login to a maximum 10 uv sessions (thus only using 1 license) So 10 device licenses (10 individual IP's) equates to maximum number of 100 sessions . And can you mix your licenses on one machine?? Regards, Jeff Marcos -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Friday, 22 October 2010 6:38 AM To: 'U2 Users List' Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Licensing You have to BUY device licensing for this to be true... If you device license 3 devices - and connect 4 sessions from one IP, you will end up using TWO seats - one for the first 3 sessions, and then 1 for every session thereafter. DW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bob Rasmussen Sent: Thursday, October 21, 2010 2:32 PM To: U2 Users List Cc: u2-users-boun...@listserver.u2ug.org Subject: Re: [U2] Licensing On Thu, 21 Oct 2010, charles_shaf...@ntn-bower.com wrote: I think there is some of that, but for the most part they are real. Some folks like to keep 4 or 5 sessions open at a time instead of moving around between screens. Note that (unless something changed recently) your licensing actually is based on number of users, not sessions. If you have a terminal emulator that can handle this, properly configured, one user on one machine with 5 open sessions will consume only one license. Our Anzio emulators can do this. Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com 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 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 The information contained in this email and any attached files are strictly private and confidential. This email should be read by the intended addressee only. If the recipient of this message is not the intended addressee, please call Corporate Express Australia Limited on +61 2 9335 0555 or Corporate Express New Zealand Limited on +64 9 271 7600 and promptly delete this email and any attachments. The intended recipient of this email may only use, reproduce, disclose or distribute the information contained in this email and any attached files with Corporate Express' permission. If you are not the intended addressee, you are strictly prohibited from using, reproducing, disclosing or distributing the information contained in this email and any attached files. Corporate Express advises that this email and any attached files should be scanned to detect viruses. Corporate Express accepts no liability for loss or damage (whether caused by negligence or not) resulting from the use of any attached files. ___ 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
Re: [U2] XLr8Editor and Tools Updates
I like watching sparks fly ... bright or otherwise :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Saturday, 16 October 2010 8:23 PM To: 'U2 Users List' Subject: Re: [U2] XLr8Editor and Tools Updates Here here From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brenda Price Sent: 15 October 2010 22:06 To: U2 Users List Subject: Re: [U2] XLr8Editor and Tools Updates Begin Cyber-spanking: I personally saw nothing wrong with Tony's first response. I did however with Doug's first reply addressing Tony's post, then the resulting salvos from both sides. I suggest both refine from personal attacks, it is not professional. End Cyber-spanking ;) Sincerely, Brenda L Price UniVerse Lead Programmer Rapid Response Team Market America, Inc. Greensboro, NC U2 User Group Board Member - u2ug.org -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Friday, October 15, 2010 4:48 PM To: 'U2 Users List' Subject: Re: [U2] XLr8Editor and Tools Updates Tony: This is technical list and you responded as you always do, as a know it all. I never said I did not know how to do links nor did I say I need help in figuring out how to send an attachment. So what are you responding to? Tony, next time read the post! Regards, Doug www.u2logic.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Friday, October 15, 2010 2:03 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] XLr8Editor and Tools Updates From: Doug daverch-at-hotmail.com Hi Tony: Nice to see you cannot let anything go. Still holding on to the ex-girlfriend's picture? WTF was that about? I was responding to what was presented as a technical problem. This list service does not allow attachments and is in plain text. The next time you want people to contact you, just say so, don't make excuses that make you sound technically inept - and don't get huffy if someone posts a solution to a problem that you've presented. Are you still sore because some years ago I gave you grief about baiting people with freeware and then changing your model to buyware after people started using it? Really man, that was a long time ago. Let it go. 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 ___ 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.1136 / Virus Database: 422/3198 - Release Date: 10/15/10 ___ 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] [U2} Cloud UniVerse?
And/or, invest some time to have reports delivered as email attachments ... then no need for VPN's and you end up with easier (better?) overall deployment mobility moving forward. Also, if you end up investigating AWS, I believe you will find S3 OK for snapshot storage, but I'd investigate EBS for REAL database Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Glen Batchelor Sent: Tuesday, 5 October 2010 5:52 AM To: 'U2 Users List' Subject: Re: [U2] [U2} Cloud UniVerse? Keep in mind that VPNs and other SSL tunnels consume bandwidth even when 'idle' if you have keep alive or polling scenarios like with CUPS and network printers. They also apply additional overhead due to the encryption. If you are paying for a limited bandwidth service, then you should set up a test VPN to get a feel as to how much will be consumed by print services. Glen Batchelor IT Director/CIO/CTO All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: webmas...@all-spec.com Web: http://www.all-spec.com Blog: http://blog.all-spec.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Tom Whitmore Sent: Monday, October 04, 2010 2:42 PM To: U2 Users List Subject: Re: [U2] [U2} Cloud UniVerse? Printing is not a problem. We have customers that are using a hosted solution and Printing works fine. You should have a secure connection between your network and the server, so setting up printers is it is an internal server. Tom RATEX Business Solution. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman Sent: Monday, October 04, 2010 2:33 PM To: U2 Users List Subject: Re: [U2] [U2} Cloud UniVerse? Tony: Thanks for writing. I expect that one of the kickers in this is printing forms. Right now I cannot see how to send print jobs from the cloud host through our static IP router to our printers. Also, I sent a message to our sales rep at Rocket to ask about how licensing would work. That is, would we need to buy more seats or is there special pricing for disaster recovery seats. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: Monday, October 04, 2010 1:52 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [U2} Cloud UniVerse? Knowledge about the platform is certainly a good thing, but is it necessary? What's wrong with getting root-level Linux or Windows from any number of providers, and simply hosting your own environment? This is quite simple, really. Base pricing ranges from $15/month though maybe $100/month depending on disk, traffic, and memory. I know some U2 sites are hosting with CoLo's with various services totally anyhere from $400 to $800 per month. My recommendation: Find a low-cost host that provides root access for Linux or Windows. Install and configure your U2 environment within the usual money-back trial period of 30 days or so. Don't make any long term commitments. If you don't like it you have spent zero to maybe $30. Once you have the software installed you will know more about your actual needs. Then you can decide whether you need the services of a company like Zumasys (well recommended with MV expertise) or RackSpace (well recommended but no U2-specific experience). Also consider using Amazon services where you only power-on the virtual system (and pay for use) when you need it. Don't want to do this yourself? Find a well qualified U2 support company and ask them to do it for you. Like I said, it's easy, and they may find themselves creating a whole new line of business for themselves. HTH Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! http://Twitter.com/TonyGravagno From: Tom Whitmore We had looked into hosted solutions. Check out Sumasys (zumasys.com), they are very knowledgeable about U2, or RackSpace. From: Bill Brutzman In case of a local disaster, we are wondering if there is available hosted UniVerse. I suppose that there is a license hurdle. I suppose it would be great if Rocket would consider doing hosting. I looked at Sierra Bravo's website. ___ 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 ad
Mark, A bigger question may be What are your statements going to look like? How are they currently produced (eg: embedded PCL commands to a laser printer)? If you are looking at doing more with your fancy new emailed statements than simply duplicating a dreary text only statement with minimal formatting, then you might want to check out our Visage.Reporter offering. You can design your statement by dragging dropping elements from your dictionary, enhance with color graphics, and then deliver via email (typically as a PDF) and/or fax. (You could direct to a printer, but why pay for the ink :-) Chances are, once you get started, delivering statements, purchase orders etc is likely to quickly follow statement production :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Mark Warner Sent: Sunday, 12 September 2010 1: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] 24 X 7 MV systems
Hi Glen, Thanks for the reference. FYI, you can configure Visage.DRS to operate over point to point SSL connections - individual deltas can also be zipped to reduce bandwidth, and the zip can also be password protected, but as your probably know this simplistic encryption (password protected ZIP files) can be brute-forced but SSL would provide adequate protection on the wire :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Glen Batchelor Sent: Tuesday, 27 July 2010 1:03 AM To: 'U2 Users List' Subject: Re: [U2] 24 X 7 MV systems Hey Stranger, The best way you'll get there is with a transaction/request based redundancy setup. Does U2 have anything that isn't trigger related? Even a block-level DRDB config won't help with databases since transactions in memory aren't committed to disk promptly enough for the replicator to get all of the new data pieces as the fault happens. I've been looking for a remote hosted failover solution myself (not for U2). A truly fault tolerant setup requires that the incoming requests be replicated to multiple machines before anything happens inside. You might think of the user app as a web service consumer that makes requests to a proxy. That proxy mux's the requests to multiple machines, compares all of the responses and then passes back the response of one machine based on failover priority. If one of the responses aren't the same then an error is sent to the admin. Unfortunately, this spits in the eye of MV which is designed to be a stand-alone central data store. Maybe you can do it with your own TCP packets, but if you don't use an encrypted media you may get into security trouble. Web services are horribly bloated, but the security layer is already in there. You should bug Ross Ferris and pick his brain about his DRS product versus other options for U2. DRS supposedly uses a small amount of bandwidth but it isn't encrypted AFAIK. Regards, Glen Batchelor IT Director/CIO/CTO All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: webmas...@all-spec.com Web: http://www.all-spec.com Blog: http://blog.all-spec.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: Monday, July 26, 2010 9:38 AM To: 'U2 Users List' Subject: [U2] 24 X 7 MV systems Hey y'all, I'm interested in hearing from folks who are currently on, or have worked with fault tolerant MV systems. We'd like to host our Business Layer on the MV system and serve It to our e-commerce portals, instead of re-coding our business rules first in Basic, then in .Net In order to get there though we must meet the primary business requirement of zero downtime (not even 2 minutes to manually switch). We're not talking about different levels of Raid - it's assumed the storage array is up and available. If the MV system has a hiccup of more than a few seconds it needs to hot failover to a backup twin sister. Is anyone doing this or something close to it? When I worked in public safety, Stratus sold such an automatic hot failover. I'm sure the EnRoute folks are doing something like this still. Maybe Nick G. or Margaret M. is listening in today. Thanks, -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ 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] 24 X 7 MV systems
Hi Baker, As Glen and other have alluded, I believe you are unlikely to find a OS level replication technology that will work adequately, unless there is a way to force writes to the OS level immediately, which in turn is likely to have performance implications. We cheat with Visage.DRS - we don't force you to operate via a middleware layer, so it will simply plug in to an existing application without the need for any changes. If your application already uses transaction boundaries, that is great, but our data replication service doesn't need them. I thought UV had an inbuilt solution already though I seem to remember seeing a demo at a spectrum exhibition a few years ago, and I thought it looked OK? Not sure it necessarily allowed replication to multiple servers, but on the surface it looked as though the basics probably worked (then again, D3 Hotbackup looked good on the surface, but we had to write DRS when our largest client failed an IT disaster recovery audit) We haven't ported Visage.DRS to UV - hasn't been any demand we could see, but if there IS a need (translation: makes financial sense to invest resources) then it could be done Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: Tuesday, 27 July 2010 2:14 AM To: 'U2 Users List' Subject: Re: [U2] 24 X 7 MV systems Glen, Thank you for the good observations, and suggestion to ping Ross, which I will do. It is the MV db paradigm which in this case is hampering us, which drives the solution to either the OS level or some middle ware solution. Pausing the db to flush memory is what keeps us just seconds from a full solution. Thank you. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Glen Batchelor Sent: Monday, July 26, 2010 10:03 AM To: 'U2 Users List' Subject: Re: [U2] 24 X 7 MV systems Hey Stranger, The best way you'll get there is with a transaction/request based redundancy setup. Does U2 have anything that isn't trigger related? Even a block-level DRDB config won't help with databases since transactions in memory aren't committed to disk promptly enough for the replicator to get all of the new data pieces as the fault happens. I've been looking for a remote hosted failover solution myself (not for U2). A truly fault tolerant setup requires that the incoming requests be replicated to multiple machines before anything happens inside. You might think of the user app as a web service consumer that makes requests to a proxy. That proxy mux's the requests to multiple machines, compares all of the responses and then passes back the response of one machine based on failover priority. If one of the responses aren't the same then an error is sent to the admin. Unfortunately, this spits in the eye of MV which is designed to be a stand-alone central data store. Maybe you can do it with your own TCP packets, but if you don't use an encrypted media you may get into security trouble. Web services are horribly bloated, but the security layer is already in there. You should bug Ross Ferris and pick his brain about his DRS product versus other options for U2. DRS supposedly uses a small amount of bandwidth but it isn't encrypted AFAIK. Regards, Glen Batchelor IT Director/CIO/CTO All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: webmas...@all-spec.com Web: http://www.all-spec.com Blog: http://blog.all-spec.com This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ 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] 24 X 7 MV systems
Now that you have opened the door, I will say that I believe that the Reality solution is probably the best that is available from any vendor in the MV space that I have seen ... quite awesome. Cache also has some strong options in this area, BUT I think there is a non-trivial amount of plumbing that needs to be put in place (and not sure if this has been fully tested with MV implementation I know it shouldn't make a difference, but and now, back to your regularly scheduled U2 discussions (sorry) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: Tuesday, 27 July 2010 2:26 AM To: 'U2 Users List' Subject: Re: [U2] 24 X 7 MV systems Jeff, Thank you for giving your experience with HA AIX and a cluster. We are also doing the HA but not clustering. The couple minutes time lag you mention and the possibility of broken transactions make one wonder if it's worth going that distance. I didn't know Stratus was still out there so thanks for that. What about Sequoia? That was also a very coveted system in the 911 offices back in the day. Awesome story about the Sequoia still tooling right along while the disk is on fire. So did the system switch itself over to 'B' or did y'all do it, when? I can't match that one, but even with Reality 7 (sorry to mention this on the U2 list) we could throw a manual switch (took me about 30 seconds to get from my office to the switch in the computer room) and when the dispatchers logged in, there were their sessions with screens looking identical to system A. That's why I gotta believe we can do better, 20 years later. Thank you. -Baker -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Monday, July 26, 2010 10:24 AM To: U2 Users List Subject: Re: [U2] 24 X 7 MV systems We are running an IBM high availability cluster of AIX machines which do auto fail-over. There is a couple minutes of time lag involved and there can be broken transactions since the switchover is OS level and not applications based so this is probably not a good solution for you since it sounds like you are looking for a truly fault tolerant solution. Stratus is still out there and probably a good choice for your needs. I know they have at least one series of boxes which run Red Hat and therefore are U2 compatible. I worked on a fault tolerant Sequoia system running Pick OA many years ago supporting an alarm monitoring application. Amazing machines. True Story: The operations manager gets a call from the computer operator who tells him Theres smoke coming out of one of the disk drawers on the Sequoia 'A' system (we had a second redundant Sequoia 'B' system as well). A couple quick phone calls later 5 of us are huddled together in the computer room on various phones with Sequoia after hitting the raid disk drawer in question with a fire extinguisher, trying to decide if we should switch over to the backup system, when out of the little glass cubicle where the operators live comes the operator on duty. He walks up to the smoking system, pulls off a spinning magnetic tape, and mounts the next reel of a file restore he's doing for someone. We all look at each other and laugh because the system is still running along just fine while on fire. Baker Hughes wrote: Hey y'all, I'm interested in hearing from folks who are currently on, or have worked with fault tolerant MV systems. We'd like to host our Business Layer on the MV system and serve It to our e-commerce portals, instead of re-coding our business rules first in Basic, then in .Net In order to get there though we must meet the primary business requirement of zero downtime (not even 2 minutes to manually switch). We're not talking about different levels of Raid - it's assumed the storage array is up and available. If the MV system has a hiccup of more than a few seconds it needs to hot failover to a backup twin sister. Is anyone doing this or something close to it? When I worked in public safety, Stratus sold such an automatic hot failover. I'm sure the EnRoute folks are doing something like this still. Maybe Nick G. or Margaret M. is listening in today. Thanks, -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http
Re: [U2] Quick poll - how many use 3-tier or N-tier Architecture
Hi Baker, a) We, and our VARS/clients, utilize a middle tier, and you could also introduce an intermediate MV application server in the chain for execution of business rules intermediate staging if necessary (conducted Proof on Concept for one prospect). b) Not us c) We use Microsoft IIS and windows services on middle tier. Could rework middleware to operate via Websphere, but simply hasn't been the demand d) Nope e) Nope f) Visage - essentially just AJAX/HTML As you know, the Visage toolset eats native MV data structure (and indeed allows nesting well beyond just 3 levels) - can throw MV data to the outside world as well formed XML that can be consumed by most things these days (and Baker, don't forget we have a nice GUI ERP product if necessary :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: Friday, 9 April 2010 3:16 AM To: 'U2 Users List' Subject: [U2] Quick poll - how many use 3-tier or N-tier Architecture Would those of you mind responding that use 3-Tier or N-Tier architecture - I'm trying to gather some quick numbers for some decision makers (somewhat urgent). Please respond if your site, or sites who you service have UniData, UniVerse, or any other MV db on the backend, and any fully graphical user interface: a. How many have a middle-tier application server? b. How many use IBM Websphere? c. How many use some other? Please give product name if you can. d. How many have a Java front end User Interface? e. How many have a C# front end User Interface? f. How many have other UI? Please give name. For anyone - what Multi-Value aware / friendly middleware products are there? (That don't require data normalization before sending to the middleware.) Thank you so much, -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ 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] Major time delays
Sometimes I will have 2-3 days of silence, then suddenly a catch up Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Friday, 5 March 2010 7:36 AM To: 'U2 Users List' Subject: [U2] Major time delays I always get some fairly big time delays on messages from the group, i can see things on Nabble in the evening (GMT) that i don't get in my mail till the morning. But there are quite a few messages i can see on nabble from yesterday that I have not received yet in my mail. - No spam or virus filtered messages either ...Is this just me or are others affected ?? ___ 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] Embedded program for Windows
So, they print this order (?) out and then fax it to your client ...? Tell me again why it wouldn't make more sense to simply do this over the interweb? Incremental changes, new products etc would automatically be available to everyone IMMEDIATELY - and they would have access to the rest of the material on your customers website as well 10-15 years ago I remember doing stand alone order processes like this, with product updates burnt onto a CD from data extracted from D3, but things have moved on a LOT since then. Seriously, your customers clients don't have internet access??? The whole thing just sounds so 20th Century to me (sorry) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Monday, 22 February 2010 6:51 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Embedded program for Windows Thinking this over some more here is the stripped down version minimally expressed. A window appears with multiple line items listed. User chooses one of more line items, for each one enters some quantity desired. Submits, or saves, or closes or whatever. Next window only shows those line items they've chosen, and the quantity. This window they can print. This exe is given away free to customers, or at trade shows, or whatever. That's it. The idea is very simple. Maybe it would be better just to try to do something like this in Visual Basic without any Pick at all. Just make all the files .txt files. I really would have wished that U2 would get into the .exe market. It could cause the proliferation of U2 products (at least the results) to explode. Will ___ 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] Embedded program for Windows
OR you could specifically target IE, which gives you access to the file system so you can write/save/modify stuff (I know this breaks all of the interweb rules, but WSH is quite a powerful tool ... Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Thursday, 25 February 2010 7:22 AM To: 'U2 Users List' Subject: Re: [U2] Embedded program for Windows Tonys post got me thinking and actually running an app in the browser that is local gives a number of problems particularly with security, by default browsers will not run scripts on local pages, cookies can be a problem as well, and although in theory you would not need cookies as only the one person will ever access the app, they are still integral to web technologies so there may be a number of complications, thinking about this more what you would really need is not only an embedded database but also an embedded web server to serve the pages locally so as to get around these complications and as mentioned WAMP would be ideal here. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Tony Gravagno Sent: 22 February 2010 19:20 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Embedded program for Windows From: Will Johnson A window appears with multiple line items listed. User chooses one of more line items, for each one enters some quantity desired. Submits, or saves, or closes or whatever. Next window only shows those line items they've chosen, and the quantity. This window they can print. This exe is given away free to customers, or at trade shows, or whatever. That's it. This is funny - I just wrote a GUI for one of our clients that does exactly what's been defined here, except that we're scheduling people and quantities for manufacturing production lines. Mark, based on this limited set of requirements, you don't need an MV DBMS at all. This can be done in a short period of time, including the installer, operating against text files or perhaps MS Access files. This might just take a couple hours, and most of that time is time for head scratching, wondering why you wanted to involve MV in this at all. ;) I'm guessing that's not really the full spec. Again, I highly recommend that you and your client consider a very attractive installable client interface, thick or thin, to a remote server which provides the functionality, data storage, etc. Can you help us to understand why that may not be an option? If it is an option, then your solution may only be hours away. Also, I'd like to point out that installable progams for PC's rarely use a browser interface to the localhost. You either give someone a URL to a website, or you install a thick client for local use. The app can be self-updating (like anti-virus software and most others these days) and store the data locally or remotely. And of course all data management can be done on a remote MV server, and you can balance the logic between the client and MV server as well. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog 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-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Embedded program for Windows
So let me get this straight . you are standing in a FIELD, in Cootersville Alabama you don't have cell phone coverage but you have run a power lead from the house to the field, so you could sit at a desk with your desktop monitor?!? You probably are right, I don't understand, 'cause I'd probably whip out my old WAP enabled phone (yeah, I know I don't have a cell tower, but I probably still have it on me for when I'm travelling to town) which has the order page loaded up with the products and boxes where I can put my quantities in then when I'm on the highway (or back inside out of the sun or maybe Snow with the winter you guys have had) I can just hit the submit button. Problem Solved. Now, if you seriously want a solution, telling the whole story helps to get a whole solution. If you are in a field (on a tractor?) with no cell coverage (always satellite!) what device ARE you using ? What OS? (The beauty of web based is that the previous 2 questions are irrelevant!) alternatively, start pick'n!! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Thursday, 25 February 2010 9:54 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Embedded program for Windows Sorry Ross if you can't comprehend that people in the field are... in the field. Too much big city living perhaps :) When I say in the field, I mean actually standing in a field. We aren't yet to the point of having cell towers in every square mile of the country no wifi yet in Cootersville, Alabama -Original Message- From: Ross Ferris ro...@stamina.com.au To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, Feb 22, 2010 7:29 pm Subject: Re: [U2] Embedded program for Windows So, they print this order (?) out and then fax it to your client ...? Tell me again why it wouldn't make more sense to simply do this over the interweb? Incremental changes, new products etc would automatically be available to everyone IMMEDIATELY - and they would have access to the rest of the material on your customers website as well 10-15 years ago I remember doing stand alone order processes like this, with product updates burnt onto a CD from data extracted from D3, but things have moved on a LOT since then. Seriously, your customers clients don't have internet access??? The whole thing just sounds so 20th Century to me (sorry) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Monday, 22 February 2010 6:51 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Embedded program for Windows Thinking this over some more here is the stripped down version minimally expressed. A window appears with multiple line items listed. User chooses one of more line items, for each one enters some quantity desired. Submits, or saves, or closes or whatever. Next window only shows those line items they've chosen, and the quantity. This window they can print. This exe is given away free to customers, or at trade shows, or whatever. That's it. The idea is very simple. Maybe it would be better just to try to do something like this in Visual Basic without any Pick at all. Just make all the files .txt files. I really would have wished that U2 would get into the .exe market. It could cause the proliferation of U2 products (at least the results) to explode. Will ___ 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] Embedded program for Windows
Will, What exactly IS the application? At first glance it sounds like it may be a parts catalog? In which case the answer may simply be to TOTALLY remove the database from any deployment scenario, and instead simply have static pages generated from your MV database You have also used the term offline, so assume some form of web access doesn't fit the requirement. If you could add a little more meat in terms of what the application will be doing, then some alternatives may present themselves, but as others have suggested free rules out many obvious alternatives Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Sunday, 21 February 2010 9:07 AM To: u2-users@listserver.u2ug.org Subject: [U2] Embedded program for Windows I have a new client who after talking to in-depth, actually wants something completely different from what I first thought! Isn't that typical? At any rate, I'm interested in a system, in which I can write in Pick BASIC, and yet will throw up all it's results in a browser but everything will be offline. I can do the Basic, I can do the browser, what I need to ensure is that the Pick BASIC client is minimal, and either downloadable without licensing or registration, with a standard Windows download type look, bug free, OR actually compiled. That is, the customers, will use it entirely offline, but it must be as modern looking as possible, no special interfaces, just the browser. The browser MUST talk to the embedded database invisibly to the customer. The program, the database will all be downloaded as one program. Does that make any sense? Who offers that? And I need to ensure that there will be only a client cost, since the embedded program (in which you cannot change the code) will be given away for free to the customers. Will Johnson Fast Forward Technologies ___ 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] Agile and Scrum
Hi David, The rollback can be pretty easy if you have a virtual environment for the database testing ... Great story! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of David A Barrett Sent: Friday, 16 October 2009 7:01 AM To: u2-users@listserver.u2ug.org Subject: [U2] Agile and Scrum SNIP There are some Agile concepts that are a little tough to implement in an MV environment. Test Driven Development, for instance, is tough because you need an automated testing tool, and most MV programs constantly update the database, which means you need to roll back your database in order to reuse the test cases. All of which is tough. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unibasic: Sample Program
I think it also depends on a lot on the toolset you are using. This approach, if you are writing code in pure pick basic, with minimal dictionaries for the files you are using could be suicidal, yet with the right tools and mindset, this can be a VERY productive way of working. In this regard, I firmly agree with what Phil said in relation to his BI implementations - often it is far quicker to just do it than to describe what it is We have dubbed our implementation of agile, iterative development vRapid, and we have found it works very well in practice. Sit down with the customer, discover the data that needs to be (or is already being) kept and design some files and dictionaries around that. Document the inter-relationships as part of the Dictionary, and mock up some screens with these data definitions. These screens get fattened out appropriate business logic engaged during the iterative process, and in little more than the time it would take to develop a traditional spec you can have a fully functional application and the client has been engaged 100% during the whole process, so there are no surprises, and they are VERY HAPPY (and because they have seen how easy it is to accommodate change, the application IS likely to keep on growing organically, but this is controlled feature creep that you get paid for!) With the right framework in place, this approach can be a real winner, and deliverables can start to flow be deployed long before the entire project is complete, so it can become a win/win situation Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Thursday, 15 October 2009 6:56 AM To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program I agree, agile and scrum are the way to go However, this is not just a term for no specifications and an open ended project. This methodology requires a commitment of time and effort by all parties, most importantly a dedicated person from the business tied to the project who has a stake in the project, not just a BA or someone who cannot directly or quickly make decisions about what direction or priorities the project should take. This person, is responsible for seeing that the project delivers what the business requires quickly and iteratively...therefore lessoning any chance that is does not deliver what and when. If this happens then the project will deliver what the business requires when it is completed. (at least that phase). This in contrast to a lot off waterfall style projects where the business does not often know what they need, at least in detail and so a spec is just a best guess. If not then it will take a very long time to get it 99% accurate with no payback for the business, (it will never be 100% unless the project is very simple). Consequently, there will always change control issues, debate about who should pay for the change etc...very unproductive...as well as a BA who is acting as a translator between IT and the business. While a spec, might be technical documentation, it requires a lot of effort on the part of everyone to write it but more importantly to maintain it going forward...as I find when the going gets tough and time and money is short...documentation is the first to go, a decision made by who is paying the bills not anyone elses...This is where agile and scrum come to the fore...however it does require a culture change within the entire organization to that of a shared partnership between all parties striving for the betterment of the business rather than a confrontational approach which a formal spec signoff/ contract represents... My 2 cents. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brenda Price Sent: Thursday, 15 October 2009 8:31 a.m. To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program Well, when our company gets this fully implemented. You can count over 250 Highlander's Immortals on the list! Seriously, check out agile and scrum, it is interesting. Brenda L Price UniVerse Programmer Rapid Response Team Market America, Inc. Greensboro, NC -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Susan Lynch Sent: Wednesday, October 14, 2009 3:26 PM To: U2 Users List Subject: Re: [U2] Unibasic: Sample Program Ah, it must be lovely to know that you will live forever and will never become ill or incapable of working... Eventually, if the company does not go out of business, or their business needs change so much that all your code is obsolete, somebody else will have to figure out how the system works. A good spec turns into good documentation, which (properly maintained through all the ensuing changes to the system
Re: [U2] Unibasic: Sample program - to extract data from Table
I would think you are better off getting an example from your VAR, or the people that supplied/wrote your application, who will be better equipped to discuss what data you wish to extract from which files (tables), and where you are looking at putting/using the extracted data Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Dattatraya Walgude Sent: Monday, 12 October 2009 4:14 PM To: u2-users@listserver.u2ug.org Subject: [U2] Unibasic: Sample program - to extract data from Table Dear All I am new in Unidata/Unibasic, I want a sample program to extract data from one of our big history table. Kindly give me any link/ suggestion. Thanks Regards, Dattatraya Walgude Disclaimer * This mail, including any attachments contains confidential and privileged information for the sole use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email or any action taken in reliance on this e-mail is strictly prohibited and are unlawful. This e-mail may contain viruses. R Systems International Limited has taken every reasonable precaution to minimize this risk. R Systems International Limited is not liable for any damage you may sustain as a result of any virus in this e-mail. Before opening the e-mail or attachment, You should carry out your own virus checks. R Systems International Limited reserves the right to record, monitor, and inspect all email communications through its internal and external networks. R Systems International Ltd prohibits its information systems from being used to view, store or forward offensive or discriminatory material. End of Disclaimer ___ 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 need your eyes
Chuck, Nice work! An interesting follow-up investigation, for this community at least, might be to scour the next set of published IBM results, because somewhere in that haystack of papers one would expect to find a reference to the sale value for the U2 assets Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Anthony W. Youngman Sent: Friday, 9 October 2009 2:45 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] I need your eyes In message fba5ea46361c5c4fb61c02795188f6627b5a644...@vaunsw141.au.cbainet.com, Hona, David david.h...@cba.com.au writes It's interesting to see IBM's claims about they didn't buy U2 specifically (which we know they purchased Informix DB technology and U2 was a bonus) and it doesn't fit into their future goals. I find that amusing when they continue to sell databases like IMS and Informix C-ISAM (etc) and the like... which also don't fit... I guess the PR gurus had to come up with something!! Maybe IMS and C-ISAM are classic legacy, they're not selling and IBM can try to move them across to DB2. The trouble with U2 is it won't lie down and die ... :-) At the end of the day...it whatever works, I guess and whomever gives you the best value proposition. :) Well, if they're into selling DB2, and maintaining legacy stuff as it shuffles off to the graveyard, then yes, I don't think IBM is getting the value proposition they want from U2 :-) Cheers, Wol -- Anthony W. Youngman pi...@thewolery.demon.co.uk 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick ___ U2-Users mailing list U2-Users@listserver.u2ug.org 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] U2 is now Rocket U2 - what to call them?
Boosters? Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of bradley.sch...@usbank.com Sent: Thursday, 8 October 2009 5:53 AM To: U2 Users List Subject: [U2] U2 is now Rocket U2 - what to call them? I spoke to some IBMers... er... Rocketeers Maybe I missed this in the days after the announcement, but has the critical question of what to call Rocket Software employees been discussed? I kinda like Rocketeers but wonder if they'd prefer something else like Rocketers, Rocketmen (gender bias noted) or maybe even Rockettes? g What do you say, Rocket Software employees? Brad. 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
Re: [U2] Doing my Homework for me
Do you have Suzie's home number? Somehow I would think that unless these had been published previously (which I doubt), there will be all sorts of barriers to getting access to them . although I would have thought that any/all of these would have been metrics in the Rocket deal Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Results Sent: Friday, 2 October 2009 8:20 AM To: u2-users@listserver.u2ug.org Subject: [U2] Doing my Homework for me All, I just need a quick favor. Please respond to me directly, not via the list, as this is technically not a technical question. Does anyone have any *official* IBM numbers for U2 sales (by seats, dollars, or market share) for any of the years IBM has owned U2 technologies? Same question about # of total customers (whether they became customers before or during IBM's time)? It's for an article, so I need verifiable data where I can cite the source. All help appreciated. Please respond to me directly. - Chuck Press Pass Barouch ___ 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] Connection Pooling Statement
1 way traffic!! Of course going the other way, we also generate things like price files that we transmit to many people via email never got an answer as to wether this required a licence pool or not. In the end the exercise became too hard for IBM I think, and the eventual answer was along the lines of it depends, we would have to look at the specifics on a case by case basis ... nothing like shifting goal posts!! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Steven M Wagner Sent: Friday, 25 September 2009 11:56 AM To: U2 Users List Subject: Re: [U2] Connection Pooling Statement Ross The question that I would ask, Was this one-directional? PC to U2. Or bi-directional? PC to U2 and back. One-directional is data collection. Bi-directional could be seen as a way around buying licences. Steve -- Sent from my Palm Pre Ross Ferris wrote: Interestingly, one of the scenario's we ran past IBM back in April/March was the use of disk shares, where people could drop files from windows applications which would be picked up by a U2 phantom amp; processed they characterised this as requiring a connection pool licence! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Glenn Batson Sent: Friday, 25 September 2009 8:43 AM To: U2 Users List Subject: Re: [U2] Connection Pooling Statement I RedBack you would be using WebShares which is basically like Connection Pools. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Thursday, September 24, 2009 3:40 PM To: U2 Users List Subject: Re: [U2] Connection Pooling Statement I'm missing something. We ran Redback without connection pooling. Is that an exception because it's a U2 product or were we in violation? Ross Ferris wrote: Doug, I fear that if you look at the terminology and description that lt;IBM (Rocket may change, but somehow I doubt it) use to describe a connection pool, though you may like to think that your connection manager is different, I fear you may fall foul of their definition and if you look at your 175 user system running off 2 licences you can understand why (I assume that the 175 users also use other stuff, rather than everyone using NOTHING BUT your CRM) ___ 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] Connection Pooling Statement
I believe by the definitions provided by IBM (may be subject to change soon), this could NOT be considered as a connection pool, as each discrete connection only serviced an individual user, rather than a single connection servicing multiple users (now THAT is a connection pool!) somewhat academic, and will be interesting to see if a Rocket will be applied to this aspect of licencing. Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Land Sent: Friday, 25 September 2009 3:55 PM To: U2 Users List Subject: Re: [U2] Connection Pooling Statement But what you are describing is connection pooling which is when you need connection pooling licenses. George On 24/09/2009 23:27, Ross Ferris ro...@stamina.com.au wrote: David, I think your problem may be that you are logging only when you get a request? If you were to have lines pre-logged-in, though the complexity of the middleware increases, you may find a corresponding increase in performance ... and with a little more effort you may also decide to NOT kill a used connection immediately, 'cause if you get another request in from the same client soon, shouldn't be an issue using the previously used connection (that is still open) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Friday, 25 September 2009 5:47 AM To: 'U2 Users List' Subject: Re: [U2] Connection Pooling Statement If you log off and on, it does satisfy the licensing - letter and intent... BUT usually the performance hit is so high that it FORCES you to connection pooling - or to have lots more seats! Both of which make IBM-Rocket happy. g I'm still wondering how they can get 175 users through 2 seats -- unless each user does 2 things a day!! My understanding was that you either had to have a seat for each 'logical' connection to a user, or sign off/sign on between each 'thing' - and the overhead for going off and on is INSANE in any way I've tried to make it work... So - I understand your point George -- I am in the same headspace! David W. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Land Sent: Thursday, September 24, 2009 2:32 PM To: U2 Users List Subject: Re: [U2] Connection Pooling Statement On 24/09/2009 16:45, Doug dave...@hotmail.com wrote: George, We do not do connection pooling or use multiplexing software. I'm sorry, I didn't mean to imply that you did. I was trying to make a general point that you need connection pooling licences if you connection pool however you do it. We scale quite remarkable well. We have 70 user client running a call center with 10 Unidata licenses dedicated to the web. We have a public warehouse client with 4 licenses running 20 users internally and 20 customers externally. We have a 175 user running our CRM system using 2 licenses. There is a general point here though, supporting 175 users on a 2 license system is exactly the situation IBM/Rocket are trying to address by forcing you to have connection pooling licences. Now don't misunderstand me, I'm not accusing you of breaking the letter of the license agreement, but I think it is breaking the intention of it. Quite what 'connection pooling' and 'multiplexing' really is can be debated, but essentially what they want is for you to pay more for databases licenses that support multiple users than you do that are tied to one user. And having a small number of database licenses supporting a large number of users is exactly what you are doing George ___ 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] Connection Pooling Statement
Yep, now it takes 2 connection pool licences to buy SQL Server Enterprise, rather than just 1 I can see that makes a BIG difference LOL! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Friday, 25 September 2009 7:51 PM To: 'U2 Users List' Subject: Re: [U2] Connection Pooling Statement George Thanks, seems I was misquoted or the price has fallen (it was a while ago). At around 1700 GBP (with underlying licence) that's more reasonable. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Land Sent: 25 September 2009 10:38 To: U2 Users List Subject: Re: [U2] Connection Pooling Statement On 25/09/2009 09:51, Brian Leach br...@brianleach.co.uk wrote: My beef is quite simply with the price of pooled connections. With the cost of the underlying licence, you are talking around 3,000 GBP plus AMC per connection, which means 10 shares costs around twice the amount you can buy SQL Server Enterprise for and get unlimited connections. That is simply untenable. Hi Brian, Current price is actually 1,207 GBP with 181 GBP pa from year 2 onwards George ___ 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] Connection Pooling Statement
I believe the short answer is yes, they would require connection pooling licences Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Friday, 25 September 2009 7:08 PM To: 'U2 Users List' Subject: Re: [U2] Connection Pooling Statement So does this mean that all mv.net and designbais customers also should have connection pooling licences as well - after all they are multiplexing to some extent ? Do bluefinity and designbais have a statement on this ? ___ 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] Connection Pooling Statement
Doug, I fear that if you look at the terminology and description that IBM (Rocket may change, but somehow I doubt it) use to describe a connection pool, though you may like to think that your connection manager is different, I fear you may fall foul of their definition and if you look at your 175 user system running off 2 licences you can understand why (I assume that the 175 users also use other stuff, rather than everyone using NOTHING BUT your CRM) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Doug Sent: Friday, 25 September 2009 1:46 AM To: 'U2 Users List' Subject: [U2] Connection Pooling Statement George, We do not do connection pooling or use multiplexing software. We have a connection manager written in Java to handle the connections to Universe or Unidata. We adhere to our IBM licensing agreement to the letter: one user one connection. Every call to the database requires a connection. After the processing is done, the connection is released and available for the next user. Since we use AJAX to make our calls, we get lots of requests per second depending on the number of users. If we run out of database licenses, then those requests are queued up in our middleware called U2WebLink until a connection is available or they hit the configurable timeout parameter. We scale quite remarkable well. We have 70 user client running a call center with 10 Unidata licenses dedicated to the web. We have a public warehouse client with 4 licenses running 20 users internally and 20 customers externally. We have a 175 user running our CRM system using 2 licenses. The technology does not have any connection manager software written. It is a single license meant to used by .NET and Web applications. Regards, Doug www.u2logic.com -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Land Sent: Thursday, September 24, 2009 1:03 AM To: U2 Users List Subject: Re: [U2] Universe web connectivity On 24/09/2009 00:05, Doug dave...@hotmail.com wrote: We do not require you to use IBM connection pooling since we handle this through UOJ and our connection manager. It's worth noting that if you use any software that connection pools you are obliged to buy database connection pooling licences. It doesn't matter whether you use the connection pooling facilities they provide, from a legal and commercial perspective you must buy them, you can't use normal database licences. George Land APT Solutions Ltd ___ 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] Connection Pooling Statement
David, I think your problem may be that you are logging only when you get a request? If you were to have lines pre-logged-in, though the complexity of the middleware increases, you may find a corresponding increase in performance ... and with a little more effort you may also decide to NOT kill a used connection immediately, 'cause if you get another request in from the same client soon, shouldn't be an issue using the previously used connection (that is still open) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Friday, 25 September 2009 5:47 AM To: 'U2 Users List' Subject: Re: [U2] Connection Pooling Statement If you log off and on, it does satisfy the licensing - letter and intent... BUT usually the performance hit is so high that it FORCES you to connection pooling - or to have lots more seats! Both of which make IBM-Rocket happy. g I'm still wondering how they can get 175 users through 2 seats -- unless each user does 2 things a day!! My understanding was that you either had to have a seat for each 'logical' connection to a user, or sign off/sign on between each 'thing' - and the overhead for going off and on is INSANE in any way I've tried to make it work... So - I understand your point George -- I am in the same headspace! David W. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Land Sent: Thursday, September 24, 2009 2:32 PM To: U2 Users List Subject: Re: [U2] Connection Pooling Statement On 24/09/2009 16:45, Doug dave...@hotmail.com wrote: George, We do not do connection pooling or use multiplexing software. I'm sorry, I didn't mean to imply that you did. I was trying to make a general point that you need connection pooling licences if you connection pool however you do it. We scale quite remarkable well. We have 70 user client running a call center with 10 Unidata licenses dedicated to the web. We have a public warehouse client with 4 licenses running 20 users internally and 20 customers externally. We have a 175 user running our CRM system using 2 licenses. There is a general point here though, supporting 175 users on a 2 license system is exactly the situation IBM/Rocket are trying to address by forcing you to have connection pooling licences. Now don't misunderstand me, I'm not accusing you of breaking the letter of the license agreement, but I think it is breaking the intention of it. Quite what 'connection pooling' and 'multiplexing' really is can be debated, but essentially what they want is for you to pay more for databases licenses that support multiple users than you do that are tied to one user. And having a small number of database licenses supporting a large number of users is exactly what you are doing George ___ 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] Connection Pooling Statement
I don't believe IBM could have exceptions, ESPECIALLY in the USA, as my understanding is that monopoly and anti-trust laws click in. However, if my foggy memory serves me correctly, price of a Redback licence corresponded to the price of a connection pool licence, and I believe set the bar for pricing OF a connection pool licence! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Friday, 25 September 2009 8:40 AM To: U2 Users List Subject: Re: [U2] Connection Pooling Statement I'm missing something. We ran Redback without connection pooling. Is that an exception because it's a U2 product or were we in violation? Ross Ferris wrote: Doug, I fear that if you look at the terminology and description that IBM (Rocket may change, but somehow I doubt it) use to describe a connection pool, though you may like to think that your connection manager is different, I fear you may fall foul of their definition and if you look at your 175 user system running off 2 licences you can understand why (I assume that the 175 users also use other stuff, rather than everyone using NOTHING BUT your CRM) ___ 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] Connection Pooling Statement
Interestingly, one of the scenario's we ran past IBM back in April/March was the use of disk shares, where people could drop files from windows applications which would be picked up by a U2 phantom processed they characterised this as requiring a connection pool licence! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Glenn Batson Sent: Friday, 25 September 2009 8:43 AM To: U2 Users List Subject: Re: [U2] Connection Pooling Statement I RedBack you would be using WebShares which is basically like Connection Pools. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Thursday, September 24, 2009 3:40 PM To: U2 Users List Subject: Re: [U2] Connection Pooling Statement I'm missing something. We ran Redback without connection pooling. Is that an exception because it's a U2 product or were we in violation? Ross Ferris wrote: Doug, I fear that if you look at the terminology and description that IBM (Rocket may change, but somehow I doubt it) use to describe a connection pool, though you may like to think that your connection manager is different, I fear you may fall foul of their definition and if you look at your 175 user system running off 2 licences you can understand why (I assume that the 175 users also use other stuff, rather than everyone using NOTHING BUT your CRM) ___ 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] Problem with Multi-value market in general
Jim comes from the reality side of the fence! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Lance J. Andersen Sent: Saturday, 19 September 2009 7:30 AM To: U2 Users List Subject: Re: [U2] Problem with Multi-value market in general Anthony W. Youngman wrote: In message 25013-46...@sneakemail.com, Tony Gravagno 3xk547...@sneakemail.com writes I'm not sure why you're emphasizing OLD. The MV implementation in Caché supports many versions of Pick plus the Prime nuances of U2. :-) I believe one would find the level of thoroughness corresponds to the size and value of the prospect audience - in other words, Universe apps might migrate faster than any other. jBase followed the Prime philosophy INFORMATION is Pick done right. I *think* Jim came from Prime. And like I tried to do with MaVerick, Jim took the done right attitude. I'm not surprised he appears to have taken a lot from Prime. I do not recall Jim working as part of the Prime INFORMATION team (which I was part of) at Prime while I was there . I worked there from 1983-1993 and was one of the original PI vars, Standard Data Systems prior to joining Prime. Perhaps he was there before at Prime or Devcom. Clif was Jim part of the group at Devcom with John Drumheller? -Lance 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] Change is a coming! [not-secure]
No, but the process may be as complicated and straight forward as Rocket Surgery!!! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Hennessey, Mark F. Sent: Wednesday, 16 September 2009 4:55 AM To: victor.hender...@gmail.com; U2 Users List Subject: Re: [U2] Change is a coming! [not-secure] snip Huh, does this make me a Rocket Scientist? /snip I'll go out on a limb and guess No ;) ___ 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] GOOD NEWS From Susie
I have to agree the crack in the door that the IBM brand offered just closed with a THUD! Sure, the new owners may well drive better integration and take the U2 products to new heights . but this will come at the price of the street cred that the IBM name offered. May now be worth the trip in November to listen to Susie speak at the Raining Data event!! :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Mike Randall Sent: Wednesday, 16 September 2009 7:56 AM To: 'U2 Users List' Subject: Re: [U2] GOOD NEWS From Susie Hard to view this as a positive no matter what spin is put on it. Smacks of being a part of Mercedes and then belonging to Joe's garage... Marketing of U2 (if there is such a thing) just took a serious blow to the gut. Mike -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Results Sent: Tuesday, September 15, 2009 4:59 PM To: u2-users@listserver.u2ug.org Subject: [U2] GOOD NEWS From Susie All, I just got off the phone with Susie Seigesmund. She has assured me that her entire team has been invited to stay together, Rocket didn't just buy the software or the customer list or the channel, they are buying into the people who supported us all along. More news as I have it. Also, watch U2UG.org, as we will be updating teh front page several times in the next few days. - Charles Barouch ___ 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] Wintegrate Challenge
Write the data out as a HTML table -- format as you like, write to a file with .HTM option then open with excel -- lower tech, higher performance, greater control. May also want to check Nebula product that allows you to create XL files natively -- I haven't used, but have heard good reports Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Saturday, 12 September 2009 6:12 AM To: U2 Users List Subject: [U2] [UV] Wintegrate Challenge We are building a report that will generate its output in an Excel document. This process will be using wIntegrate's WIN.DDEPOKE to poke the data into defined columns and rows. What I would like to do, and I am not sure if it is possible, is to define the format of given cells at key times of the poke. So for example, one thing this report will show is a category with totals. When the category changes, I would like the format of those cells to be different that the other cells within the report. Using wIntegrate, is this possible ? As always, thank you very much for all input. Cheers, Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 bro...@pny.com - We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner P Before printing please think about your environmental responsibility 11/9/2009NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E- MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. 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. 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] Universe just quits
Real Indexing should win - compound key based on wo...@id, index on word and then traverse keys in Basic (or via a select) ... saves having to juggle your own key blocks for larger intersects/more popular words Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Thursday, 23 July 2009 1:44 AM To: 'U2 Users List' Subject: Re: [U2] Universe just quits Harold You might want to look at splitting out some of those index records, e.g. where you have 10,000 fields in an index for CRIME, split this into CRIME, CRIME-1, CRIME-2 etc. with a maximum number of entries per index. Otherwise you are not going to get efficient storage at those sizes: if they are in a directory file these can be slow scanning and clashing on the lock table, and of course in a hashed file they will be in out of line overflow - again, slowing access. You can also adopt a scheme where, for example, the first entry in the base record holds the last sequence number of the series, so you don't have to read the intermediate ones when appending.. I realize this will mean changing the search routines, but it might help in the long run. I would also definitely echo what the others have said about sequentially accessing the source descriptions. Brian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, July 21, 2009 4:54 PM To: U2 Users List Subject: Re: [U2] Universe just quits Barry: Thanks for resonding. The main activity is running thru text files (narratives), identifying the next word then updating a file (DEXNAR) used to cross-reference all the words. For example, in record ABC123 in the narrative field the next identified word is DECOMPOSING. I read the record DECOMPOSING from the DEXNAR file. The record DECOMPOSING has 10 lines in it, because 10 other prior narratives had the word DECOMPOSING. The program seeks the current record key (ABC123) in the fields using the LOCATE command. If not found, the key ABC123 is appended to the end of the DECOMPOSING record and DECOMPOSING it is written out, now with 11 fields. Some of the records in DEXNAR get long as they are for fairly common words, like ALIAS. (The most common words I do not bother to cross-reference, of course, like the word THE). Thus, the LOCATE is looking thru an ever increasing number of fields as we go along. Some records currently have over 11000 fields. Is that the problem? Maybe the sytem tries to 'fit' the next very long record in memory to do the LOCATE and it overflows something? The dropping out, however, occurs normally after updating 25000+ records. Shorter runs seem to 'hold out'. What might be building up in memory space? These are also overnight runs, typically, so there are fewer users to contend with making it unlikely that it's exceeded limits for all users, I would think. The point of the cross-reference file is to allow users to quickly search thru all the 700,000 available (crime) narratives for the ones that match a set of entered search words. Searching that many narratives using brute force would probably take 5+ minutes for each search on our system, which would really stifle the crime analysts. Thanks- Harold -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Tuesday, July 21, 2009 1:03 PM To: U2 Users List Subject: Re: [U2] Universe just quits Can you elaborate a little on these tasks Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 bro...@pny.com - We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner P Before printing please think about your environmental responsibility -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Tuesday, July 21, 2009 2:41 PM To: u2-users@listserver.u2ug.org Subject: [U2] Universe just quits I am having a very disconcerting problem. A long job I have been running, processing a large text file and then loading a Universe file, is simply quitting sometimes. No error message of any kind, Universe just quits, the session drops into unix. We have Universe 10.2 running over HPux 11.1. I have reduced the job to smaller pieces to get thru it and indicate data values so that I restart at about the dropout point. So I'll be able to finish but I would like to understand what's going on. Anybody seen this kind of thing before? Is there a Universe parameter I should
Re: [U2] Performance reports on 4 Terabyte files vs Distributed Files
G'day Baker, Just thinking in the sandbox, with no 4Tb databases to be found, BUT (as usual) there may be many aspects to the answer My initial thoughts would be that avoiding running a subroutine to determine part file for EVERY write and non-sequential READ would represent a saving per transaction. I would assume that such a large file is probably (should be?) well indexed, so there are likely to be some gains on that front. HOWEVER, if the file is primarily used for reporting, and the parts have been crafted with this in mind, I could see there may be situations were being able to cheat and deal directly with a part file could be advantageous. However, my gut feel (with sand grit in my teeth) is that the larger 64bit file would win out in most circumstances, but like I said, I don't have a play thing that large at hand :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: Thursday, 23 July 2009 2:01 AM To: 'U2 Users List' Subject: [U2] Performance reports on 4 Terabyte files vs Distributed Files Does anyone have any real life examples of performance gains from converting your large file to 64 bit files? Does anyone have a performance comparison of 64 bit files vs. distributed files. I wonder if a 4 terabyte file responds better/faster than a distributed/part file? SELECTs, WRITES, other access. UV 10.2 - I guess UD has the same? Thanks, -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ 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] Program Comments/Documentation/Notes/Revision History
-Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Tony G Sent: Sunday, 28 June 2009 6:26 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Program Comments/Documentation/Notes/Revision History But then there is the next step. There is a major difference between folding code exclusively based on syntactical stuctures and folding based on logical/functional components. In BASIC we can have several labelled, internal subroutines, and UV Functions, that are a part of a functional set. But, we can't put those into a block to get them out of our way while we're working on other sections. At a higher level though these subroutines would (should) probably be called in sequence from (yet another) internal subroutine corresponding to the higher level functional unit ... 'least that is the way I'd tackle it (not strictly true, as I tend to use our snippet technology inside Visage, so by default I already have code compressed to a single line ... double click on a snippet or external subroutine name you can edit/examine that. Not the same I know, but it works for me :-) Err, except for our (n)ever evolving Pick BASIC. As you pointed out, the functionality you are talking about becomes a function/feature of the IDE or editing tool you are using, rather than Pick Basic itself -- when I call up Javascript in Notepad I get to see it all, but the same code viewed from another can be collapsed nicely. Ross Ferris Stamina Software Visage Better by Design! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Program Comments/Documentation/Notes/Revision History
Tony, Whilst I appreciate the structural tags I'd suggest that they are not needed. It doesn't take too much thought to recognise the self-bounding regions Label: -- return For -- next If -- else -- end Loop -- repeat Begin case -- case -- end case There are some funny possibilities with read/locked|then|else Whilst I appreciate the fine grained control your suggestion provides, my faith in programmers generally following this standard is low, and providing people haven't employed a single, linear top-down approach to their programming, I think most (all) of the collapsible regions could be derived directly from the code with minimal effort Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Tony G Sent: Saturday, 27 June 2009 8:27 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Program Comments/Documentation/Notes/Revision History From: David A. Green I've always commented my program at the beginning, but some programs have many changes and when we have 300+ lines of comments it gets a little tedious to deal with embedded in the source code. I'm think of placing them in an external file and then doing a $INSERT in the source code in order to tie them together. How do you handle the long comments? I've often thought of this as being a problem with both the language and the editors that we commonly use. Typical MV editors show all code. There is no provision for folding content or outlining. For example, in C# we can do this: #region Initialization // lots of comment lines here // variable definitions, code, etc #endregion In Visual Studio that collapses to a single line: +Initialization We can click the plus sign to open it up and see the entire section. Other editors support this feature for different languages. Code can be nested: #region Main Section #region Define Variables // definitions here #endregion vars #region Major Function 1 // code here #endregion functions #endregion main Again, that collapses to something like this: #region Main Section + Define Variables + Major Function 1 + Major Function 2 #endregion main Or collapses entirely to: + Main Section But with MV BASIC the language doesn't support this unless we use a pre-processor, and even then we don't have editors that recognize the constructs. The best we can do is to use something like this: *!+ This starts a region * code here *!- This ends the region But then we need an editor to support it. And that brings me to... a minor rant I was writing a new MV Editor to support this and many other features highly desirable to MV developers. But as with many projects where people would inevitably demand a free solution I decided to put this project on the shelf indefinitely. It's just not worth it to try to improve our lot here. Since people are so fond of open source freeware I'll suggest that the source code is available for people to enhance to recognize code as defined above. That's the spirit of open source - we're supposed to give as much as take. If no one wants to enhance one of the fine FOSS utilities out there, then it seems we'll simply never have the functionality. People all too often confuse free=liberty with free=beer. They want the software to be free-of-charge but we rarely see people publishing MV-specific enhancements to open source code as a contribution to the community. It's this condition that causes us to continually lose sites to the mainstream world as people wonder why our development practices are so primitive. C'est la vie. / Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.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] Simple Export to Excel
Careful Tony, the AD police will be after you :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Tony G Sent: Tuesday, 23 June 2009 7:22 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Simple Export to Excel As Robert describes, double quotes are used in freeware I've published called ExcelExport, which exports full workbooks and individual worksheets to CSV. You can get the software from our freeware page and see the TXT Readme for details. no.spam.pleaseNebula-rnd.com/freeware/ Rather than making another post, I'll mention here that people are using our NebulaXLite from SB+, and it even displays progress info through SBClient as it works through large reports. And for people who say use XML, well, that's exactly what NebulaXLite does. Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com Visit PickWiki.com! Contribute! From: Robert Porter Double-quotes can be embedded within the quoted field by escaping them. Just double up the double-quote character. So the text: This is my description field. Would go be exported as: This is my description field. ___ 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] POS System
G'day Norm, We have a GUI POS and/or Green Screen system that may fit the bill (http://www.stamina.com.au/R5/PointOfSale.htm), but of course POS can cross multiple boundaries (Stock, General Ledger, Debtors etc), so I fear there are more aspects of what you are looking for that you need to share or discuss (eg: do online sales Ecommerce functionality fit into your definition of POS? Do you need to issue/manage gift vouchers? How about Frequent Buyer or Loyalty Club processing? Staggered deliveries for building trade products for customer selections ?) We have clients that operate across a reasonably broad array of product and industry sectors - happy to discuss options your needs offline/direct Ross Ferris Stamina Software Visage Better by Design! From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Norman Bauer Sent: Wednesday, 10 June 2009 10:32 PM To: U2 Users List Subject: [U2] POS System Does anyone know of a point-of-sale system that uses UniVerse? Thanks, Norm ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Web services
Not using WebDE, but 2 things we have done in the past is simple IP checking (only allowing access from specific/authorized IP addresses), and also (AND or OR) using locking access to specific machines using a hash of some machine attributes (typically Mac ID, Disk ID such -- but we have the advantage of having an ActiveX that grabs encodes this for us) Whilst not quite the same as the money market, we have clients that operate with other liquid assets (Beer, Wine Spirits) and some of the information is extremely sensitive in the market, so needed to ensure that if an employee left, no data went with them or was accessible remotely! Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Friday, 5 June 2009 12:40 AM To: U2 Users List Subject: Re: [U2] Web services I am trying to work out how to identify who the person is that is consuming a web service using the U2 web services developer. I know techniques to do it in .Net. How do ensure that a person is authorized to consume that service. What approaches have others taken to tackle this. Regards David Jordan ___ 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] MV based Financials ready for Intl business
Hi Baker! You might want to check out our Visage R5 financials. Will give you a nice GUI (though we still sell R5 Classic with a CUI if you would prefer) with full multi-currency capabilities across all modules - if your needs extend beyond base accounting, then we just a few other modules available (including USA version of payroll :-) Assume you are actually running everything out of USA, but if this were to change then the multi-lingual capabilities of Visage may be use. Please contact me directly once you have exhausted meager details at http://www.stamina.com.au/R5/R5System.htm with any questions ... Both versions (CUI Visage GUI) also sport Visage.BIT cubes for extensive reporting and data exploration capabilities above beyond what you would normally expect, and of course this could then also be turned to your sales/inventory/purchasing files as an added bonus :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: Saturday, 25 April 2009 8:33 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] MV based Financials ready for Intl business Hey, I'm looking for names of some multi-value based Financials. They must be ready for International business. Hopefully something that would interface nicely to a highly customized order fulfillment system. What should it contain? GL, AP, AR, be able to do it all in multiple currencies and use bank accounts in various countries, based in other currencies. We are in the distribution business and most facets of our custom package are up to the task of international business. Our financial package is lagging and is difficult to maintain so we're maybe reaching the tipping point where's its better for business to convert to something more up to date. You can respond off list if you like. baker.hug...@mouser.com Thanks in advance, -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. --- 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] CallHTTP vs cURL...
If only 5-6 times a day, why not just kill logoff the existing phantom, immediately after spawning a replacement immediately after the CallHTTP -- I assume new process would initialize what it needs to, and start over, so you would have an iPhantom issue for a second or 2 at most. The other more interesting grab for money is the question of What constitutes a connection pool, as IBM have been chasing this chestnut here in Australia recently. Situations we haven't received an un-ambiguous answer for to date include polling files deposited by, say, an external POS register, inter-acting with time clocks or even processing emails attachments. Until recently I thought these kind of interactions were relatively innocuous AOK, but it now a murky mess Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of David Wolverton Sent: Saturday, 18 April 2009 3:01 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] CallHTTP vs cURL... It's situational, so it would be tough to execute via 'cron' - it has to execute or at least be 'triggered' from 'within' the phantom with data the phantom provides -- I guess I could write a Scheduled process that runs every 6 seconds to see if there is a 'file to execute' - but that seems to be even more overhead -- I'm just trying to figure out how to avoid turning the phantom into an iPhantom... And losing a valuable 'real' seat in the process! -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Friday, April 17, 2009 11:44 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] CallHTTP vs cURL... How about running a shell script from a cron job that retrieves whatever via cURL. --- 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] universe sockets
Why not just provide this via a browser? This is what we did when our clients turned up the day after they had lined up until midnight to buy their latest wonder toy at midnight. They were here @ 10am, and had a working prototype by midday and of course this application will also work on, say, a HTC running Windows Mobile ... anything with a browser Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of doug chanco Sent: Tuesday, 14 April 2009 11:56 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] universe sockets I hope so, because I would like to develop an in house iphone app that our users can use to query our database for prices/quantity available and sadly Apple only allows socket access to the closed iphone OS. If anyone has a pick server socket solution they would like to share I'd appriciate it (answering requests and spawning a program to handle each incoming request) otherwise I may go the route of moving the socket server to the OS (using init.d to handle incoming requests and to spawn a program to handle each request). But I think I am getting close (to getting a working non blocking pick socket server) and if I get it to work I'll post what I have to the web site. dougc -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org] On Behalf Of phil walker Sent: Monday, April 13, 2009 5:36 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] universe sockets Maybe someone could put an example of this on the U2ug website, or Brian could include it in his training materials if he has not already so that people have an idea how to accomplish this ;-). -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Tuesday, 14 April 2009 9:30 a.m. To: u2-users@listserver.u2ug.org Subject: RE: [U2] universe sockets We want to explore other connection options that are not tied to uniobjects so that if we decide to switch from universe to say database x we can do so easier. My only comment on this is don't go writing socket code just for this - just write a wrapper round the uniobjects code - so your code does not open a uniobjects connection and do read/write/select/run programs, it uses a class that you have written that in turn does this - pass a param to the class called DB and set it to uv - then when you want to switch to some other DB add the connectivity code to your class and away you go - basically you are building a DAL (Data access layer) upon which your BLL (business logic layer) works - the bll does not care what the DB is or how it communicates that is the job of your DAL. Rgds Symeon. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] DATE.FORMAT illegal when a transaction is active
On Apr 7, 3:09 pm, ken.f...@firstmac.com.au wrote: I get the error in the subject line when updating a file that has an associated file trigger. The file trigger subroutine does what it should still. There is no reference to 'DATE.FORMAT' in the trigger subroutine or anything called by it explicitly. Any ideas what could be causing this? I am using Universe 10.2 under AIX 5.2. Regards, Ken Ford. I picked this up from CDP, and thought Ken may have more luck in this forum Ross Ferris Stamina Software Visage Better by Design! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] IDE ADADADAD
AD ALERT In case you are in any doubt, I'm going to talk about VISAGE/AD ALERT Hi Rudy, You should consider our Visage product (http://www.stamina.com.au/Visage/visage.htm) if you are seeking an enterprise class IDE that is fully aware of your UV environment, and has been designed from the ground up to leverage the strengths of multi-value, AND your existing skill set, you will be hard pressed to find a better candidate. In terms of simple code editing you get a syntax highlighting editor with auto-completion, even for your own subroutine libraries. As well as normal code, Visage also includes our Snippet Technology, which allows you to build your own extensible macro notation to drastically reduce the keystrokes required to incorporate custom code that conforms to your site standards. In terms of gui-izing and screen/form design, the Visage.Designer lets you simply drag drop dictionary (and non-data bound) elements onto a blank canvas and attach code as necessary (which can also be inherited from our extended dictionaries) which can execute business rules on either the UV or client end of the equation. You can also easily construct your own re-usable UI components that can be dropped on forms to give a consistent look feel, and avoid replicated effort, and forms can also be re-used across multiple processes Simple enquiry maintenance screens typically require no code, and Visage screens can operate alongside green screen counterparts without having to change ANY code (important if you use READU locks currently), so you can migrate at your own pace, rather than having to adopt a BIG BANG approach to migration You can also design printer forms with the same drag drop interface to your dictionaries, and reports/forms can be previewed onscreen, delivered via email, fax, sent to a file -- heck, if you want you can even send them to an actual printer! Importantly, you can also generate Visage.ReportServer documents from your green screen applications via a simple EXECUTE statement! If part of your (re-)development includes facilities like Business Intelligence/Data Warehousing, or even if you want to deploy BI facilities with your current Green Screen apps NOW, then you should check out Visage.BIT The Visage suite of products is an integrated toolset that provides all of the features required to quickly easily deliver a 21st Century solution that leverages your existing business assets. You can deploy just those facilities you need today, and add the extra pieces of the puzzle as your needs dictate in the future. It may also be comforting for you to know that our largest VAR now has over 16,000 Visage licenses issued, and our largest single site tips in at 1,000 users If you would like more details, contact Drew Conboy Drexel Management Services, Inc. Suite 301 1010 West Chester Pike Havertown, Pa. 19083 Voice 610.924.9290 * Fax 610.924.9293 Email dcon...@drexelmgt.com Drexel also have people on the west coast :-) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Tony G SNIP I have lots of answers, so the next post will probably be an ad, --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] validate active directory username password from within unidata?
What platform is UD running on . I assume *nix? Do you need to do this, or is it enough that the host OS has validated logon credentials against AD? Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Bruce McAdoo Sent: Wednesday, 18 March 2009 11:44 AM To: u2-users@listserver.u2ug.org Subject: [U2] validate active directory username password from within unidata? Any ideas how I might be able to validate active directory username password from within unidata? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] HP, Cron, Como, Execute, Capturing . Not
Have you changed the code yet to avoid problem? You haven't mentioned
version of UV -- if not current, check later GTARs to see if issue
identified/resolved.
Get the customer going with a redirection/read ... obviously (?) new
code, but an
ls -l /tmp/unique_filename
will work across ANY *nix platform -- assume cron is running as same
user/permissions as when you fire from TCL
Ross Ferris
Stamina Software
Visage Better by Design!
-Original Message-
From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-
us...@listserver.u2ug.org] On Behalf Of Tony G
Sent: Tuesday, 24 February 2009 8:45 AM
To: u2-users@listserver.u2ug.org
Subject: RE: [U2] [UV] HP, Cron, Como, Execute, Capturing . Not
Thanks for responses so far.
Scott - this code is also doing 'ls', and the output gets
captured in COMO as you have seen, but it doesn't continue into
the Capturing var. At least we can confirm COMO is supposed to
see the output (for better or worse) but not at the expense of
BASIC not seeing it.
I'm wondering if this is an OS-specific issue where UV/HP is
capturing in COMO but not in Capturing, or maybe this is only
occurring when run through Cron. They could be doing something
like this too:
echo PHANTOM RUNREPORT | uv
...with the phantom being the platform-specific culprit.
I'll get the details and report back, then maybe someone with the
same platform here can check this before we file a bug report.
Tony Gravagno
Nebula Research and Development
TG@ remove.pleaseNebula-RnD.com
Email now working properly
Don't forget Pickwiki.com!
From: Scott Ballinger
I do this all the time on UV 10.1.4 on RH AS 3. I have
not seen a conflict with COMO and EXECUTE CAPTURING,
except that the COMO records the results of the
execute as well as the CAPTURING variable. E.g.
EXECUTE SH -c 'ls' CAPTURING DIR.LIST
Not only does DIR.LIST contain all the files in the
directory, but the COMO records them as well, making
for very verbose COMO files!
Note that I have not tried the combination of cron +
COMO + EXECUTE CAPTURING {+ PHANTOM?} so perhaps there
is something going on there, but I do use cron +
EXECUTE CAPTURING in many places without problems.
---
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: Internal Visage
Beau, I'm trying to hook into the Virtual Server Manager @ NILWA as I've just had to restart the Linux virtual ` trying to logon as administrator with our usual invisible password with no joy. Created a STAMINA user that I assigned to administrator group ... same story Has anything changed? Is there another user/password I need to be using to get access to this console. Ross Ferris Stamina Software Visage Better by Design! From: Sally Clark [mailto:sallycl...@nilwa.com.au] Sent: Tuesday, 20 January 2009 8:42 AM To: Ryan Hafey; Ross Ferris Cc: NILWA Subject: Internal Visage Hi Guys, We have been experiencing some slow processing speeds this week. No errors till this morning just slow moving. This morning when I opened the BIT viewer to list all cubes I got a pick core dump error (no screen print, I closed out too quick). Could this be related to our slow processing speeds? Cheers Sally Clark IT/HUB Manager Accounts Receivable National Independent Liquor Wholesalers Association Pty Limited Phone: 02 4929 5866 Fax: 02 4929 3622 Mobile: 0438 48 77 99 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Internal Visage
Oops -- obviously I didn't mean to do that. (NOTE TO SELF: check email address after outlook auto-completes) Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2- us...@listserver.u2ug.org] On Behalf Of Ross Ferris Sent: Tuesday, 20 January 2009 10:17 AM To: Beau Murray Cc: NILWA; Sally Clark; u2-users@listserver.u2ug.org Subject: [U2] RE: Internal Visage Beau, I'm trying to hook into the Virtual Server Manager @ NILWA as I've just had to restart the Linux virtual ` trying to logon as administrator with our usual invisible password with no joy. Created a STAMINA user that I assigned to administrator group ... same story Has anything changed? Is there another user/password I need to be using to get access to this console. Ross Ferris Stamina Software Visage Better by Design! From: Sally Clark [mailto:sallycl...@nilwa.com.au] Sent: Tuesday, 20 January 2009 8:42 AM To: Ryan Hafey; Ross Ferris Cc: NILWA Subject: Internal Visage Hi Guys, We have been experiencing some slow processing speeds this week. No errors till this morning just slow moving. This morning when I opened the BIT viewer to list all cubes I got a pick core dump error (no screen print, I closed out too quick). Could this be related to our slow processing speeds? Cheers Sally Clark IT/HUB Manager Accounts Receivable National Independent Liquor Wholesalers Association Pty Limited Phone: 02 4929 5866 Fax: 02 4929 3622 Mobile: 0438 48 77 99 --- 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] Pentaho/ETL Toolsad?
Received this in the mail, and as it relates to the product in question (Pentaho), thought it may be relevant. The Webinar is complementary, so if you can afford the time, price is right! Event Title: Database Trends and Applications Survey Results: The Freshest BI Data from the Journal of Enterprise Data Management Date: Thursday, November 20, 2008 Time: 1:00 PM Eastern 10:00 AM Pacific Duration: 1 Hour Featured Speakers: Joseph McKendrick Lead Analyst for Trend Studies Unisphere Research Lance Walter Vice President of Marketing Pentaho -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Butera Sent: Friday, November 14, 2008 9:45 PM To: u2-users@listserver.u2ug.org Subject: [U2] Pentaho/ETL Tools We're in the midst of creating a data warehouse from our UniData databases and exploring the possibility of using Pentaho. Their ETL tool does have an entry for Universe (not Unidata), but the connection methods are JDBC, ODBC or JNDI. We don't want to create an SQL-view of Unidata merely for ETL, we'd prefer to find an ETL tool that can natively talk with Unidata. Has anyone worked with Pentaho? Any thoughts? Does anyone have ETL tools in mind that natively talk to Unidata? Jeff Butera, Ph.D. Administrative Systems Hampshire College [EMAIL PROTECTED] 413-559-5556 But Dad, I'm not listening to you. Catherine Butera --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ __ Information from ESET NOD32 Antivirus, version of virus signature database 3614 (20081114) __ The message was checked by ESET NOD32 Antivirus. http://www.eset.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] call mysub vs. call @mysub
Just a quick (dumb?) question that will save me spending 5 minutes writing a little test program (instead I'll spending 15 mins reading responses BARGAIN!!) - and may also be useful for other listeners ... In D3 for subroutines that are called often (either within a program, or a system if you use common) then a construct like mysub = mysub ... ... for I = 1 to lots call @mysub ... next I turns out to be marginally faster than call mysub because the subroutine name is resolved via the MD once on the first call, sub subsequent indirect calls are faster as they avoid the MD/VOC lookup Does this hold true across U2? And/or do you get same sort of benefit from global catalog? Ross Ferris Stamina Software Visage Better by Design! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE:french characters
Would this require NLS? Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Irina Lissok Sent: Saturday, 23 August 2008 1:59 AM To: u2-users@listserver.u2ug.org Subject: [U2] RE:french characters We have a problem with FRENCH characters. Using READSEQ to read the record from the file which contains FRENCH characters. It reads in but French characters has been substituted with blanks or with legitimate English characters. When we are trying to load this data into xml file with WRITEBLK it puts initial French characters in it and xml file can not be opened. Our approach was to read data in and represent it in hex to be able to recognize French characters, but it won't work because as a result from READSEQ we've already had some kind of interpretation, not initial data. Is anyone have met the same problem and knows how to deal with it. Irina Lissok --- 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
As an observer from across the water, and given the litigious nature I perceive pervading the US, I just wonder what will happen to this initiative the first time an employee is hit injured whilst travelling to work? If the community had bike lanes and/or trails that were JUST for bikes, it would be safer -- unless of course one of the bike riders runs over an innocent pedestrian I'm probably just FAR too cynical :-( Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Wednesday, 30 July 2008 3:25 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Green Software - Green Business Don Verhagen made the point that we do what comes naturally (conveniently) and sometimes that's green and sometimes it's not. For me, I admit, that's true. My green efforts have stemmed from what is convenient and less expensive, I admit it. I just think that it's lucky we are in an industry / business where being greener and doing what is better and cheaper all line up! My sister's company issued a green offer to the employees that it would pay for a bicycle for any employee that would ride it to work. So my sister jumped on it, got a great new bicycle and rides it to work every day and is the world's biggest enthusiast now. She's lost weight and says she feels 20 years younger. It's a huge triple win. I thought I might hear a few stories like my sister's company bicycle. I guess these kinds of initiatives are still rare, but expect they will become more common -- both for the marketing appeal of being able to claim greenness and because of the price of gas. Susan --- 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] terminal emulator
We have had clients use accuterm with citrix with no problems I can recall Ross Ferris Stamina Software Visage Better by Design! -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Bob Witney Sent: Friday, 27 June 2008 9:09 PM To: u2-users@listserver.u2ug.org Cc: Andy Stenning Subject: [U2] terminal emulator We are using PowerTerm Lite as our terminal emulator Works fine from a PC but sadly won't work through Citrix Is anyone using a terminal emulator via Citrix (we have MAC's that need to come across that way) Thanks Bob Witney IT Senior Explore Worldwide Nelson House 55 Victoria Road Farnborough Hants GU14 7PA Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. _ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ --- u2-users mailing list 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/
