Re: UV Crash on W2K3

2004-04-16 Thread FFT2001
In a message dated 4/16/2004 3:38:16 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: > 1.is this a problem with PROCS - does anyone else run a UniVerse system > on NT which relies on PROCS to launch several layers of programs? Sara can you explain this more? Perhaps with an example of e

RE: Database decoupling (Was: Future of U2)

2004-04-16 Thread Dawn M. Wolthuis
I wouldn't consider using 1NF data for new web services efforts if you don't have to -- why to mess around with mapping to and from flat tables? U2 is still old technology but in some ways it is closer to new technology than the brittle RDBMS solutions that are fading (maybe not fast, but SQL is n

Re: PI Open is going away

2004-04-16 Thread Bruce Nichol
At 23:18 16/04/04, you wrote: > Funny that... I was only thinking the other day that I should throw > out my ICL 1900 COBOL and PLAN Manuals!!! :-) Don;t start me on that nostalgia! I was an operating system developer with ICL all those years ago. Ah! Another Leo, eh?? Martin Phillips Ladybridg

Re: PI Open is going away

2004-04-16 Thread Bruce Nichol
Goo'day, Martin, At 18:53 16/04/04, you wrote: I was one of the two technical managers for the development of PI/open. It's always sad watching a product that you worked on be put into retirement. Perhaps I can now throw out my collection of PI/open manuals. And stop telling QM users "That's how

RE: Crystal Reports

2004-04-16 Thread djordan
Take the Lead If they have SQL Server already, build a mini datawarehouse that you populate Daily, and then set up the new Report Services of SQL Server which is a free add on to SQL Server 2000. In somes ways it has some better features than Crystal reports. It gives your system a fresh face f

Performance Degraded running u10.0.0 in Aix 5.2 ML 2

2004-04-16 Thread Sara Burns
We upgraded UniVerse 10.0.11 from AIX 4.3.3 to AIX 5.2 last October. We also run Oracle and Vantive on the same box. One thing we have found is that we need to have at least twice the amount of Paging Space as real memory. If the free Paging Space gets down to zero the machine dies a horrible de

RE: UV Crash on W2K3

2004-04-16 Thread Sara Burns
This is our first attempt at running our application on a Windows platform. Previously we have run on UniData on Sequent then converted to UniVerse on Sequent. Currently running UniVerse on AIX 5.2. The conversion from Sequent to AIX required the Little / Big Endian swap and going back to Intel r

RE: Crystal Reports

2004-04-16 Thread Tony Gravagno
Mark, it's interesting to see this project unfold, please do keep us up on events there. (Ready for some acronym soup?) Crystal Reports is heavily tied to .NET these days. Microsoft has selected CR for integration with Great Plains, so there is a high level of commitment to the CR/GP/.NET links.

RE: Crystal Reports

2004-04-16 Thread alfkec
We spent a fair bit of time building our schema so that the data appears to be in 1nf for Crystal to understand it. We've made some reports out of it that are pretty impressive and would have required a number of basic routines and some "work" files to create. They will be able to get the reports

RE: Crystal Reports

2004-04-16 Thread Mike Randall
Crystal is indeed a very fine product. It is a banded report writer with a multitude of programmability. Multivalued data is indeed a pain in the neck. Normalize the data 1st and you'll find Crystal a joy to use with output, features and polish that MV can't come close to. The 'problems' that

RE: UV to Text Conversion Standard?

2004-04-16 Thread alfkec
I've done lots of tables in UniData with VM levels of data. We only have a couple of files that have SVM level data - a co-worker of mine set at least one up that was working with Crystal reports. For the multi-values it simply keeps the information that it needs to access it as part of the primar

Re: PI Open is going away

