SV: [U2] Unidata, Unirpc and Windows XP home
Martin, for Uniobject .net I happen to know that you have to put the uonet.dll filen in the WINNT\assebly catalog. I don't know if this will help you but perhaps... Regards Bjorn -Ursprungligt meddelande- Fren: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Martin Scholl Skickat: den 25 juli 2006 20:42 Till: u2-users@listserver.u2ug.org Dmne: [U2] Unidata, Unirpc and Windows XP home Hi, I installed Unidata 6.0 PE on my laptop and get everything working, telnet, UniAdmin, database service, but cannot connect with UniObjects. The error is 'failed failed to pass the message to the slave correctly' In the Event viewer I see an error for UniObject call :'There are no defined services' Then there is an information in the event log:' the description for event ID (1000) in source (Ardent Uni RPC service) is not there Does anyone know what is going on? I had this working fine before and then my laptop had a hard drive crash. Martin Scholl Pres. HIPAAsuite 18910 New Hampshire Ave Brinklow, MD 20862 Phone: 301-924-5537 Fax: 301-570-0139 [EMAIL PROTECTED] www.HIPAAsuite.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/
Re: [U2] lock records
Thanks all for your answer. I understand the issue, one phantom process only for lock management. But i don't know how to create and communicate with this phantom process. Could you explain a little bit or give me an example or URL? Thanks El mar, 25-07-2006 a las 13:09 -0400, Results escribis: Chuchi, Don't have the session lock them. Send the lock requests to a persistant phantom. It can do the locks and unlocks. You'd set it up like this: File: LOCK.QUEUE Program: ACQUIRE.LOCK - which asks the Phantom to lock an item by putting the details in the LOCK.QUEUE file. Program: RELEASE.LOCK - which asks the Phantom to unlock an item by putting the details in the LOCK.QUEUE file. Program: READ.THROUGH.LOCK - which asks the Phantom to read the locked item by putting the details in the LOCK.QUEUE file. Best of luck. chuchi wrote: Hi all, I want to lock a record from UniObjects in the server until i unlock by hand. My problem is that when lock a record and close session or app ends, Universe unlock this record. Do you know if I can do it?? Thanks all!! --- 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] lock records
Chuchi, This is the concept: File: LOCK.QUEUE Program: ACQUIRE.LOCK - which asks the Phantom to lock an item by putting the details in the LOCK.QUEUE file. SUBROUTINE ACQUIRE.LOCK(FileName,ItemName,SomeIdentifierForRequestingProcess) * Comments GOSUB OPEN.FILES ;* Open files you'll need to get started (i.e. LOCK.QUEUE) GOSUB INIT.VARS ;* Set up variables, like PORT.NO LQ.REC = 'ACQUIRE' LQ.REC2 = FileName LQ.REC3 = ItemName LQ.REC4 = SomeIdentifierForRequestingProcess LQ.ID = DATE():'*':TIME():'*':PORT.NO WRITE LQ.REC on LQ.FILE, LQ.ID STOP * Subroutines go here Program: RELEASE.LOCK - which asks the Phantom to unlock an item by putting the details in the LOCK.QUEUE file. Code is the same as above, except send 'RELEASE' instead of 'ACQUIRE' Program: READ.THROUGH.LOCK - which asks the Phantom to read the locked item by putting the details in the LOCK.QUEUE file. Code is the same as above, except you send 'READ' and add a variable to return the data. The phantom itself is just a Loop/Read LQ.REC/Do Acquire-Release-Read/Repeat. Anymore specific than this and I'd have to charge you for writing it. - Chuck chuchi wrote: Thanks all for your answer. I understand the issue, one phantom process only for lock management. But i don't know how to create and communicate with this phantom process. - Charles Barouch [EMAIL PROTECTED] (718) 762-3884 x 1 P. O. Box 540957, Linden Hill, NY 11354-0957 www.KeyAlly.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2][UV] XML DOM
I'm struggling with setting up an extraction file on UniVerse in order to process an XML document. Unless I'm missing something it appears that the documentation is anything but consistent and complete. Does anyone have a How-to or other document that better explains how to set this up? Thanks. Perry Taylor Zirmed, Inc. CONFIDENTIALITY NOTICE: This e-mail message, including any attachments, 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. ZirMed, Inc. has strict policies regarding the content of e-mail communications, specifically Protected Health Information, any communications containing such material will be returned to the originating party with such advisement noted. 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 To unsubscribe please visit http://listserver.u2ug.org/
[U2] [UV] QSELECT in transaction
Hi, is there a way to allow an EXECUTE QSELECT... inside a transaction in a basic program. The HELP BASIC EXECUTE specifies a few verbs that are allowed inside transaction : if a SELECT / SSELECT is allowed, cant a QSELECT be allowed aswell? Or might I be missing something? Any ways to overcome this? Thanks. Regards, Brian. +--- ---+ |The EXECUTE statement fails and the program terminates with a | |run-time error message if: | | | |o dynamic.array or expression in the IN clause evaluates to the | | null value. | | | |o The command expression evaluates to the null value. | | | |Although you cannot use the EXECUTE statement within a | |transaction to execute most UniVerse commands and SQL | |statements, you can use EXECUTE to execute the following | |UniVerse commands and SQL statements within a transaction: | | | | CHECK.SUM INSERT SEARCH SSELECT | | COUNT LIST SELECT (RetrieVe) STAT | | DELETE (SQL) LIST.ITEMSELECT (SQL)SUM | | DISPLAYLIST.LABEL SORTUPDATE | | ESEARCHRUN SORT.ITEM | | GET.LIST SAVE.LISTSORT.LABEL | | | | More End Help List Commands | +---+ Page Up/Page Down +--+ Verb QSELECT illegal when a transaction is active. Rolling back uncommitted transactions begun within this execution environment. Important Notice: This email is subject to important restrictions, qualifications and disclaimers (the Disclaimer) that must be accessed and read at the following address or by copying and pasting the following address into your Internet browser's address bar: http://www.frstia.co.za/Disclaimer.asp The Disclaimer is deemed to form part of the content of this email in terms of Section 11 of the Electronic Communications and Transactions Act, 25 of 2002. If you cannot access the Disclaimer, please obtain a copy thereof from us by sending an email to mailto:[EMAIL PROTECTED] FirstRand STI Admin (Pty) Ltd is an Authorised Financial Services Provider --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2][UV] XML DOM
I found the documentation to be, um, challenging, also. You can download a PDF of my slides of my U2 XML introduction presented at the 2006 International Spectrum Conference in Long Beach at this url: http://www.oliver.com/Spectrum2006/U2_xml.pdf Hope that helps. -- Regards, Clif ~~~ W. Clifton Oliver, CCP CLIFTON OLIVER ASSOCIATES Tel: +1 619 460 5678Web: www.oliver.com ~~~ On Jul 26, 2006, at 6:46 AM, Perry Taylor wrote: I'm struggling with setting up an extraction file on UniVerse in order to process an XML document. Unless I'm missing something it appears that the documentation is anything but consistent and complete. Does anyone have a How-to or other document that better explains how to set this up? Thanks. Perry Taylor Zirmed, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] RE: Multivalued datatypes considered harmful | The Register
This is our CTO at FusionWare Robert Houben's thoughts on the article. Robert is the Grandfather of ODBC, he created the first published ODBC driver outside of Microsoft and has been creating integration products for the Multivalue database since the early 80's, anyone remember PK Harmony. Enjoy! So here is the real problem. The author of the article explains why the multivalues make life so much easier for developers, then tries to explain why they are bad anyways. Here is the snippet where he does this: Fair enough. So let's look at an intensely practical reason why multi-valued fields are so bad. We query databases using SQL. The design of SQL is based entirely on the assumption that each column contains atomic values. If we run a normal SQL query against our single table solution: SELECT FName FROM CUSTOMER WHERE Hobby = Rollerball It will return zero rows; despite the fact that one of our customers plays rollerball, because there is no row with a field just containing rollerball. - end of quote - So this is the problem with his logic. The SQL SELECT statement was designed to work within the constraints of a single-valued first-normal-form environment. To predicate an argument against multivalues on the basis of a query language that assumes their non-existence is disingenuous. I'm surprised that a thinking person would do this. As *we* know, users can build very powerful, complex queries using the PICK LIST/SELECT syntax that accounts for multivalues, and the above observation is just plain bogus. There are other things wrong with the article, but the most compelling issue is that with the emergence of XML as a mechanism for processing complex data sets, multivalues have been reintroduced and are here to stay. If you look at it, both XPath and XQuery understand multivalues and allow you to build complex predicates that operate at the multi, sub, and sub-sub level. There are at this point MANY data environments where this takes place, including the DataSet object in ADO.NET and proprietary data objects from other vendors, which use XML as the underlying structure and allow nesting to take place. What Microsoft is doing with Access is simply to recognize the reality that many developers are already using XML to work around. The author's claim that we query data with SQL is no longer true. I would argue that XPath and XQuery are emerging as powerful, standards-based alternate query languages. Ignore them at your peril! --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] QSELECT in transaction
is there a way to allow an EXECUTE QSELECT... inside a transaction in a basic program. The HELP BASIC EXECUTE specifies a few verbs that are allowed inside transaction : Have you tried: SELECT FILE SAVING FIELD.NAME ? For example: SELECT CUSTOMERS SAVING KEY.ADR ? It should be the equivalent of: QSELECT CUSTOMERS SAVING (field #) __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] lock records
A most useful mechanism (and much ignored) for controlling and communicating with PHANTOMS: LOCK n e.g. A Phantom process starts up and sets (for example) LOCK 1 to say it is running. If the lock attempt fails then the PHANTOM process is already running and it terminates. A controlling process wants to check if the PHANTOM is running - it tries to set LOCK 1 and if successful releases the lock and knows that it is not running. If the lock IS set then the PHANTOM is running. When the controlling process wished to shut the PHANTOM down then it sets LOCK 2 and goes into a loop (with limits and SLEEP2) and waits for LOCK 1 to be released: As part of its normal cycle the PHANTOM checks LOCK 2 at intervals. If the lock is gained then it is released (no action). If LOCK 2 is set however then the PHANTOM unsets LOCK 1 and self-terminates normally under full control (no kills / logoffs etc). The controlling process detects the clearing of LOCK 1 (by trying to set it in its watching loop) and unsets LOCK1 and LOCK 2 - end (happy bunnies). If the PHANTOM does not terminate within a set period then you may choose to escalate to a force logout or try again. They same technique can be used for driving communications or application events, and if you have a LOT of processes so that the number of LOCKs available is insufficient then you can allocate pairs of locks dynamically (i.e. not hard-coded in the programs) from the pool available (default 1 - 64). Just so long as the number of locks in use at any one time does not exceed the maximum number of locks available. Works Neat (if I say so myself) Well tried and tested (over 12 years running to my knowledge). Regards JayJay --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Encrypt
Hi, Has anyone had any luck encrypting using Universe's encrypt function, passing that data to another application and being able to decrypt using the mcrypt library or similar. The other app is not U2 or related. Thanks, John [demime 1.01d removed an attachment of type text/x-vcard which had a name of john.vcf] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Unidata, Unirpc and Windows XP home
I found the culprit. It was a corrupt database. The error was 39209: Failed to read from slave correctly The slave must be the IO slave and the file system must have returned garbage since the file was bad. I replaced the database and everything works fine now. Martin Scholl Pres. HIPAAsuite 18910 New Hampshire Ave Brinklow, MD 20862 Phone: 301-924-5537 Fax: 301-570-0139 [EMAIL PROTECTED] www.HIPAAsuite.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, July 26, 2006 2:18 AM To: u2-users@listserver.u2ug.org Subject: SV: [U2] Unidata, Unirpc and Windows XP home Martin, for Uniobject .net I happen to know that you have to put the uonet.dll filen in the WINNT\assebly catalog. I don't know if this will help you but perhaps... Regards Bjorn -Ursprungligt meddelande- Fren: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Martin Scholl Skickat: den 25 juli 2006 20:42 Till: u2-users@listserver.u2ug.org Dmne: [U2] Unidata, Unirpc and Windows XP home Hi, I installed Unidata 6.0 PE on my laptop and get everything working, telnet, UniAdmin, database service, but cannot connect with UniObjects. The error is 'failed failed to pass the message to the slave correctly' In the Event viewer I see an error for UniObject call :'There are no defined services' Then there is an information in the event log:' the description for event ID (1000) in source (Ardent Uni RPC service) is not there Does anyone know what is going on? I had this working fine before and then my laptop had a hard drive crash. Martin Scholl Pres. HIPAAsuite 18910 New Hampshire Ave Brinklow, MD 20862 Phone: 301-924-5537 Fax: 301-570-0139 [EMAIL PROTECTED] www.HIPAAsuite.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-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Encrypt
I haven't used the encrypt function specifically, but I have implemented RC4 encryption in UniBasic, PHP and a couple of other languages. What's the other app written in? Larry Hiscock Western Computer Services http://www.wcs-corp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Godzina Sent: Wednesday, July 26, 2006 3:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] Encrypt Hi, Has anyone had any luck encrypting using Universe's encrypt function, passing that data to another application and being able to decrypt using the mcrypt library or similar. The other app is not U2 or related. Thanks, John [demime 1.01d removed an attachment of type text/x-vcard which had a name of john.vcf] --- 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] Encrypt
PHP and perl. I can do the implementation if need be, but I'd rather use existing libraries if possible. For example, Universe provides a variety of DES (des, 3des) and RC encryption routines, and PHP and perl can use the mcrypt (e.g.: --with-mcyrpt on the configure line when building php, and with various packages found on cpan for perl). The issue is, the universe encrypt and the mcrypt give different resulting data for the same algorithm, passphrase, iv, crypt type (cbc, for example). Thanks, John Larry Hiscock wrote: I haven't used the encrypt function specifically, but I have implemented RC4 encryption in UniBasic, PHP and a couple of other languages. What's the other app written in? Larry Hiscock Western Computer Services http://www.wcs-corp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Godzina Sent: Wednesday, July 26, 2006 3:16 PM To: u2-users@listserver.u2ug.org Subject: [U2] Encrypt Hi, Has anyone had any luck encrypting using Universe's encrypt function, passing that data to another application and being able to decrypt using the mcrypt library or similar. The other app is not U2 or related. Thanks, John [demime 1.01d removed an attachment of type text/x-vcard which had a name of john.vcf] --- 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/ [demime 1.01d removed an attachment of type text/x-vcard which had a name of john.vcf] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] lock records
We do exactly the same thing but with READU locks instead. The locks can be on non-existent records and the record names can be meaningful (eg. processname.running) - so a LIST.READU will show which phantoms are running. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Jenkins Sent: Thursday, 27 July 2006 4:53 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] lock records A most useful mechanism (and much ignored) for controlling and communicating with PHANTOMS: LOCK n e.g. A Phantom process starts up and sets (for example) LOCK 1 to say it is running. If the lock attempt fails then the PHANTOM process is already running and it terminates. A controlling process wants to check if the PHANTOM is running - it tries to set LOCK 1 and if successful releases the lock and knows that it is not running. If the lock IS set then the PHANTOM is running. When the controlling process wished to shut the PHANTOM down then it sets LOCK 2 and goes into a loop (with limits and SLEEP2) and waits for LOCK 1 to be released: As part of its normal cycle the PHANTOM checks LOCK 2 at intervals. If the lock is gained then it is released (no action). If LOCK 2 is set however then the PHANTOM unsets LOCK 1 and self-terminates normally under full control (no kills / logoffs etc). The controlling process detects the clearing of LOCK 1 (by trying to set it in its watching loop) and unsets LOCK1 and LOCK 2 - end (happy bunnies). If the PHANTOM does not terminate within a set period then you may choose to escalate to a force logout or try again. They same technique can be used for driving communications or application events, and if you have a LOT of processes so that the number of LOCKs available is insufficient then you can allocate pairs of locks dynamically (i.e. not hard-coded in the programs) from the pool available (default 1 - 64). Just so long as the number of locks in use at any one time does not exceed the maximum number of locks available. Works Neat (if I say so myself) Well tried and tested (over 12 years running to my knowledge). Regards JayJay --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] LISTB (tab delimited output)
I have used ListB verb on Unidata (manage 2000) I have created a ListB verb on D3 (by adding a switch to the list verb) Is this feature on UniVerse? What it forms is output that is tab delimited. Creating an excel ready spooled file. Thanks D Raven [EMAIL PROTECTED] cell (949)2282224 e Fax (815)4259364 P.O. Box 17811, Irvine CA 92623-7811 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] Weird error
Hee! hee! PORT.STATUS, by poking around in the other process's printer shared memory segment, must have woken it from its nanosleep. Sorry I can't contribute anything useful. Has anyone ever seen the error nanosleep: Interrupted system call ? I had a process running that was creating a flat file of inventory history. The process seemed to be hanging on a READ. I issued a PORT.STATUS against the pid when suddenly the above error appeared and the process took off. Any thoughts would be appreciated. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] QSELECT in transaction
Have you tried PERFORM rather than EXECUTE? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] lock records
Can you not simply change the BlockingStrategy property of the session object? --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] [UV] QSELECT in transaction
Preform is an older version and sometime you get different results? D Raven [EMAIL PROTECTED] cell (949)2282224 e Fax (815)4259364 P.O. Box 17811, Irvine CA 92623-7811 -- Ray Wurlod [EMAIL PROTECTED] wrote: Have you tried PERFORM rather than EXECUTE? --- 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] windows 2003 parameters
Anybody know how to view/change the limit on the number of systemwide open files on a windows 2003 server (std. edition, in this case)? I can see how many are currently open (50 or less)(no matter what I throw at it), but I'm looking for the equivalent of MFILES at the os level. MFILES is 400, but I never see more than 50 open files at a time. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] windows 2003 parameters
Dan, Mine is in C:\IBM\UV\uvconfig which is a text file. Jef Lee Software Developer IT Vision Australia Pty Ltd PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA Australia 6153 p: (08) 9315 7000 f: (08) 9315 7088 w: www.itvision.com.au -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dan Fitzgerald Sent: Thursday, 27 July 2006 12:59 PM To: u2-users@listserver.u2ug.org Subject: [U2] windows 2003 parameters Anybody know how to view/change the limit on the number of systemwide open files on a windows 2003 server (std. edition, in this case)? I can see how many are currently open (50 or less)(no matter what I throw at it), but I'm looking for the equivalent of MFILES at the os level. MFILES is 400, but I never see more than 50 open files at a time. --- 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/