RE: [U2] uv pe

2005-02-17 Thread Adrian Matthews
Yes but how much does it cost to license Oracle and Access for a Live environment? From: [EMAIL PROTECTED] on behalf of Phil Walker Sent: Thu 17/02/2005 01:17 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe Hi, Microsoft and Oracle both GIVE away,

RE: [U2] uv pe

2005-02-17 Thread Adrian Matthews
To license Oracle for our production hardware would cost GBP250,000 or FIVE times what Universe costs us. And thats just for a database, I'd have to get more licenses to actually develop an equivalent system. I may have to pay for dev/test licenses on Universe whereas on Oracle I don't but it

[U2] [UV]Unable to get process lock semaphore

2005-02-17 Thread Marco Manyevere
Hi, I get the error message 'Unable to get process lock semaphore' in a complicated application for which I have no source code. 1) What could be the cause of my problem? The only setup parameter I see linked to process semaphores is PSEMNUM which is set to 64. Can I increase this? What unix

RE: [U2] uv pe

2005-02-17 Thread u2
[EMAIL PROTECTED] wrote: Hi, Microsoft and Oracle both GIVE away, yes I said give away versions of their database products, and they both interact easily with modern gui/web based development environments, and you can search HUGE knowledge bases of information about how to do something.

RE: [U2] uv pe

2005-02-17 Thread Simon Carter
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Adrian Matthews Sent: 17 February 2005 10:26 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe Yes but how much does it cost to license Oracle and Access for a Live environment? Adrian, Fair

Memo: Re: [U2] Uv Error

2005-02-17 Thread asvin . dattani
Hi Rudy, this is a real mystery then. Donning deer stalker hat and smoking pipe We had a problem once with the number of open files in the rotating file pool getting confused. As you probably know, you can open many more files in a Universe program then the os allows. Universe will only keep

[U2] [UV] LIST.LOCKS - Unable to get process lock semaphore

