RE: [U2] Passing of Bruce Nichol - Talon Computer Services
Bill H wrote: RIP. :-( Or, more appropriately for Bruce: ... Bugger! -Original Message- From: Ross Ferris I have just learned that Bruce Nichol of Talon Computer Services (Albury/NSW/Australia), a frequent contributor to this forum long time pick advocate, has passed away. He will be sorely missed Indeed he will be. Always an intelligent, if colourful, contributor to both this list and to cdp. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Passing of Bruce Nichol - Talon Computer Services
Goo'day Bruce, Vale -Original Message- I have just learned that Bruce Nichol of Talon Computer Services (Albury/NSW/Australia), a frequent contributor to this forum long time pick advocate, has passed away. He will be sorely missed ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this communication in error, please reply to this e-mail to notify the sender of its incorrect delivery and then delete it and your reply. It is your responsibility to check this email and any attachments for viruses and defects before opening or sending them on. Spotless collects information about you to provide and market our services. For information about use, disclosure and access, see our privacy policy at http://www.spotless.com.au Please consider our environment before printing this email. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Universe position
Universe AP position available. GPM are a specialist software house based in Croydon (South London). We require someone with good Universe expertise to complement the existing development team. Knowledge of Uniobjects and Visual Basic would be a distinct advantage. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] New to UV/PICK, programming a banner
Hi Gabe I see you posted to comp.databases.pick as well and that you got a rather rude reply from tronic - he is a known poster on there who is somewhat deranged so don't take offence. Many posters on there filter out replies from tronic or his other guises. Welcome to MV I am sure you will find most of us very helpful. Rgds Symeon. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gabriel Green Sent: 25 March 2007 11:11 To: u2-users@listserver.u2ug.org Subject: Re: [U2] New to UV/PICK, programming a banner Nevermind, I did some digging and found out it has to be a file called UV.LOGIN in the VOC of the UV account. Done. Thanks much. I'm new here, I am the IT person for an automotive company with custom software built on UniVerse and with my employer and our software developer's blessing am learning PICK. I must say I'm having a lot of fun with this--an incredible tool that no one's heard of, but very powerful Well, thanks for your help and I'll be hanging around these lists... Gabe On 3/25/07, Louis Windsor [EMAIL PROTECTED] wrote: Simply:- ED BP MOTD I Enter OPEN 'file' TO file THEN READ MOTD FROM file,'MOTD' THEN CNT=DCOUNT(MOTD,@FM) FOR X=1 TO CNT; CRT MOTDX; EXT X CRT; CRT 'Read and Press Enter To Continue'; INPUT WHATEVER: STOP END ELSE CRT; CRT 'No Message Of The Day'; CRT; STOP END END ELSE CRT; CRT 'No MOTD File'; CRT; STOP END Enter FI file is whatever file you wish to use even TEMP or CTL (general control file)? Compile and include line RUN BP MOTD in your LOGIN paragraph To create the message:- ED file MOTD (or wED or whatever editor) I Type whatever message you want to display here Enter FI To delete the message ED file MOTD FD Like I said it is simple. Assumes the message is less than a screen full and each line is less than screen width. No flames please - I said it is simple. Louis - Original Message - From: Gabriel Green [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Sunday, March 25, 2007 12:38 PM Subject: [U2] New to UV/PICK, programming a banner Hello, I am new to PICK/UniVerse and was wondering if someone could help me with some BASIC code or a PROC instructions to get me going on a banner program that will display before, or after, the Logon Please: prompt (but after the initial telnet server login). Preferrably I'd like a unix style /etc/motd type thing (we're on Windows of course so that is not available, UV 10.2.) that I could update periodically with wED and update for our users to see. Can anyone help with this? Thanks, Gabe --- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] New to UV/PICK, programming a banner
No offense, but look again. I didn't STOP but did a STOPM which prints a quoted message to standard out. One can compose the message in any format containing any information desired. Now I don't know if .NET will accept that, but I bet it does. We still use green-screen here. Karl quote who=Brian Leach Karl Just one problem with that technique. If you do this inside a subroutine (and I DO see people use STOP inside subroutines all too often) you're locking into a legacy terminal environment. Call that from e.g. .NET and the subroutine stops - but you don't get any message back as to why. It's one more thing to refactor when changing front end clients. For some interfaces it will even break the session. So the lesson is - and I'm not suggesting that anyone on this list would do this - don't use STOP (or even worse, ABORT) inside a subroutine. If you're opening files inside a subroutine, just RETURN with a suitable error message. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 25 March 2007 16:57 To: u2-users@listserver.u2ug.org Subject: Re: [U2] New to UV/PICK, programming a banner Precisely why I use uniVerse's stopm directive: open '','FILE' to FILE else stopm 'No FILE File!' It's a simple oneliner that tells you all you need to know upon failure. Karl --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Passing of Bruce Nichol - Talon Computer Services
Have seen the name many times, was it natural of accidental? Give my sympathies to his family. Jerry - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, March 26, 2007 1:55 AM Subject: Spam:RE: [U2] Passing of Bruce Nichol - Talon Computer Services Bill H wrote: RIP. :-( Or, more appropriately for Bruce: ... Bugger! -Original Message- From: Ross Ferris I have just learned that Bruce Nichol of Talon Computer Services (Albury/NSW/Australia), a frequent contributor to this forum long time pick advocate, has passed away. He will be sorely missed Indeed he will be. Always an intelligent, if colourful, contributor to both this list and to cdp. --- 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] Passing of Bruce Nichol - Talon Computer Services
Hi Jerry, Have seen the name many times, was it natural of accidental? As far as we know, it was as a result a long illness. Bruce had been in hospital for some time but was back out and appeared to be on the mend. All news so far has come via Bruce's clients. Martin Phillips, Ladybridge Systems Ltd --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] New to UV/PICK, programming a banner
Karl Sorry but I think you missed the point. Any messages to green screen - including STOPM messages - aren't fed back to .NET or any other client environment over a UniObjects subroutine call. And on RedBack a STOP (of any description) also used to terminate the responder - not sure if it still does as I avoid that in my code. Hence my words of caution. Using STOP (or STOPM) inside a subroutine can have unintended consequences if someone later tries to call that subroutine from another environment. Inside a program is different since it can be captured in the response property of a UniCommand object. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 26 March 2007 15:08 To: u2-users@listserver.u2ug.org Subject: RE: [U2] New to UV/PICK, programming a banner No offense, but look again. I didn't STOP but did a STOPM which prints a quoted message to standard out. One can compose the message in any format containing any information desired. Now I don't know if .NET will accept that, but I bet it does. We still use green-screen here. Karl quote who=Brian Leach Karl Just one problem with that technique. If you do this inside a subroutine (and I DO see people use STOP inside subroutines all too often) you're locking into a legacy terminal environment. Call that from e.g. .NET and the subroutine stops - but you don't get any message back as to why. It's one more thing to refactor when changing front end clients. For some interfaces it will even break the session. So the lesson is - and I'm not suggesting that anyone on this list would do this - don't use STOP (or even worse, ABORT) inside a subroutine. If you're opening files inside a subroutine, just RETURN with a suitable error message. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 25 March 2007 16:57 To: u2-users@listserver.u2ug.org Subject: Re: [U2] New to UV/PICK, programming a banner Precisely why I use uniVerse's stopm directive: open '','FILE' to FILE else stopm 'No FILE File!' It's a simple oneliner that tells you all you need to know upon failure. Karl --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- 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] Passing of Bruce Nichol - Talon Computer Services
This is sad to hear. When his obit appears in the paper, perhaps Ross or one of our friends down under will send us the link? peace on his family and friends, -Baker -Original Message- From: Ross Ferris I have just learned that Bruce Nichol of Talon Computer Services (Albury/NSW/Australia), a frequent contributor to this forum long time pick advocate, has passed away. He will be sorely missed --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: Spam:RE: [U2] New to UV/PICK, programming a banner
The way I was taught you use a STOP of any kind only when you really want a process to stop. Otherwise, use a RETURN when calling as a subroutine from a program or running a program from a PROC or Paragraph. I have seen programs stop a PROC by using STOP instead of RETURN. Can't remember what the circumstances were but it did happen. Jerry - Original Message - From: Brian Leach [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, March 26, 2007 10:41 AM Subject: Spam:RE: [U2] New to UV/PICK, programming a banner Karl Sorry but I think you missed the point. Any messages to green screen - including STOPM messages - aren't fed back to .NET or any other client environment over a UniObjects subroutine call. And on RedBack a STOP (of any description) also used to terminate the responder - not sure if it still does as I avoid that in my code. Hence my words of caution. Using STOP (or STOPM) inside a subroutine can have unintended consequences if someone later tries to call that subroutine from another environment. Inside a program is different since it can be captured in the response property of a UniCommand object. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 26 March 2007 15:08 To: u2-users@listserver.u2ug.org Subject: RE: [U2] New to UV/PICK, programming a banner No offense, but look again. I didn't STOP but did a STOPM which prints a quoted message to standard out. One can compose the message in any format containing any information desired. Now I don't know if .NET will accept that, but I bet it does. We still use green-screen here. Karl quote who=Brian Leach Karl Just one problem with that technique. If you do this inside a subroutine (and I DO see people use STOP inside subroutines all too often) you're locking into a legacy terminal environment. Call that from e.g. .NET and the subroutine stops - but you don't get any message back as to why. It's one more thing to refactor when changing front end clients. For some interfaces it will even break the session. So the lesson is - and I'm not suggesting that anyone on this list would do this - don't use STOP (or even worse, ABORT) inside a subroutine. If you're opening files inside a subroutine, just RETURN with a suitable error message. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 25 March 2007 16:57 To: u2-users@listserver.u2ug.org Subject: Re: [U2] New to UV/PICK, programming a banner Precisely why I use uniVerse's stopm directive: open '','FILE' to FILE else stopm 'No FILE File!' It's a simple oneliner that tells you all you need to know upon failure. Karl --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- 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] New to UV/PICK, programming a banner
Very Good Point. You know as I do that in the green screen world, if a file can't be opened, we don't want the program to go any farther. Something's very bad and if it just continues, we have a major potential for data corruption. That was the point I feebly attempted .. .. .. Karl quote who=Brian Leach Karl Sorry but I think you missed the point. Any messages to green screen - including STOPM messages - aren't fed back to .NET or any other client environment over a UniObjects subroutine call. And on RedBack a STOP (of any description) also used to terminate the responder - not sure if it still does as I avoid that in my code. Hence my words of caution. Using STOP (or STOPM) inside a subroutine can have unintended consequences if someone later tries to call that subroutine from another environment. Inside a program is different since it can be captured in the response property of a UniCommand object. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 26 March 2007 15:08 To: u2-users@listserver.u2ug.org Subject: RE: [U2] New to UV/PICK, programming a banner No offense, but look again. I didn't STOP but did a STOPM which prints a quoted message to standard out. One can compose the message in any format containing any information desired. Now I don't know if .NET will accept that, but I bet it does. We still use green-screen here. Karl quote who=Brian Leach Karl Just one problem with that technique. If you do this inside a subroutine (and I DO see people use STOP inside subroutines all too often) you're locking into a legacy terminal environment. Call that from e.g. .NET and the subroutine stops - but you don't get any message back as to why. It's one more thing to refactor when changing front end clients. For some interfaces it will even break the session. So the lesson is - and I'm not suggesting that anyone on this list would do this - don't use STOP (or even worse, ABORT) inside a subroutine. If you're opening files inside a subroutine, just RETURN with a suitable error message. Brian -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 25 March 2007 16:57 To: u2-users@listserver.u2ug.org Subject: Re: [U2] New to UV/PICK, programming a banner Precisely why I use uniVerse's stopm directive: open '','FILE' to FILE else stopm 'No FILE File!' It's a simple oneliner that tells you all you need to know upon failure. Karl --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- 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/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Passing of Bruce Nichol - Talon Computer Services
Being from the other side of the world, I didn't know him, except via this newfangled cyber-community. Whenever I saw that he posted, I knew it'd be worth reading. I see from our archives that he posted here about 200 times in the past three years. Google says another 130 to CDP. A contributor. If the moderator will graciously allow just one Monty Python reference, I always hoped there'd be a thread between him and one or more other Bruces. Even if they weren't all Aussies, Mr. Nichol would have given the exchange authenticity. I don't recall it ever happened. Thank-you, Ross Ferris, for informing us. Perhaps you could give this list's rememberances and sympathies to his family. If his family is like most of ours, they proably have little appreciation of the computer stuff he did or his significance here. My sympathies to those of you who were his friends. Chuck Stevenson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - Transaction Logging - Stale Transactions
Are you using logical transactions? I.e., basic TRANSACTION START/COMMIT? Or SQL SELECT? That will automatically start a transaction (on 10.0.16 anyway) and hold it open until the SELECT ends, even tho no updates occur. If logs fill while a logical transaction is in process, the log will remain in NeedSynch state. That's my 1st guess. Cds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns Sent: Sunday, March 25, 2007 4:19 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV - Transaction Logging - Stale Transactions Late last year we upgraded from UV 10.0.11 on AIX to UV 10.1.16 on Red Hat Linux. At the same time we implemented Transaction Logging. We have a dispersed network with users throughout the country at about 40 sites using VOIP for our data and voice transmission. These sessions do sometimes get dropped due to network glitches and users do sometimes terminate their sessions without logging off correctly. All has gone reasonably smoothly but we are finding that we sometimes get Stale Transactions. This means that all subsequent transaction logs are in the NeedSync state and the Available log files may be exhausted - at which stage everything stops. We have now got a large pool of log files available. Does anyone have any hints to investigate what is causing the Stale Transaction so that it can be corrected so all logs can be Released ready for reuse. We have found that on at least one occasion they did free themselves but we usually require a restart of UniVerse to get the process working again. We do have a scheduled restart at midnight while we obtain a snapshot. This is obviously releasing something we cannot see. It would be preferable to be able to remove the cause so a consistent set of logs can be created as these are also sent to our DR site. The manual indicates that when you re-enable transaction logging you will be asked if you wish to terminate pending (prepared) stale transactions. In our case we now have so many log files the process has not stopped. Due to our many dependant systems, internal and external, it is undesirable to Disable the Transaction Logging system during active use. This would be a last resort. In the latest episode there were no entries in the lock tables, no semaphores set and we cleaned out every process we could find that was not us or the various uv daemons. Any suggestions would be appreciated. Sara Burns (SEB) IS Development Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 029 978 4534 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The information contained in this communication (including any attachment) is confidential. If you are not the intended recipient, please destroy this communication. You must not disclose, copy or use in any way the information contained in this communication. Any views expressed in this communication are not necessarily the views of Public Trust. No representation is made that this communication is free of error, virus or interference. . --- 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] UniVerse I-descriptor Help
REPOSTED FOR NON-MEMBER: Laure Hansen [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Hello, I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division between a multi-value field and a single-value one, in an I-descriptor (UV 10.1). My MV field is named CONS, my single value one is names UNITS, the formula is CONS / REUSE(UNITS). The result will obviously be a multi-value. If the result is an integer, I want it as is. When it's not, I want it rounded up to the nearest integer. The data must be examined value by value. CONS and UNITS both are integers. Thanks in advance! Laure Hansen, City of Redwood City Information Technology www.redwoodcity.org http://www.redwoodcity.org/ 1017 Middlefield Road Redwood City, CA 94063 Tel: 650-780-7087 Fax: 650-556-9204 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse I-descriptor Help
-Original Message- I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division between a multi-value field and a single-value one, in an I-descriptor (UV 10.1). My MV field is named CONS, my single value one is names UNITS, the formula is CONS / REUSE(UNITS). The result will obviously be a multi-value. I don't know Universe I-descriptors, but can you say INT((CONS + 0.5) / REUSE(UNITS)) === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === I still say a church steeple with a lightning rod on top shows a lack of confidence. === --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - Transaction Logging - Stale Transactions
Sara, We had occasional instances of this in the past. We finally tracked the cause down to one of our developers copying transaction logging-enabled files between servers without disabling them first. Not sure if this is happening in your case. Hope this helps. Perry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Monday, March 26, 2007 1:26 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV - Transaction Logging - Stale Transactions Are you using logical transactions? I.e., basic TRANSACTION START/COMMIT? Or SQL SELECT? That will automatically start a transaction (on 10.0.16 anyway) and hold it open until the SELECT ends, even tho no updates occur. If logs fill while a logical transaction is in process, the log will remain in NeedSynch state. That's my 1st guess. Cds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns Sent: Sunday, March 25, 2007 4:19 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV - Transaction Logging - Stale Transactions Late last year we upgraded from UV 10.0.11 on AIX to UV 10.1.16 on Red Hat Linux. At the same time we implemented Transaction Logging. We have a dispersed network with users throughout the country at about 40 sites using VOIP for our data and voice transmission. These sessions do sometimes get dropped due to network glitches and users do sometimes terminate their sessions without logging off correctly. All has gone reasonably smoothly but we are finding that we sometimes get Stale Transactions. This means that all subsequent transaction logs are in the NeedSync state and the Available log files may be exhausted - at which stage everything stops. We have now got a large pool of log files available. Does anyone have any hints to investigate what is causing the Stale Transaction so that it can be corrected so all logs can be Released ready for reuse. We have found that on at least one occasion they did free themselves but we usually require a restart of UniVerse to get the process working again. We do have a scheduled restart at midnight while we obtain a snapshot. This is obviously releasing something we cannot see. It would be preferable to be able to remove the cause so a consistent set of logs can be created as these are also sent to our DR site. The manual indicates that when you re-enable transaction logging you will be asked if you wish to terminate pending (prepared) stale transactions. In our case we now have so many log files the process has not stopped. Due to our many dependant systems, internal and external, it is undesirable to Disable the Transaction Logging system during active use. This would be a last resort. In the latest episode there were no entries in the lock tables, no semaphores set and we cleaned out every process we could find that was not us or the various uv daemons. Any suggestions would be appreciated. Sara Burns (SEB) IS Development Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 029 978 4534 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The information contained in this communication (including any attachment) is confidential. If you are not the intended recipient, please destroy this communication. You must not disclose, copy or use in any way the information contained in this communication. Any views expressed in this communication are not necessarily the views of Public Trust. No representation is made that this communication is free of error, virus or interference. . --- 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/ 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/
RE: [U2] Passing of Bruce Nichol - Talon Computer Services
Condolences to Bruce's friends and family. I've had quite a few entertaining e-discussions with Bruce over the past years, but never got a chance to met him in person. Every time I see a posting about someone in the MV community passing away, it reminds me that I don't have an eternity to get things straight in my own little sphere. Ross, if you get any additional information, feel free to post it on PickSource. http://www.picksource.com I'm also willing to work with you to setup a community funds source if the family can use it. I can accept payments via e-check, paypal, and credit card into my seller paypal account. I'll start with a donation myself if that'll get things moving. Regards, --- Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 e-mail: [EMAIL PROTECTED] --- www.allspec.com --- -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Ross Ferris Sent: Sunday, March 25, 2007 5:55 PM To: u2-users@listserver.u2ug.org Subject: [U2] Passing of Bruce Nichol - Talon Computer Services I have just learned that Bruce Nichol of Talon Computer Services (Albury/NSW/Australia), a frequent contributor to this forum long time pick advocate, has passed away. He will be sorely missed Ross Ferris Stamina Software Visage Better by Design! --- 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] DB.TOXML and XMAP problem
I'm using UV10.1 in PICK flavor and having trouble linking one TABLECLASSMAP to another to output a field from related file. I set up the XMAP using the XMLDB tool and everything works fine, no errors, except there is no output from TABLECLASSMAP M2 and M3 in the example below. By no output, I mean that the tags don't even print. Everything else is being output to XML exactly the way it is specified. If someone can point me in the right direction, explain how TableMap works and the relationship to RelatedTable or anything else, I'd greatly appreciate it. Thanks a bunch - -Scott Teixeira For the example, PHYSICIAN_CODE is in the PATIENTS file in attribute 1, which is the key to the PHYSICIANS file (@ID), and the physician first name and last name are in attributes 1 and 2 in the PHYSICIANS file. Diagnosis codes are multivalued and in attribute 2 of the PATIENTS file, which are the keys for the DIAGNOSIS.CODES file (@ID). The diagnosis description is in attribute 1 of the DIAGNOSIS.FILE. ?xml version=1.0 ? !-- DOCTYPE U2XMAP SYSTEM U2XMAP.DTD -- U2XMAP version=1.0 Name=PATIENT.map XSD=PATIENT.xsd OPTIONS EmptyString IsNull=ON / DateFormat Format=DYMD[4,2,2] / ExistRecord Action=Default/ /OPTIONS !-- Table/Class map PATIENTS_Patient -- TABLECLASSMAP MapName=M1 StartNode=Patients/Patient TableName=PATIENTS ColumnMap Node=PatientName/FirstName Column=FIRST_NAME/ ColumnMap Node=PatientName/LastName Column=LAST_NAME/ ColumnMap Node=PatientName/MiddleName Column=MIDDLE_INITIAL/ ColumnMap Node=Location/Room Column=ROOM/ ColumnMap Node=Location/Bed Column=BED/ ColumnMap Node=PatientVisit/Prescriber/ID Column=PHYSICIAN_CODE/ TableMap Node=PatientVisit/Prescriber/Name MapName=M2/ ColumnMap Node=Diagnoses/Diagnosis,Code Column=DIAGNOSIS_CODE/ TableMap Node=Diagnoses/Diagnosis MapName=M3/ /TABLECLASSMAP !-- Table/Class map PHYSICIANS_Prescriber -- TABLECLASSMAP MapName=M2 StartNode=PatientVisit/Prescriber/Name TableName=PHYSICIANS ColumnMap Node=FirstName Column=FIRST_NAME/ ColumnMap Node=LastName Column=LAST_NAME/ /TABLECLASSMAP !-- Table/Class map DIAGNOSIS.CODES_Description -- TABLECLASSMAP MapName=M3 StartNode=Diagnoses/Diagnosis TableName=DIAGNOSIS.CODES ColumnMap Node=Description Column=DIAGNOSIS_DESCRIPTION/ /TABLECLASSMAP RelatedTable MapParentKey TableName=PATIENTS Column=PHYSICIAN_CODE KeyGenerate=NO/ MapChildKey TableName=PHYSICIANS Column=@ID/ /RelatedTable RelatedTable MapParentKey TableName=PATIENTS Column=DIAGNOSIS_CODE KeyGenerate=NO/ MapChildKey TableName=DIAGNOSIS.CODES Column=@ID/ /RelatedTable /U2XMAP - -- NOTICE -- This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify the sender and delete this e-mail message from your computer. Thank you. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: Spam:[U2] Universe I-descriptor help
INT((CONS / REUSE(UNITS)) + 0.5) - Original Message - From: IT-Laure Hansen [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, March 26, 2007 1:00 PM Subject: Spam:[U2] Universe I-descriptor help Hello, I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division between a multi-value field and a single-value one, in an I-descriptor (UV 10.1). My MV field is named CONS, my single value one is names UNITS, the formula is CONS / REUSE(UNITS). The result will obviously be a multi-value. If the result is an integer, I want it as is. When it's not, I want it rounded up to the nearest integer. The data must be examined value by value. CONS and UNITS both are integers. Thanks in advance! Laure Hansen, City of Redwood City Information Technology www.redwoodcity.org http://www.redwoodcity.org/ 1017 Middlefield Road Redwood City, CA 94063 Tel: 650-780-7087 Fax: 650-556-9204 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] --- 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] UniVerse I-descriptor Help
i feel it should be INT(CONS/REUSE(UNITS)+ 0.5) Thanks, Somanshu Baghel - Original Message From: Norman Morgan [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, March 26, 2007 11:52:25 PM Subject: RE: [U2] UniVerse I-descriptor Help -Original Message- I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division between a multi-value field and a single-value one, in an I-descriptor (UV 10.1). My MV field is named CONS, my single value one is names UNITS, the formula is CONS / REUSE(UNITS). The result will obviously be a multi-value. I don't know Universe I-descriptors, but can you say INT((CONS + 0.5) / REUSE(UNITS)) === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === I still say a church steeple with a lightning rod on top shows a lack of confidence. === --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ Need Mail bonding? Go to the Yahoo! Mail QA for great tips from Yahoo! Answers users. http://answers.yahoo.com/dir/?link=listsid=396546091 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse I-descriptor Help
i feel it should be INT(CONS/REUSE(UNITS)+ 0.5) You are correct, of course. I rounded in the wrong place. === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === The Queue Principle: The longer you wait in line, the greater The likelihood that you are standing in the wrong line. === -Original Message- -Original Message- I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division between a multi-value field and a single-value one, in an I-descriptor (UV 10.1). My MV field is named CONS, my single value one is names UNITS, the formula is CONS / REUSE(UNITS). The result will obviously be a multi-value. I don't know Universe I-descriptors, but can you say INT((CONS + 0.5) / REUSE(UNITS)) --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV - Transaction Logging - Stale Transactions
Same kind of problem as with indexes.( I.e, the path to the index is part of the file header. If the primary data file is copied, the duplicate is still indexing on the old index until you use SET.INDEX to correct it.I think there's a UV enhancement request for allowing index pathnames to be relative instead of absolute path.) Which brings us to a need for a tool to verify possibly correct the log numbers in UV.TRANS and the UV.TRANS id (info buried in the file headers themselves.) There is a need for flexability, especially after some kind of disaster and file systems are being rebuilt. There is a enhancement request in the works on this too. cds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Perry Taylor Sent: Monday, March 26, 2007 11:41 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV - Transaction Logging - Stale Transactions Sara, We had occasional instances of this in the past. We finally tracked the cause down to one of our developers copying transaction logging-enabled files between servers without disabling them first. Not sure if this is happening in your case. Hope this helps. Perry -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Stevenson, Charles Sent: Monday, March 26, 2007 1:26 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV - Transaction Logging - Stale Transactions Are you using logical transactions? I.e., basic TRANSACTION START/COMMIT? Or SQL SELECT? That will automatically start a transaction (on 10.0.16 anyway) and hold it open until the SELECT ends, even tho no updates occur. If logs fill while a logical transaction is in process, the log will remain in NeedSynch state. That's my 1st guess. Cds -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sara Burns Sent: Sunday, March 25, 2007 4:19 PM To: u2-users@listserver.u2ug.org Subject: [U2] UV - Transaction Logging - Stale Transactions Late last year we upgraded from UV 10.0.11 on AIX to UV 10.1.16 on Red Hat Linux. At the same time we implemented Transaction Logging. We have a dispersed network with users throughout the country at about 40 sites using VOIP for our data and voice transmission. These sessions do sometimes get dropped due to network glitches and users do sometimes terminate their sessions without logging off correctly. All has gone reasonably smoothly but we are finding that we sometimes get Stale Transactions. This means that all subsequent transaction logs are in the NeedSync state and the Available log files may be exhausted - at which stage everything stops. We have now got a large pool of log files available. Does anyone have any hints to investigate what is causing the Stale Transaction so that it can be corrected so all logs can be Released ready for reuse. We have found that on at least one occasion they did free themselves but we usually require a restart of UniVerse to get the process working again. We do have a scheduled restart at midnight while we obtain a snapshot. This is obviously releasing something we cannot see. It would be preferable to be able to remove the cause so a consistent set of logs can be created as these are also sent to our DR site. The manual indicates that when you re-enable transaction logging you will be asked if you wish to terminate pending (prepared) stale transactions. In our case we now have so many log files the process has not stopped. Due to our many dependant systems, internal and external, it is undesirable to Disable the Transaction Logging system during active use. This would be a last resort. In the latest episode there were no entries in the lock tables, no semaphores set and we cleaned out every process we could find that was not us or the various uv daemons. Any suggestions would be appreciated. Sara Burns (SEB) IS Development Manager Public Trust Phone: +64 (04) 978 4534 (DDI) Mobile: 029 978 4534 mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The information contained in this communication (including any attachment) is confidential. If you are not the intended recipient, please destroy this communication. You must not disclose, copy or use in any way the information contained in this communication. Any views expressed in this communication are not necessarily the views of Public Trust. No representation is made that this communication is free of error, virus or interference. . --- 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/ 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
[U2] Universe I-descriptor help
Hello, I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division between a multi-value field and a single-value one, in an I-descriptor (UV 10.1). My MV field is named CONS, my single value one is names UNITS, the formula is CONS / REUSE(UNITS). The result will obviously be a multi-value. If the result is an integer, I want it as is. When it's not, I want it rounded up to the nearest integer. The data must be examined value by value. CONS and UNITS both are integers. Thanks in advance! Laure Hansen, City of Redwood City Information Technology www.redwoodcity.org http://www.redwoodcity.org/ 1017 Middlefield Road Redwood City, CA 94063 Tel: 650-780-7087 Fax: 650-556-9204 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Universe I-descriptor help
isnt there an iconvs oconvs SUBR routine ? I dont have manuals or pdf's available at the moment Rich IT-Laure Hansen wrote: Hello, I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division between a multi-value field and a single-value one, in an I-descriptor (UV 10.1). My MV field is named CONS, my single value one is names UNITS, the formula is CONS / REUSE(UNITS). The result will obviously be a multi-value. If the result is an integer, I want it as is. When it's not, I want it rounded up to the nearest integer. The data must be examined value by value. CONS and UNITS both are integers. Thanks in advance! Laure Hansen, City of Redwood City Information Technology www.redwoodcity.org http://www.redwoodcity.org/ 1017 Middlefield Road Redwood City, CA 94063 Tel: 650-780-7087 Fax: 650-556-9204 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Richard A. Wilson Lakeside Systems Smithfield, RI, USA Voice 401-231-3959 Fax 206-202-2064 [EMAIL PROTECTED] www.lakeside-systems.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse I-descriptor Help
Actually, I think you would need to use the REUSE function on the 0.5 also; otherwise the 0.5 will be added to only the first value in the intermediate result of CONS/REUSE(UNITS). INT(CONS/REUSE(UNITS)+REUSE(0.5)) However, on the old version of UniVerse I'm using, the INT function does not work with a multivalued argument and gives an error message. What I would use instead is the OCONVS function, which is the multivalued version of OCONV: OCONVS(CONS/REUSE(UNITS)+REUSE(0.5),'MD0') Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Norman Morgan Sent: Monday, March 26, 2007 3:34 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse I-descriptor Help i feel it should be INT(CONS/REUSE(UNITS)+ 0.5) You are correct, of course. I rounded in the wrong place. === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === The Queue Principle: The longer you wait in line, the greater The likelihood that you are standing in the wrong line. === -Original Message- -Original Message- I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division between a multi-value field and a single-value one, in an I-descriptor (UV 10.1). My MV field is named CONS, my single value one is names UNITS, the formula is CONS / REUSE(UNITS). The result will obviously be a multi-value. I don't know Universe I-descriptors, but can you say INT((CONS + 0.5) / REUSE(UNITS)) --- 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] PRINTERS getting set up using Jet Direct/AIX
Anyone know the appropriate steps to setting up a new network printer using Jet Direct with AIX under Universe? Thanks and a tip of the hat to any daring responders, Will --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse I-descriptor Help
You are also going to need the INT function that operates on multi-values, !INTS. __ From: Moderator [EMAIL PROTECTED] Reply-To: u2-users@listserver.u2ug.org To: u2-users@listserver.u2ug.org Subject: [U2] UniVerse I-descriptor Help Date: Mon, 26 Mar 2007 14:04:44 -0400 REPOSTED FOR NON-MEMBER: Laure Hansen [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Hello, I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division between a multi-value field and a single-value one, in an I-descriptor (UV 10.1). My MV field is named CONS, my single value one is names UNITS, the formula is CONS / REUSE(UNITS). The result will obviously be a multi-value. If the result is an integer, I want it as is. When it's not, I want it rounded up to the nearest integer. The data must be examined value by value. CONS and UNITS both are integers. Thanks in advance! Laure Hansen, City of Redwood City Information Technology www.redwoodcity.org http://www.redwoodcity.org/ 1017 Middlefield Road Redwood City, CA 94063 Tel: 650-780-7087 Fax: 650-556-9204 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ _ Watch free concerts with Pink, Rod Stewart, Oasis and more. Visit MSN Presents today. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: Spam:[U2] Universe I-descriptor help
Thanks everyone for the formula. I should have waited until the caffeine kicked in. But I'm still having problems, and this I am guessing is strictly a Universe I-descriptor question. Looks like the system is not treating things value by value on calculating INT. I am getting a non numeric data when required error. As soon as I get rid of INT, the I-descriptor is capable of using value by value properly. There is no INTS (just like there is a OCONVS etc). Does anyone know how to handle this in multi-value fields? Thanks again. Laure Hansen, City of Redwood City Information Technology www.redwoodcity.org 1017 Middlefield Road Redwood City, CA 94063 Tel: 650-780-7087 Fax: 650-556-9204 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Sent: Monday, March 26, 2007 12:21 PM To: u2-users@listserver.u2ug.org Subject: Re: Spam:[U2] Universe I-descriptor help INT((CONS / REUSE(UNITS)) + 0.5) - Original Message - From: IT-Laure Hansen [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, March 26, 2007 1:00 PM Subject: Spam:[U2] Universe I-descriptor help Hello, I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division between a multi-value field and a single-value one, in an I-descriptor (UV 10.1). My MV field is named CONS, my single value one is names UNITS, the formula is CONS / REUSE(UNITS). The result will obviously be a multi-value. If the result is an integer, I want it as is. When it's not, I want it rounded up to the nearest integer. The data must be examined value by value. CONS and UNITS both are integers. Thanks in advance! Laure Hansen, City of Redwood City Information Technology www.redwoodcity.org http://www.redwoodcity.org/ 1017 Middlefield Road Redwood City, CA 94063 Tel: 650-780-7087 Fax: 650-556-9204 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] --- 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] PRINTERS getting set up using Jet Direct/AIX
Daring? I think not... Just available First, create a driver using smit, or if you are very brave, edit /etc/qdaemon and manually add a printer there... Okay, use smit. Get to the spooler section, and add a new spooler. Create a remote printer by entering a queue name after you select a filtering/pre-filtering method. You may have to play with the those options to get the printer to work. Different printers need different massaging at the OS level to work appropriately. Put the IP address in, or the printer name if it's under your DNServer that way. Add the port as the name of the queue on the remote host. For Jetdirects, you can use 9100 or RAW1, 9101, RAW2, etc. Select the types of other things, such as page width/height, which is crucial if you are going to send PCL to the printer. Second, create a driver in AIX (I put mine in /u1/uvptr/drvrname) that has one of the following two lines: lp -dqueuename lpr -h -Pqueuename where queuename is from the first step. Naming conventions change from server to server, but I try to give mine a descriptive, yet short name. I.e.: crhp is short for the computer room HP... Make that file executable. I named mine things like crhp.drv. Enter uniVerse and create a device in the UV Admin menus. Give it an upper-case name similar to the unix queue name so you can track it easier. In the device line put /dev/null and and in the driver line put the path/name of the .drvr file you created and made executable. Enter through the rest and then test it. If it 'stair-steps' you will have to play with settings either in AIX, or uniVerse. I test mine in AIX first and if they don't stair-step there, I can adjust the uniVerse PTERM settings. Sometimes that doesn't work and I have to remove the AIX spooler entry and re-create it using one of the other filtering/pre-filtering options. It's hit and miss with these new printers and especially with the less expensive new printers as manufacturers are putting more of the 'driver' in software rather than onboard the printer. HTH, Karl quote who=will Anyone know the appropriate steps to setting up a new network printer using Jet Direct with AIX under Universe? Thanks and a tip of the hat to any daring responders, Will --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- Karl Pearson Director of I.T. ATS Industrial Supply, Inc. [EMAIL PROTECTED] http://www.atsindustrial.com 800-789-9300 x29 Local: 801-978-4429 Fax: 801-972-3888 To mess up your Linux PC, you have to really work at it; to mess up a microsoft PC you just have to work on it. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse I-descriptor Help
Bingo! Perfect. Thanks very much. Laure Hansen, City of Redwood City Information Technology www.redwoodcity.org 1017 Middlefield Road Redwood City, CA 94063 Tel: 650-780-7087 Fax: 650-556-9204 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janke, Mark Sent: Monday, March 26, 2007 1:28 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse I-descriptor Help Actually, I think you would need to use the REUSE function on the 0.5 also; otherwise the 0.5 will be added to only the first value in the intermediate result of CONS/REUSE(UNITS). INT(CONS/REUSE(UNITS)+REUSE(0.5)) However, on the old version of UniVerse I'm using, the INT function does not work with a multivalued argument and gives an error message. What I would use instead is the OCONVS function, which is the multivalued version of OCONV: OCONVS(CONS/REUSE(UNITS)+REUSE(0.5),'MD0') Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Norman Morgan Sent: Monday, March 26, 2007 3:34 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse I-descriptor Help i feel it should be INT(CONS/REUSE(UNITS)+ 0.5) You are correct, of course. I rounded in the wrong place. === Norman Morgan [EMAIL PROTECTED] http://www.brake.com === The Queue Principle: The longer you wait in line, the greater The likelihood that you are standing in the wrong line. === -Original Message- -Original Message- I'm trying to avoid having to write a subroutine to, basically, always round up the result of a division between a multi-value field and a single-value one, in an I-descriptor (UV 10.1). My MV field is named CONS, my single value one is names UNITS, the formula is CONS / REUSE(UNITS). The result will obviously be a multi-value. I don't know Universe I-descriptors, but can you say INT((CONS + 0.5) / REUSE(UNITS)) --- 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] PRINTERS getting set up using Jet Direct/AIX
I totally agree with Karl, but for added flexibility Put the IP address in, or the printer name if it's under your DNServer that way. Add the port as the name of the queue on the remote host. For Jetdirects, you can use 9100 or RAW1, 9101, RAW2, etc. Don't use a static IP address here even if you aren't using DNS. Create an entry in /etc/hosts so that you can change the IP address of your printer/move it to a different print server without having to reconfigure your AIX queue (you can just change the IP address in the hosts file). Craig --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Print Server Printing problem
Hi all... I am connecting to a network via Terminal Services to run a Universe session. Other people are also connecting to the Universe application via terminal sercices and their desktop has a printer attached to a print server. I wish to print documents out of Universe to this printer. I Cannot ping the Ip of the print server let alone see the printer/print server on the network They cannot print out of Universe to the attached printer although they can print Microsoft documents because the terminal services sets up a default printer for each user each time you log on. It does for me too. Universe is running on Windows 2003. Physical printer is 600 kms away from Universe server. Anyone had similar situation and if so how was it resolved. Thanks Kevin... OzIsp P/L PO Box 138 Rundle Mall Adelaide SA Australia 5000 Ph: +61 8 82116444 Fx: +61 8 82116020 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.446 / Virus Database: 268.18.18/734 - Release Date: 3/26/2007 2:31 PM --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
