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 http://li

[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 i

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

Re: [U2] uv pe

2005-02-17 Thread Bruce Nichol
Goo'day, Leroy, At 20:48 17/02/05 -0700, you wrote: 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 th

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] 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] 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 yo

RE: [U2] Unidata acount on unix

2005-02-17 Thread Mike Randall
Since I screwed that up royally, what was makeudt? Sorry Susan. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ken Wallis Sent: Thursday, February 17, 2005 10:05 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Unidata acount on unix Susan Joslyn

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 responsibl

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 S

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 lo

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 s

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 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 T

RE: [U2] Unidata acount on unix

2005-02-17 Thread Martin Canty
Hi Susan, just like Windoze, only better. 'newacct' You will also need to specify a valid unix group & owner. Martin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Susan Joslyn Sent: Thursday, February 17, 2005 6:12 PM To: u2-users@listserver

RE: [U2] uv pe

2005-02-17 Thread Tony Gravagno
We don't have a corner on the market for redefining language to suit marketing. Just look at all of the MultiDimensional databases out there that have nothing do with MultiValue or Pick. Yes, I know MD and MV are themselves marketing inventions, but our market identity is/was defined by these ter

[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 mai

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 "embe

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 contr

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] 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 m

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. Althoug

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 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 P

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 Sent: Thu Feb 17 17:55:34 2005 Subject: RE: [U2] uv pe All o

RE: [U2] uv pe

2005-02-17 Thread Ken Wallis
John Aherne wrote: > SELECT blah WITH UPCASE(x) LIKE "...HELLO..." (Doesn't work, but is what > I want to do) Craig Bennett wrote: > SELECT MYFILE WITH EVAL "UPCASE(@ID)" LIKE "...HELLO..." > > Works on UniVerse. And on UniData too: SELECT VOC WITH EVAL "UPCASE(@ID)" LIKE "LIST..." 43 records

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: R

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 - O

RE: [U2] uv pe

2005-02-17 Thread Aherne, John
All of the manuals are available, and I have, and am pouring through them, but there seems to be a huge amount of code examples that are locked down. And that is only for the one thing I have looked up on their site (ODBC). It's really frustrating when you are stuck on something, and you see a titl

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 escapes

RE: [U2] uv pe

2005-02-17 Thread FFT2001
Gerry wrote: "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." Gerry Universe IS an embedded system. So every application that runs on

RE: [U2] uv pe

2005-02-17 Thread Glen B
Download a copy of OpenQM for Linux, if you want to 'play' with MV. It's quite flavor-portable and also available in a commercial version for small beans. It's more of a U2/UD flavor, than it is D3. http://openqm.sourceforge.net The only other languages I would compare dataBASIC to would be Pa

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 UPCA

[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 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...

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 o

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 somethin

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 databa

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 seem

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 PROTE

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 'Unabl

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, Febru

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 bec

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: 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] 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 wr

RE: [U2] uv pe

2005-02-17 Thread Adrian Matthews
Don;t forget that a lot of developers actually work for the end user! Also, as I've pointed out before, U2 has a bigger share of the embedded market than Oracle so not everyone thinks it's expensive or could it be that the application is more important that whats its written in. _

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 Adr

RE: [U2] uv pe

2005-02-17 Thread Larry Hiscock
http://www-306.ibm.com/software/data/u2/pubs/library/ The above page has links to the product documentation for all U2 and related products. It is available to anyone at no charge. Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTEC

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: [EMAIL

[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 where

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 us

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] 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

[U2] [OT] was uv pe now Waaaa I dont understand MVdbms

2005-02-17 Thread Jeff Schasny
Translation: My VAR stinks and I dont know UD so its bad. This list is a great place to ask questions if you have some. This should probably go to U2-community now -Original Message- Ease of development? Very little support required? I have just started to use UD, and development is h

RE: [U2] uv per

2005-02-17 Thread Phil Walker
I am in software development Phil Walker +64 27 5336294 +64 3 3120352 [EMAIL PROTECTED] Gnosys Consulting Limited 25 Roscrea Place, Mandeville North, RD2 Kaiapoi, North Canterbury 8252, NEW ZEALAND DISCLAIMER: This electronic message together with any attachments is confidential. If you are

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] 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 w

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 fil

[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 so

RE: [U2] uv pe

2005-02-17 Thread Kevin P Lynch
Bill, So you have a fast quick Oracle or DB2 solution that doesn't involve pulling teeth or a learning curve and is cost effective and machine independent ? Let me know the stock symbol ! Perhaps all the people who are touting Oracle and SQL Server should go develop in them and they can try compe

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.

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 Serv

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 probl

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

2005-02-17 Thread Marco Manyevere
As already stated in the email, I get: #/u1/uv/bin/analyze.shm -s SEMAPHORE.STATUS is not supported on this machine. Thanks for the help. Regards, Marco. [EMAIL PROTECTED] wrote: Hi Marco, analyze.shm -s at the os level will give you a list of active semaphores. That should show you which se

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 P

[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 PRO

Memo: Re: [U2] Uv Error

2005-02-17 Thread asvin . dattani
Hi Rudy, this is a real mystery then. 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 open, at the os level, the number of files s

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 point

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

[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 p

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 woul

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, y