2005-02-17 Thread Marco Manyevere
In addition to my message below, when I enter the UV command LIST.LOCKD I get the following: LIST.LOCKS Unable to get process lock semaphore. [EACCES] Permission denied Unable to get process lock semaphore. [EACCES] Permission denied [192.168.1.1: remote disconnect] Marco Manyevere [EMAIL

Memo: Re: [U2] [UV]Unable to get process lock semaphore

2005-02-17 Thread asvin . dattani
Hi Marco, analyze.shm -s at the os level will give you a list of active semaphores. That should show you which semaphore is set. The use the UNLOCK with the SEMAPHORE key word to release it. Do HELP UNLOCK to get more details... hth Marco Manyevere [EMAIL PROTECTED] on 17 Feb 2005 10:56

RE: [U2] uv pe

2005-02-17 Thread Bill H.
Phil: Although this is a U2 specific list, the same pricing problem exists with ALL mvDbms products. In addition knowledge seems to be locked up and there are so many proprietary solutions to simple problems. Developers often have to pull teeth to solve some basic problems. Every business

RE: [U2] uv pe

2005-02-17 Thread Bill H.
Adrian: I recently saw a Dell add where they partner with Oracle and one can purchase an Oracle license for about $150/license. Don't know how that works out in a web environment or a device licensing scenario but that's not anywhere near as expensive as it used to be. Also, Microsoft SQL

RE: [U2] uv pe

2005-02-17 Thread gerry-u2ug
I don't get your point ? Who cares about Users opinions on PE, they should already have a fully licensed installation. I am just a poor lowly developer. Also - don't forget to consider that as developer costs rise, so do the costs of the products/services that they pass on to their customers.

[U2] Conversion to Windoze % vs ? character

2005-02-17 Thread Donald Kibbey
I'm attempting to convert a system using a uvbackup tape from hpux to windows. I've noticed that many cataloged items now have a name that ends in the % character wheras on the production system they end in a ? character. Is there something I'm missing here as far as a conversion command or

Re: [U2] Uv Error

2005-02-17 Thread Cooper, Rudy
Hi, I had pretty much done everything that you have already suggested prior to posting here. My next move is to look at MFILES, our's is set to 200. Providing your MFILES number is less than the os per process limit of open files Does anyone know how to check the os per process limit of open

RE: [U2] uv pe

2005-02-17 Thread Aherne, John
Ease of development? Very little support required? I have just started to use UD, and development is horrific, it take 10 times longer to do things that can be accomplished by a single line query in an RDBMS'. Our system requires constant attention, more attention than even MS Sql server on a bad

Re: [U2] Conversion to Windoze % vs ? character

2005-02-17 Thread Martin Phillips
I'm attempting to convert a system using a uvbackup tape from hpux to windows. I've noticed that many cataloged items now have a name that ends in the % character wheras on the production system they end in a ? character. Is there something I'm missing here as far as a conversion command or

Re: [U2] Conversion to Windoze % vs ? character

2005-02-17 Thread Don Verhagen
You cannot use ? in a filename on Windoze (Same as *) that you may have used on Unix. I know my FTP client switches any * in filenames (record id in a directory file) to @ when I ftp from UNIX to Windows. Thanks, -- Donald Verhagen Application Development Manager [EMAIL PROTECTED]

RE: [U2] uv pe

2005-02-17 Thread Allen E. Elwood
Hey John, I have programmed in COBOL, Fortran 4, TAC Business basic, Assembly on the IBM 370, Assembly on the 8086x, native Pick, MS QuickBasic, (did some goofing around with VB), SQL, HTML, Java and most extensively with Unidata. It is by far superior in dev time ONCE YOU KNOW what you're doing.

RE: [U2] uv pe

2005-02-17 Thread Kevin P Lynch
I'm not sure what docs you are referring to , but ALL of the documentation for UD and UV is available either online or via pdf download on IBMs website. I agree that the knowledgebase should be open, but it doesn't hold tech docs, it only holds support call information and it's generally not as

[U2] HS.SCRUB

2005-02-17 Thread gerry-u2ug
According to the UV docs , HS.SCRUB with no arguments other than a filename will do nothing but generate a data error report. However it seems that HS.SCRUB does some type of internal record or file locking that completely messes up writes to the specified file. We have run into the situation

RE: [U2] uv pe

2005-02-17 Thread Adrian Matthews
But in that environment (as an embedded database) U2 is already far bigger than Oracle. From: [EMAIL PROTECTED] on behalf of Simon Carter Sent: Thu 17/02/2005 11:35 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe -Original Message- From:

RE: [U2] uv pe

2005-02-17 Thread Adrian Matthews
For us we would have to use the Oracle enterprise licenses due to the number of cpu's we use. A lot, lot more than $150 per cpu. From: [EMAIL PROTECTED] on behalf of Bill H. Sent: Thu 17/02/2005 16:13 To: u2-users@listserver.u2ug.org Subject: RE: [U2] uv pe

Re: [U2] [UV] LIST.LOCKS - Unable to get process lock semaphore

2005-02-17 Thread FFT2001
Marco wrote: In addition to my message below, when I enter the UV command LIST.LOCKD I get the following: LIST.LOCKS Unable to get process lock semaphore. Well would this mean something like I can't access the LOCK table because some other process currently has it LOCKed ? You could try

RE: Memo: Re: [U2] Uv Error

2005-02-17 Thread Stevenson, Charles
Now THIS is getting interesting! I saw something similar twice. Once a hashed file header was corrupted with a line that should have been written into a como file. Another when a file had data from uv/SYS.MESSAGE written in it. Both occurred in the context of a transaction logging failure. I've

RE: [U2] uv pe

2005-02-17 Thread Andrew Lakeland
John, There is also a huge amount of things which can be done with a single line query in both UD and UV. Because you don't know how to do them does not mean they cannot be done. As you say, you are new, it's an unwise man who rubbishes a product he knows little about. Suggest you ask a few

Re: [U2] [UV] LIST.LOCKS - Unable to get process lock semaphore

2005-02-17 Thread Drew Henderson
Or, more simply, ED VOC NOTHING Drew [EMAIL PROTECTED] wrote: Marco wrote: In addition to my message below, when I enter the UV command LIST.LOCKD I get the following: LIST.LOCKS Unable to get process lock semaphore. Well would this mean something like I can't access the LOCK table because

RE: [U2] uv pe

2005-02-17 Thread Dave Walker
Geez, he's right there in Denver, too. -- Dave Walker 8..7 4(()) -::- -::-8.74 .74(()) ((88.74 ..74 -::- ((88.74 * Peace -Original Message- From: Andrew Lakeland [mailto:[EMAIL PROTECTED] Sent: Thursday, February

RE: [U2] [UV]Unable to get process lock semaphore

2005-02-17 Thread Stevenson, Charles
Marco, I assume you've contacted the vendor(s) by now? It sounds like a question for IBM support. Since you have no source code, application support, too. If when you get an answer, please post it here. Thanks, cds -Original Message- From: Marco Manyevere I get the error message

RE: [U2] uv pe

2005-02-17 Thread gerry-u2ug
ok , so why would they care about PE ? What are you basing your 'embedded market' statement on ? I haven't heard of any instances of universe being run on any kind of embedded system - not saying there aren't any, i've just never heard of them. -Original Message- From: [EMAIL

RE: [U2] uv pe

2005-02-17 Thread Phil Walker
The knowledge base does include how-to information, even if it is in a support call. Why should a user or var bother someone up the food chain when the information is already held somewhere? I forgot, we are talking about the 'crown jewels' aren't we.;-) Please, I do like the product, it just

Re: [U2] uv pe

2005-02-17 Thread Drew Henderson
To toss my two cents worth in (as if you haven't received enough comments, already! ;) By modern, do mean a brand new technology? Or something that is evolving? The U2 products have evolved tremondously over time (I started on Prime INFORMATION in 1985). If you mean a completely new

RE: [U2] [UV] LIST.LOCKS - Unable to get process lock semaphore

2005-02-17 Thread Ken Wallis
[EMAIL PROTECTED] wrote: Marco wrote: In addition to my message below, when I enter the UV command LIST.LOCKD I get the following: LIST.LOCKS Unable to get process lock semaphore. [important bit snipped by Will] [EACCES] Permission denied Well would this mean something like I can't

Re: [U2] uv pe

2005-02-17 Thread Craig Bennett
Hi John, Ease of development? Very little support required? I have just started to use UD, and development is horrific, it take 10 times longer to do things that can be accomplished by a single line query in an RDBMS'. Our system requires constant attention, more attention than even MS Sql server

Re: [U2] uv pe

2005-02-17 Thread Key Ally
Gerry, Embedded is also a code word meaning we don't mention this part by name. When people sell DB2 or Oracle based solutions, they tend to say, we run our Apparel Application on Oracle. When the run on UniVerse, UniData, and other MVs, they tend to say: We have an Apparel Application...

[U2] u2-users:

2005-02-17 Thread Tom Dodds
u2-users: unsubscribe u2-users end Tom Dodds [EMAIL PROTECTED] 630-235-2975 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/

RE: [U2] uv pe

2005-02-17 Thread Aherne, John
True, I really shouldn't write off anything that I am not informed about, but we have programmers here that have been programming Unidata since time immemorial and they don't know how to do something like a select statement that converts criteria into caps for comparison. E.g. SELECT blah WITH

Re: [U2] uv pe

2005-02-17 Thread Craig Bennett
John, I want to do). The best answer I got was create a virtual field that stored the field in caps and then use that in the select. In fact, the example in an old Unidata manual I found says to do just that. Perhaps there is good reasoning behind that method, but the logic of it completely

Re: [U2] uv pe

2005-02-17 Thread John Kent
John, i agree, why make it hard for the developer when we are trying to promote their product. Open up all information sources so we can do as much as possible. Good product, bad support One of the reason i like VB is that there is so much info out there and its so easy to get at jak -

RE: [U2] uv pe

2005-02-17 Thread gerry-u2ug
what exactly is your definition of embedded ? and if universe IS an embedded system - what system isn't ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, February 17, 2005 06:31 PM To: u2-users@listserver.u2ug.org Subject:

Re: [U2] uv pe

2005-02-17 Thread Lance Jahnke
John, if you are using universe and have universe BASIC or TCL questions, you can email me offline. I would be happy to help you. -Original Message- From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org u2-users@listserver.u2ug.org Sent: Thu Feb 17 17:55:34 2005

RE: [U2] uv pe

2005-02-17 Thread Bob Woodward
If memory serves me correctly, you also use an in-line FMT or OCONV if you don't have write permissions on the DICT of the file. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Craig Bennett Sent: Thursday, February 17, 2005 3:41 PM

RE: [U2] uv pe

2005-02-17 Thread gerry-u2ug
wow - I'm always amazed at the tendency of people on this list and perhaps mv in general to take well defined terms and turn around and use those terms in a completely different context in what seems like an attempt to 'pull one over' by forgetting to mention that their definition is completely

RE: [U2] uv pe

2005-02-17 Thread Aherne, John
Glen, Thanks for the link, but we have a test system that I am allowed to break :) As for the constant attention, well I don't know anything at all about the administration side of things yet, but there seems to be something needing urgent attention at least once a week. Although

