Re: [U2] FAST (File Analysis and Sizing Tool)

2011-10-06 Thread Ross Ferris
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 structur

Re: [U2] Question about accessing external SQL database

2011-10-06 Thread Jason Lin
On 10/6/2011 1:51 PM, Tony Gravagno wrote: I agree with suggestions to do this with tiers: Universe<> webservice<> localWin<> remote ODBC I think that is the best approach for me as well since I already how to create web services in .Net Framework environment to query access SQL databa

Re: [U2] MV based Financial GL packages sought

2011-10-06 Thread Frank Eperjesi
Hopefully I did not send this out twice. I do not think my last one went out properly because I did a reply from someone else.. Hello Please check out http://www.baipro.com http://www.BAI-5000.com http://www.metal-pro.com an

Re: [U2] MV based Financial GL packages sought

2011-10-06 Thread Frank Eperjesi
Hello check out http://www.baipro.com http://www.BAI-5000.com http://www.metal-pro.com and http://www.paper-pro.net Besides full integrated MV financials we have general, metal specific and pa

Re: [U2] FAST (File Analysis and Sizing Tool) {Unclassified}

2011-10-06 Thread HENDERSON MIKE, MR
David, I think this is called a "Histogram Method" in the literature. You can obviously make the 'buckets' as big or as small as you like depending on how much memory you want to use - you could even have 1-byte buckets which would allow you to calculate the actual median rather than an approximat

Re: [U2] FAST (File Analysis and Sizing Tool)

2011-10-06 Thread Doug Averch
Jeff: Bullet point 6 on my XLr8Resizer response, using the native tools gives us a lot of information about each file. We still do other analysis based on the file particulars as well as the user can input certain variables to adjust the calculation. Or for those of us who don't like either of th

Re: [U2] Question about accessing external SQL database

2011-10-06 Thread Tony Gravagno
> From: Jason Lin > I am exploring a good way to access data on an external SQL database > from our Universe (10.2.7) environment running on HP-UX (11.23). I agree with suggestions to do this with tiers: Universe <> webservice <> localWin <> remote ODBC This can be done very quickly and it's

Re: [U2] MV based Financial GL packages sought

2011-10-06 Thread Bill Brutzman
Consider... www.GRMS.com ...and I have a bunch of code to augment this. --Bill -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Baker Hughes Sent: Thursday, October 06, 2011 1:51 PM To: U2 Users Lis

Re: [U2] Changing TCL prompt?

2011-10-06 Thread GCanedy
Thanks for all the input. I took the examples and wrote a small piece of code with the three variables. Seems to work just fine. Thanks again Gary P. Canedy Senior Database Analyst P: 617.757.6775 F: 617.428.9803 gcan...@coverys.com (Embedded image moved to file: pic14309.jpg) 101 Arch Street

Re: [U2] FAST (File Analysis and Sizing Tool)

2011-10-06 Thread David Wolverton
What about this... Could you just store a MultiValue of the 'approx size' of each record? Then you would 'add one' to the correct MV as you process the record counts. At the end of the run, you'd have a list where you could essentially start a loop to 'work to the center' So you'd have a MV of b

[U2] MV based Financial GL packages sought

2011-10-06 Thread Baker Hughes
Howdy, I am helping someone come up with a list of multi-value based Financial/General Ledger packages. It would be very appreciated if any of you could send the names, even url's, my way. If giving a pitch for your own package I suppose the customary [ad] should be included in the subject li

Re: [U2] FAST (File Analysis and Sizing Tool)

2011-10-06 Thread Jeff Fitzgerald
Thanks all for weighing in on FAST and file sizing. Charles, I AM listening and I hear your interesting suggestions about trending. Most of the improvements to FAST over the years have come directly from user experiences and requests. No promises but we will brainstorm this with a view to seeing

Re: [U2] Question about accessing external SQL database

2011-10-06 Thread George Gallen
I use a combination of the linux's mysql client to access remote/local mysql databases and have it save the output in a /tmp file Then read it from Universe from the /tmp file - convert the Char(9) -> char(253) and it's in a dynamic array <1>=headers, <2+>=data rows. No extra expenses, no

Re: [U2] Question about accessing external SQL database

2011-10-06 Thread Holt, Jake
I created a simple .net app awhile ago to handle the connection so I could just pass a sql statement to it plus the connection details. I ended up just creating a voc pointer to a folder and I write the response to a file and read it in UniVerse. I am a little interested though in your suggestion

Re: [U2] FAST (File Analysis and Sizing Tool)

2011-10-06 Thread Doug Averch
I think that is a wonderful idea, Charles. I will be adding trending analysis to our next major release XLr8Resizer. It will be graphical using the built in report writer called BIRT that is a Eclipse plug-in. Regards, Doug www.u2logic.com On Thu, Oct 6, 2011 at 7:29 AM, Charles Stevenson wro

Re: [U2] Question about accessing external SQL database [AD]

2011-10-06 Thread Robert Houben
Two points: First, we have a product that does this for you. You can see it here: http://www.fwic.net/Products/MultiValueProducts/FusionWaremvLynxConnectAPI.aspx It uses Universe's built-in HTTP GET/POST capability to call a local web services layer that in turn uses the SQL Server JDBC driver

Re: [U2] FAST (File Analysis and Sizing Tool)

2011-10-06 Thread Charles Stevenson
My experience is a couple years old. FAST is a solid tool. Shoes for the cobbler's children. Automates IT. What a concept. But I added my own history component to FAST so I could see file trends over time. This trending history helped me take a system that was always crying for more resize

Re: [U2] FAST (File Analysis and Sizing Tool)

2011-10-06 Thread Wols Lists
On 05/10/11 23:03, Jeff Fitzgerald wrote: > If Eric or anyone else has specific questions about FAST we will be happy to > answer them, either here if the moderators think that is appropriate or via > private email. We won't get into mudslinging or trying to tear down any > other product or person

Re: [U2] Question about accessing external SQL database

2011-10-06 Thread Symeon Breen
The bridge is required because there is no ms sql odbc driver for linux. An alternative would be to use an install of UV on a windows machine to do the actual odbc interaction, it would just use the standard ms odbc driver. This in turn could communicate somehow to your main HP uv install the requi