Re: [U2] RECORDLOCKED statement
The only consideration is that your second case statement picks up at -2 instead of -1. I think you are going for CASE RECORDLOCKED(PICH.TX, SO) = LOCK$OTHER.READL which is the -1 return value. At least according to the UniVerse documentation. Regards, Raul Dominguez raul_doming...@neimanmarcus.com 972-401-6502 Baker Hughes baker.hug...@mouser.com Sent by: u2-users-boun...@listserver.u2ug.org 12/15/2009 05:17 PM Please respond to U2 Users List u2-users@listserver.u2ug.org To 'U2 Users List' u2-users@listserver.u2ug.org cc Subject [U2] RECORDLOCKED statement I admit I have never used this little jewel of a [UV] statement, so although the code runs and works as designed, before I load it to production, someone please tell me if there are any nuances that would improve the design/operation. CASE RECORDLOCKED(PICH.TX, SO) = LOCK$MY.READU * This user/process already has a lock on the record, and we DO NOT * WANT to clear the lock if process is ORDER.UPDATE so check the stack. IF INDEX(SYSTEM(9001),ORDER.UPDATE,1) THEN WRITEVU ON PICH.TX, SO, 37 END ELSE WRITEV ON PICH.TX, SO, 37 RELEASE PICH.TX, SO END CLEARED.CCA.HOLD = TRUE CASE RECORDLOCKED(PICH.TX, SO) = LOCK$OTHER.READU * Another User has the record locked, we cannot update at this time ERR.NUM = 'C043' ERR.MSG = 'PICH.TX RECORD IS LOCKED, TRYING TO CLEAR CREDIT CARD HOLD' DOC.NUM = SO ; DOC.TYP = 'ORDER' ; FILE.NM = 'PICH.TX' GOSUB SEND.ERROR CASE RECORDLOCKED(PICH.TX, SO) = LOCK$NO.LOCK * There is no lock on this record presently, free and clear READVU HOLD.RSN FROM PICH.TX, SO, 37 LOCKED * ...but that could change in 1 ms so still handle the locked condition. ERR.NUM = 'C043' ERR.MSG = 'PICH.TX RECORD IS LOCKED, TRYING TO CLEAR CREDIT CARD HOLD' DOC.NUM = SO ; DOC.TYP = 'ORDER' ; FILE.NM = 'PICH.TX' GOSUB SEND.ERROR RELEASE PICH.TX, SO END THEN WRITEV ON PICH.TX, SO, 37 CLEARED.CCA.HOLD = TRUE END CASE Thank you. -Baker This communication, its contents and any file attachments transmitted with it are intended solely for the addressee(s) and may contain confidential proprietary information. Access by any other party without the express written permission of the sender is STRICTLY PROHIBITED. If you have received this communication in error you may not copy, distribute or use the contents, attachments or information in any way. Please destroy it and contact the sender. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Uni data / uni-objects connectivity
Juan, uniobjects acts as bridging software. It connects to your database via the unirpcd socket listener. If the unirpcd is running then, you are most likely missing a configuration file that has the login credentials that uniobjects needs. uniobjects needs a server, user, password and account in order to successfully connect. Since you set up a brand new environment, I would check to see that the user that uniobjects was using on the old system is set up on the new system and that the connection information was migrated over. Now for the caveat: I come at this from a UniVerse background. In theory, uniobjects is the same for both UniVerse and UniData, but I could be all wrong. Regards, Raul Dominguez From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of JC Ocasio Sent: Thursday, June 11, 2009 10:35 AM To: 'u2-users@listserver.u2ug.org' Subject: [U2] Uni data / uni-objects connectivity To all: I'm fairly new to IBM universe and Unidata and have been tasked with upgrading our old PA-RISC to new Itaniums. Unfortunately we have little documentation on the configuration and setup of specific items on our UV database (as in unirpcd, uniobjects etc). In a recent dry test run, we encountered that several of our external websites could not connect to retrieve data. I was able to find unirpcd and get the daemon started, but I also need to get uniobjects running for some of our other applications. Where would I find this to get it running and or could someone point me in the right direction? As mentioned, I've never administered Universe before and my predecessors documentation is non-existent. Thanks in advance, Juan Carlos Ocasio CCNA Network Planning Manager Information Technology Department County of El Paso 800 E Overland, Rm 401 El Paso, TX 79901 (915) 546-2041 ext 3385 (915) 546-2042 Fax (915) 929-0630 Mobile mailto:jcoca...@epcounty.com Mailto:jcoca...@epcounty.com Envirionment info: HP-UX 11.31 Universe 10.2.11___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] passing file pointers?
Check out the FILEINFO function Raul - Original Message - From: Doug Chanco [EMAIL PROTECTED] Sent: 05/02/2008 04:21 PM AST To: u2-users@listserver.u2ug.org Subject: [U2] passing file pointers? Hey all, In universe 10.1 how can I verify that a file pointer passed via a subroutine param is valid? I have a subroutine that is called with several file pointers but it is possible to be called without opening a file and the subroutine would check if the file pointer is empty and if so open the file. The problem is that my check IF F.PTR = '' THEN Is erroring out with a invalid data type error message when the file pointer is passed in (instead of being null). I know that I can make all the calling programs open the needed files BEFORE calling the subroutine BUT if its possible to somehow have the subroutine check and open it if its (empty the file pointer), I would prefer to do that. Thoughts/suggestions welcome Thanks! dougc --- 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] Downloading and Installing RHEL Desktop 5.1 From Scratch
What program did you use to do the burn? You need something that can burn an image, like roxio. Raul Dominguez - Original Message - From: Dave Taylor [EMAIL PROTECTED] Sent: 04/19/2008 12:08 PM MST To: u2-users@listserver.u2ug.org Subject: [U2] Downloading and Installing RHEL Desktop 5.1 From Scratch Well, here it is Saturday morning and my long-anticipated weekend project of installing Universe on Linux has just come to a screeching halt. I downloaded RHEL 5.1 Desktop and burned the disk1 cd image to a CD-ROM using Windows XPPro. When I install the the CD-ROM on the new machine with only the CD-ROM drive designated as a bootable device, I get a message: Boot Error. System Halted. I tried to install it on my laptop and it failed to install there also. The CD-ROM drive read lite came on in both cases, so I believe that it's reading the CD-ROM but not finding what it expects to find. Using Explorer to view the download or the burned image, I see only one icon representing an unknown file type. I don't see any individual folders or files within the image. To fail this early in the process suggests that I'm doing something very wrong. Any suggestions? tia, Dave Dave Taylor Sysmark Information Systems, Inc. Authorized IBM Business Partner 49 Aspen Way Rolling Hills Estates, CA 90274 (O) 800-SYSMARK (800-797-6275) (F) 310-377-3550 (C) 310-561-5200 www.sysmarkinfo.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] TCL Command stacker
Try COMMAND.EDITOR ON ALL Raul - Original Message - From: Baker Hughes [EMAIL PROTECTED] Sent: 04/16/2008 10:14 AM EST To: 'u2-users@listserver.u2ug.org' u2-users@listserver.u2ug.org Subject: RE: [U2] TCL Command stacker David, Is there a switch to turn this on? When I try it I get this: COMMAND.EDITOR Command/Input editing switched off -Baker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hona, David S Sent: Tuesday, April 15, 2008 5:39 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] TCL Command stacker UniVerse 10.x has COMMAND.EDITOR, ported from PI/open but it is not officially supported nor documented by IBM. It has most, but not all the functionality of the PI/open version. --- 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] Indexes
At the universe tcl: SELECT REPAIR SAVING UNIQUE STOCK.ID Providing the the id to the STOCK file is in a field called STOCK.ID. Raul - Original Message - From: Dennis Bartlett [EMAIL PROTECTED] Sent: 03/14/2008 12:03 PM ZE2 To: u2-users@listserver.u2ug.org Subject: [U2] Indexes My dumb question for the day (just cant remember how to... and the manual's example is too simplistic...) How do I programmatically get an index value out, eg I have a STOCK file, and a REPAIRS file. Whoever designed this needs their head read, but the repairs file only has the stock code as a reference in the record. I have indexed the repair file on stock code, and need to create a report on the stock file of how many items are under repair. 1. UniverseBASIC code? 2. is this possible from an Itype? --- 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] Problem installing System Builder PE
I had a similar problem with UV 10.2 on Ubuntu Linux. The issue seems to be related to a quirk in the Linux version of the cpio command. I changed the command line to NOT include the c command line parameter. Try this: cpio -ivBdum instead of cpio -icvBdum Regards, Raul [EMAIL PROTECTED] wrote on 01/17/2008 02:47:04 PM: Ibm trying to install SB 5.4.1 PE on Fedora 8 and Ibm getting an error: sh-3.2# cpio -icvBdum pe_sb541_uv_cpio cpio: premature end of file Does anybody know what I can do to get this thing installed? I though perhaps the file was corrupted so I re-downloaded and tried it again and received the same error. Bob Little UniVerse Developer Market America 336-478-1694 --- 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] testing
Look for a directory called PH. Regards, Raul. Doug Chanco [EMAIL PROTECTED] deavors.com To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject RE: [U2] testing 12/24/07 11:13 AM Please respond to [EMAIL PROTECTED] er.u2ug.org A wonderous and happy holidays to all! If anyone happens to be reading this list , I do have one universe phantom question Is there anyway to see what a phantom did? At my last job there was a way to see phantom output (it wrote to a phantom log file, if you started the phantom with logging) Hopefully there is something similar in universe (10.1) Thanks, Dougc -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of gerry-u2ug Sent: Monday, December 24, 2007 10:34 AM To: u2-users@listserver.u2ug.org Subject: [U2] testing hohoho --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- This message has been scanned for viruses and dangerous content by SecureMail, and is believed to be clean. --- 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] anyone seen this error before?
What happens when you run the script using the same id from the shell prompt? What happens when you run the command from the TCL? - Original Message - From: Jerry Banker [EMAIL PROTECTED] Sent: 12/13/2007 03:54 PM CST To: u2-users@listserver.u2ug.org Subject: RE: [U2] anyone seen this error before? Unauthorized access to the tmp directory would be my first guess. The next would be that the select file was not created in the tmp directory because it ran out of room. Jerry Banker Sr Programmer Analyst Affiliated Acceptance Corp Sunrise Beach, MO 1-800-233-8483 www.affiliated.org -Original Message- From: Doug Chanco [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 2:49 PM To: u2-users@listserver.u2ug.org Subject: [U2] anyone seen this error before? We have a cron job that is having the below error, anyone have any ideas/suggestions/thoughts on what might be the issue and/or where I can start looking? I am going to look at the basic code and go from there 136550 record(s) selected to SELECT list #0. A fatal error has occurred in UniVerse. Unable to re-open operating system file Error code 2 Thanks! dougc --- 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] [UV] Can I get some advice on triggers?
Try this: CREATE TRIGGER filename.trigger BEFORE INSERT OR UPDATE OR DELETE ON filename FOR EACH ROW CALLING some.subroutine; Note the semi-colon at the end (;). It is very important. Regards, Raul. Keith Johnson (DSLWN) [EMAIL PROTECTED] To o.nz u2-users@listserver.u2ug.org Sent by: cc [EMAIL PROTECTED] stserver.u2ug.org Subject [U2] [UV] Can I get some advice on triggers? 11/27/07 12:20 AM Please respond to [EMAIL PROTECTED] er.u2ug.org Hi, I'm hoping someone can give me some help on triggers. I want to put a trigger on a file to datestamp address changes. The system manual (25119270.pdf) says that triggers aer set up by the command CREATE TRIGGER trigger.name [BEFORE|AFTER|UPDATE] But when I try that I get an SQL prompt. We don't use SQL at all - is there some way of setting up triggers without it? Is there another manual I should look at? Thanks, Keith. --- 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] Cool stuff for a Friday
I use an Apple iMac at the house running Leopard and Parallels for the VM. I have an Ubuntu partition that I run UniVerse 10.2 PE (Server) on and a second partition to run Windows XP (U2 Clients). Everything seems to run fine for me. But I am not beating the machine up. On the Apple OS side: * I use an FTP client called Transmit that works nicely and understands my OpenSSH keys. * I do not use Skype, but there is a client for the Mac at http://www.skype.com/download/skype/macosx/ * I do not use GoToMeeting so I cannot provide more insight there. Now, at work I use a MacBook Pro running Tiger and Parallels. This machine gets a lot of use. Memory configuration is the same and I do wish I had gone ahead and ordered more RAM. It runs well with 2GB, but I believe it would run better with 4GB. I use Windows XP for the U2 Clients, but connect to our AIX server for UniVerse. I have not had any issues specifically related to using the Apple hardware. As far as the Apple OS software that I run, I use the Transmit package to do my file transfers (mostly SFTP) and I use a package called Subethaedit to do coding. The biggest difficulty was setting up the syntax highlighting on Subethaedit. All in all, I find that very little of my time is spent on the Windows XP VM because most of the time, I am coding. The only real heavy task that I use the U2 Clients for is the XMLDB tool. Windows XP is quite snappy running under the VM. I am OK using it for development, but I would not want to play video games that way. Regards, Raul Dominguez [EMAIL PROTECTED] wrote on 11/23/2007 12:33:58 PM: This reminds me of a question I've been wanting to ask. Does anyone use an Apple (the new leopard O/S with a VM for Windows)? I've been thinking of buying one for my next PC purchase. I need Windows for .NET development, AccuTerm, U2 and mv.NET administration tools, and possibly other stuff. I wonder if I can get Skype, a SFTP client, GoToMeeting, and any other useful stuff, to replace Windows software, for Apple. Bill --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/