Re: [U2] uv pe

2005-02-17 Thread Bruce Nichol
Goo'day, At 10:40 18/02/05 +1100, you wrote: John, I want to do). The best answer I got was create a virtual field that stored the field in caps and then use that in the select. In fact, the example in an old Unidata manual I found says to do just that. Perhaps there is good reasoning behind that

RE: [U2] uv pe

2005-02-17 Thread Aherne, John
Thanks Craig, that works perfectly. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Craig Bennett Sent: Thursday, February 17, 2005 4:41 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] uv pe John, I want to do). The best answer I got was create

RE: [U2] Embedded systems was uv pe

2005-02-17 Thread FFT2001
An embedded system in this context would be one where the programming language, query language, data structures, and operating system are all embedded within the application. The application completely encapsulates all of these functions, making this invisible to the operator. This is in

RE: [U2] uv pe

2005-02-17 Thread David Scoggins
Gerry, This IS a generally accepted use of the term embedded database and it certainly isn't confined to this list or the mv community. It may be one with which you are not familiar, but that's another issue entirely. An embedded database doesn't necessarily have anything to do with an embedded

[U2] Unidata acount on unix

2005-02-17 Thread Susan Joslyn
This is such a fundamental question ...sorry I'm such a numbskull -- I never do this. How does one make a directory on unix into a unidata account? On windoze I just make the directory and then go to it and type 'newacct'. What does the trick on unix? Thanks a million! Susan --- u2-users