2004-04-16 Thread Randy Styka
>how many people on the list are still using PI Open. Anyone care to >sound off? We have two customers on PI/Open, both on EXL325 boxes. Both are migrating away and will be off within a year (except that they both told me that they'd be off each of the last three years). Randy +

Crystal Reports

2004-04-16 Thread Mark Johnson
One of my clients wants to connect Crystal Reports to their UD database to apparently give greater access to the data that they sometimes deem as hidden and only accessable through me. This client converted to Great Plains 6 weeks ago (SQL based) and their CR experts were struggling with duplic

Re: PI Open is going away

2004-04-16 Thread Lance J. Andersen
Like when PI 5.4 was supposed to come out with Relational features and then we backed them out of the release? Results wrote: PI/Open-ers, I'd like to write a 'memorial' article for Database Trends acknowledging the PI and Prime contributions to the community as a whole. Would a few of yo

Re: PI Open is going away

2004-04-16 Thread Results
PI/Open-ers, I'd like to write a 'memorial' article for Database Trends acknowledging the PI and Prime contributions to the community as a whole. Would a few of you be willing to write up some brief paragraphs on things like: "So I said to Mike, we'll call them "I Descriptors" and he said

Re: UV to Text Conversion Standard?

2004-04-16 Thread Geoffrey Mitchell
To my knowledge, no. Not in Universe anyway. I *think* (from the docs, I've never played with it) that UniData has a way to map sub-values to ODBC/JDBC, but UniVerse does not. Multivalues work fine, but it doesn't go any lower than that. Best answer: don't use sub-values. They're evil, anyway.

Re: Database decoupling (Was: Future of U2)

2004-04-16 Thread FFT2001
I'm just not seeing a great demand for this sort of thing from the majority 10 to 100 user businesses that typically utilize multi-value products. I mean some of my clients, and myself are only just NOW playing with Triggers and transaction sets. Most application are very business oriented,

Re: UV to Text Conversion Standard?

2004-04-16 Thread FFT2001
Thank you, but what is the exact method to do this? I have never seen a "view of SVM level data" that actually works. Using ODBC or any other tool And by "works" I mean that it understands the relationship of the SVM data to the VM data and the relationship of that to the AM data and properly proc

RE: Database decoupling (Was: Future of U2)

2004-04-16 Thread Daly, Mark
Well no, not really. I was thinking more in the line of "New application development that would like to provide the ability to utilize modern Internet protocols". A web presence would be included in that - but was actually furthest from my mind. B2B interaction for example. Or even internal applic

RE: Database decoupling (Was: Future of U2)

2004-04-16 Thread Daly, Mark
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, April 16, 2004 11:28 AM To: [EMAIL PROTECTED] Subject: Re: Database decoupling (Was: Future of U2) In a message dated 4/15/2004 4:37:24 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: > Without th

RE: UV to Text Conversion Standard?

2004-04-16 Thread alfkec
Will, I'm not sure if this is what you're asking but all it does is create a "virtual" view of the data into 1nf tables that Excel (in this case) sees and understands. Note: I have only done this with UniData and D3 and I know UniVerse does it a little differently. -- Colin Alfke Calgary, Alber

RE: Jbase handles multivalue on RDBMS

2004-04-16 Thread Tom Firl
> > And for the not so faint of heart, jBASE provides the capability to roll > > your own driver(s) to transform your MV database definition into the relational > > database without using the jEDI development kit. > > > > Tom Firl > > Columbia Ultimate > > And I can use my shoe as a hammer, but of

Re: Jbase handles multivalue on RDBMS

2004-04-16 Thread Scott Richardson
Guess that depends on your shoe. ;^)> - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, April 16, 2004 11:38 AM Subject: Re: Jbase handles multivalue on RDBMS > In a message dated 4/15/2004 9:53:43 AM Pacific Daylight Time, > [EMAIL PROTECTED] writes:

RE: RedBack from .net

2004-04-16 Thread Tony Evans
David and Graham, Thanks for mentioning the U2 & .NET white paper. It was encouraging to see that IBM is still developing U2. The code examples listed in the white paper were almost identical to the code I had written to access a RedBack object and call its methods through the OleDb provider. U

Re: Jbase handles multivalue on RDBMS

2004-04-16 Thread FFT2001
In a message dated 4/15/2004 9:53:43 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: > And for the not so faint of heart, jBASE provides the capability to roll > your own driver(s) to transform your MV database definition into the relational > database without using the jEDI development ki

Re: UV to Text Conversion Standard?

2004-04-16 Thread FFT2001
In a message dated 4/15/2004 6:12:27 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: > Will - your posting mentioned CONVERT(VM,"|", mydata) - my version of UV > does not seem to like that. Jim, Excel CAN read comma delimited data. Ask again why the requirement for fixed length? Excel DO

Re: Database decoupling (Was: Future of U2)

2004-04-16 Thread FFT2001
In a message dated 4/15/2004 4:37:24 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: > Without this ability, I see no reason why anyone would commence new > application development on the U2 platform. Since you will always require > another application server (Websphere, Tomcat, Bea, Jboss,

Re: UV to Text Conversion Standard?

2004-04-16 Thread FFT2001
In a message dated 4/15/2004 12:52:51 AM Pacific Daylight Time, [EMAIL PROTECTED] writes: > You can use the UniVerse ODBC Driver to pull the data from UniVerse to > Excel, using correct dictionaries UniVerse will normalise the data and sort > out the VM and SVM for you. Jonathan can you give a

RE: UniVerse vs Progress Performance

2004-04-16 Thread Brutzman, Bill
I thought that Progress lives as more-or-less a traditional SQL database. Please clarify...What is special about Progress ? --Bill -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

Re: Installation unirpc

2004-04-16 Thread David Beahm
First off, try killing iptables. Even if you tell RH9 that you don't want a firewall, it still installs it and can cause this type of trouble. HTH, David Beahm Christophe Marchal wrote: Hello, I have installed universe 10.0 on a redhat 9. It works well on a telnet, unirpc daemon is running but

RE: Performance Degraded running u10.0.0 in Aix 5.2 ML 2

2004-04-16 Thread Anthony Youngman
Why? He's got 4Gb of ram. If he overflows that by JUST ONE BYTE, if he was running linux his performance would *collapse*. If you do not have twice ram as swap, you only need to use ONE BYTE of swap space and the linux algorithm will shit itself trying to cope. The algorithm does not work very we

RE: Performance Degraded running u10.0.0 in Aix 5.2 ML 2

2004-04-16 Thread Steve Ferries
HI All, Before doubling you swap space, check to see how much you are using at your busy times. We have an 8 Gig system, and a 6 Gig pool: Page Space Physical Volume Volume GroupSize %Used Active Auto Type paging00hdisk1rootvg6144MB 2 yes yeslv

RE: PI Open is going away

2004-04-16 Thread Derek Falkner
Well, I'm hanging on to my Leo III docs - just waiting for someone to come up with an emulator for the intel platform! CLEO anyone? The System/4 stuff went ages ago. Derek Falkner Kingston, Ontario, Canada > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On B

RE: Jbase handles multivalue on RDBMS

2004-04-16 Thread Dennis Bartlett
For what it's worth the Revelation / Arev / OpenInsight crowd have a thing called "Bonding" where in you can create a bond with another database structure, and natively list/sort/query that database. Bundled with Arev comes Dbase / Ascii bonds. I don't know what comes with OI, but I believe you get

RE: Performance Degraded running u10.0.0 in Aix 5.2 ML 2

2004-04-16 Thread Anthony Youngman
Okay, it's AIX not linux, but I've just noticed that RAM = swap. You are an ABSOLUTE FOOL if you do that on linux. Maybe (or maybe not) the same applies to AIX - quite likely since they are both nixen and probably manage memory similiarly. Double swap space to 8Gb and see if that improves matters

Re: UniVerse vs Progress Performance

2004-04-16 Thread Scott Richardson
Sounds like something is not tuned properly somewhere. Another Onion that needs a damn good peeling! Download the DPMonitor on both of these puppies, and then you can realistically compare volumes of I/O, volumes of CPU, volumes of memory, etc... in an "apples to apples" sort of comparison of sort

RE: PI Open is going away

2004-04-16 Thread Keith Upton
I was at Hoskyns, did a bit of gin for George II+... or our version of it! -Original Message- From: Martin Phillips [mailto:[EMAIL PROTECTED] Sent: 16 April 2004 14:19 To: U2 Users Discussion List Subject: Re: PI Open is going away > Funny that... I was only thinking the other day that I

Re: PI Open is going away

2004-04-16 Thread Martin Phillips
> Funny that... I was only thinking the other day that I should throw > out my ICL 1900 COBOL and PLAN Manuals!!! :-) Don;t start me on that nostalgia! I was an operating system developer with ICL all those years ago. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northam

Re: Performance Degraded running u10.0.0 in Aix 5.2 ML 2

2004-04-16 Thread Scott Richardson
Performance of UV applications on various Operating Systems is not rocket science. Perhaps better described as large, nasty tight onions that need peeling, one layer at a time, and understanding what each peeled layer is doing and why. Once this knowledge is acquired and understood, a plan can be b

RE: UV Crash on W2K3

2004-04-16 Thread alfkec
Interesting. I'm seeing a similar error on W2K with UD6.0.12 when we have the prompt login path ticked in the telnet config in UniAdmin. Occasionally when logging in and entering a new path we get an error. I'd be interested to know what the resolution is. Thanks -- Colin Alfke Calgary, Alberta

Re: PI Open is going away

2004-04-16 Thread Lance J. Andersen
Martin, I did the same recently. Not only did i retire my PI/Open docs but all of my old PI material dating back to my days prior to working at Prime when I was at Standard Data Systems, one of the original PI dealers . However the memories will always be with me... -Lance Martin Phill

Installation unirpc

2004-04-16 Thread Christophe Marchal
Hello, I have installed universe 10.0 on a redhat 9. It works well on a telnet, unirpc daemon is running but I could not established an ODBC connection. Some knows what should be configure on the new server to get odbc works ? thanks for help, Christophe -- u2-users mailing list [EMAIL PROTECTED

RE: U2 Personal Editions

2004-04-16 Thread Anthony Youngman
For SuSE, I had to remove all the options to cpio. Note also, that when it tries to set up the daemon to autostart on boot, that fails also because SuSE uses a different /etc/rc.d setup. That needs manually fixing, because you can't run uv as a user unless uvd is running. Cheers, Wol -Origi

RE: PI Open is going away

2004-04-16 Thread Anthony Youngman
Ummm... My wife will murder me for this ... but I'd love to have a copy (we've lost a lot of ours). Scan them or whatever. If I'm up your way for some reason (I go up the M1 regularly, but have my wife with me ...) I'd relieve you of them. Cheers, Wol -Original Message- From: Martin Phill

RE: PI Open is going away

2004-04-16 Thread Anthony Youngman
I'm planning (when I get the chance) to resurrect the EXL7330 in my garage. And the reason I salvaged it from work is that it has PI/Open on it ... Cheers, Wol -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Fitzgerald Sent: 15 April 2004 21:34 To: '

RE: PI Open is going away

2004-04-16 Thread Keith Upton
Funny that... I was only thinking the other day that I should throw out my ICL 1900 COBOL and PLAN Manuals!!! :-) -Original Message- From: Martin Phillips [mailto:[EMAIL PROTECTED] Sent: 16 April 2004 09:54 To: U2 Users Discussion List Subject: Re: PI Open is going away I was one of the

Re: PI Open is going away

2004-04-16 Thread Martin Phillips
I was one of the two technical managers for the development of PI/open. It's always sad watching a product that you worked on be put into retirement. Perhaps I can now throw out my collection of PI/open manuals. Martin Phillips Ladybridge Systems 17b Coldstream Lane, Hardingstone, Northampton NN4

Re: PI Open is going away

2004-04-16 Thread pwk_u2
Working for Prime in Copenhagen from 1984 to 1992 supporting PI I certainly remember these international events. It's fun to see the names popping up on this list, it brings along a lot of fine memories, including that I owe Lance a beer next time we met. It never happened, but the memories... Th