RE: [U2] Unidata acount on unix

2005-02-17 Thread Mike Randall
It's been a while but I believe it was makeudt? Too much Windows lately for me. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Thursday, February 17, 2005 9:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] Unidata acount on unix

Re: [U2] Unidata acount on unix

2005-02-17 Thread Wally Terhune
same. You can also avoid the lists and prompts for owner and group by specifying eg newacct root sys Wally Terhune Manager - U2 Advanced Technical Services IBM Information Management Solutions Tel: 303.294.4866 Fax: 303.294.4832 [EMAIL PROTECTED] www.ibm.com/software/data/u2/support

RE: [U2] Unidata acount on unix

2005-02-17 Thread Ken Wallis
Susan Joslyn wrote: This is such a fundamental question ...sorry I'm such a numbskull -- I never do this. How does one make a directory on unix into a unidata account? On windoze I just make the directory and then go to it and type 'newacct'. What does the trick on unix? Its the same

Re: [U2] uv pe

2005-02-17 Thread Leroy Dreyfuss
Craig, It wasn't that we just wanted to update them, we had to remove them for legal reasons. I cannot go into the issues specifically, but suffice it to say we had to make some changes and obtain certain approvals so that we could have them on the Internet again. They will be hosted in another

RE: [U2] uv pe

2005-02-17 Thread Leroy Dreyfuss
Exactly. You have the right to use the software for personal development use, but it not to distribute it. It's free of charge but that doesn't imply it's freeware. Regards, LeRoy F. Dreyfuss Product Manager IBM UniVerse and UniData (U2) Extended Relational Databases IBM Information Management

Re: [U2] uv pe

2005-02-17 Thread Leroy Dreyfuss
IBM isn't treating you unfairly, John. We sell through business partners and they act according to their own business models and contractual obligations with their clients as well as with their vendors. For technical information, your reseller (in your case, your Master VAR) would be the

Re: [U2] uv pe

2005-02-17 Thread Leroy Dreyfuss
John, We are contractually bound to work though our valued business partners. We do appreciate your loyalty, we really do. However, your contracts are with your Master VAR. We happily assist our Master VARs and direct partners with technical information. They in turn provide that information to

RE: [U2] Unidata acount on unix

2005-02-17 Thread Martin Canty
If I remember (in my dim distant past), it's used to compile a new UniData executable... Used if custom C routines need to be compiled into UniData. Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Thursday, February 17, 2005

RE: [U2] Unidata acount on unix

2005-02-17 Thread Kevin King
...to rebuild the udt executable from object libraries. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mike Randall Sent: Thursday, February 17, 2005 9:08 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata acount on unix Since I screwed that

Re: [U2] uv pe

2005-02-17 Thread John Kent
Leroy, so if a client wants to see some knowledge base article they must go from me to my master var to IBM and back again. I am not even going to suggest this. Some people like to find out as much as they can by themselves before bothering anyone. I had a recent example of a clent IT manager

[U2] u2TechConnect

2005-02-17 Thread GarryS
As an application programmer the information contained in U2TechConnect is probably far more technical than I will need for providing end user screens and reports. To some degree I would like to know about a 64bit file Header corruption and how to run the tools to fix. Or how to find out

Re: [U2] uv pe

2005-02-17 Thread Moderator
All, Two things: (1) Please move this to U2-Community. (2) Please don't kill the messenger. Some of the comments to Leroy (who is taking his own time to respond to us) are bordering on rude. - Charles Barouch, Moderator To subscribe to the U2-Community please visit