Re: [U2] Web services at 11.x
We've been using soap requests (UV10.3.4) to read/write data to a number of web service front ends since about this time last year. I found some sample code somewhere (either Rocket dev zone or pick wiki) to get me started. As Symeon has just mentioned, the soap and other commands in the UV Basic extensions manual is where you need to look. It can be a steep learning curve if you have not done any of this before (it certainly was for me and I still don't understand some of it!). Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Wednesday, 14 May 2014 03:11 To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Web services at 11.x I have been telling my manager (an Oracle-centric guy) that with Universe 11+ (we have 10.2 now) the web services will truly allow us to do input and output interfacing with other web services. I need to make sure this is a correct understanding. It is clear from the Web Services manual that one can create a web service (a SOAP service) which will allow outside queries and return data. I write to this list to ask those of you who know that it is possible to do the other way, that from Universe you are able to connect to outside web services, send queries to them, and get back responses. Because I don't see this in the Web manual. If the latter is not possible via the Web services capabilities built into Universe, how are any of you doing it? Do you need a 3rd-party product? Here is the data need: We are to interface our Jail system to another system via an ESB (electronic services bus) via 'web services', passing XML. Thanks- Harold Oaks Clark County, WA -- This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Web services at 11.x
Found the sample code ... https://u2devzone.rocketsoftware.com/accelerate/articles/soap-api/soap-api Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 15 May 2014 08:59 To: 'U2 Users List' Subject: Re: [U2] Web services at 11.x We've been using soap requests (UV10.3.4) to read/write data to a number of web service front ends since about this time last year. I found some sample code somewhere (either Rocket dev zone or pick wiki) to get me started. As Symeon has just mentioned, the soap and other commands in the UV Basic extensions manual is where you need to look. It can be a steep learning curve if you have not done any of this before (it certainly was for me and I still don't understand some of it!). Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Oaks, Harold Sent: Wednesday, 14 May 2014 03:11 To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Web services at 11.x I have been telling my manager (an Oracle-centric guy) that with Universe 11+ (we have 10.2 now) the web services will truly allow us to do input and output interfacing with other web services. I need to make sure this is a correct understanding. It is clear from the Web Services manual that one can create a web service (a SOAP service) which will allow outside queries and return data. I write to this list to ask those of you who know that it is possible to do the other way, that from Universe you are able to connect to outside web services, send queries to them, and get back responses. Because I don't see this in the Web manual. If the latter is not possible via the Web services capabilities built into Universe, how are any of you doing it? Do you need a 3rd-party product? Here is the data need: We are to interface our Jail system to another system via an ESB (electronic services bus) via 'web services', passing XML. Thanks- Harold Oaks Clark County, WA -- This e-mail and related attachments and any response may be subject to public disclosure under state law. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600
Re: [U2] Read yourself
Hi Bernard, I did not know about the library search feature having always believed (probably from my Reality days) that you had to catalog a subroutines in order to call it. Obviously cataloguing is required if the SR is in a different library but I never gave it a second thought. Curiosity got the better of me and so I tried it and yes it does work as you described. Cheers and thanks Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bernard Lubin Sent: Tuesday, 13 May 2014 11:44 To: U2 Users List Subject: Re: [U2] Read yourself You will need to do a system(9001) to get the program stack This will tell you the subroutine that is being called. To get the library, first check the VOC for the external subroutine. If there is no VOC pointer for that item, check the VOC pointer for the calling program. As far as I remember, when calling a subroutine, UniVerse first checks the VOC for the program name to determine the program library where the program resides.. If the VOC entry is not present, it uses the library of the calling program. I do not know how far back the stack it will go.. (Hopefully all the way to the first program) Hope that helps. Rgds Bernard Lubin System Group Developer 549 Blackburn Rd Mount Waverley VIC 3149 Australia P: +61 3 9535 F: +61 3 9535 2274 E: bernard.lu...@pentanasolutions.com W: pentanasolutions.com Pentana Solutions accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, 13 May 2014 11:29 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Read yourself I just ran a test where a main program called an external subroutine In the external subroutine I had it display system(9001) The subroutine name was listed in that display as was the main routine which had called it -Original Message- From: David Wasylenko d...@pickpro.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Mon, May 12, 2014 6:09 pm Subject: Re: [U2] Read yourself I think the point has been lost. The person is requesting the name of the CURRENT ROUTINE If that is A SUBROUTINE - there is no @ that I know of that returns the name of the currently executing routine. The fact the CALLING routine knows the name is #1, is of no value to this request and #2, lends nothing to any routine being self-aware. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Overs Sent: Monday, May 12, 2014 7:58 PM To: U2 Users List Subject: Re: [U2] Read yourself I totally agree with and endorse your programming standards David. However if the program is calling another subroutine it should know the name of that subroutine or be able to derive it if it is called with an @. Sent from my iPad On 13 May 2014, at 10:45 am, David Wasylenko d...@pickpro.com wrote: IT'S JUST NOT TRUE EVER. @sentence cannot work. The stub program that launched an initial program will be in the @sentence... You could be 3 calls deep into external subroutines - there is nothing in @sentence re: the call-stack. Our shop writes *very* few stub programs - most are subroutines called by other subroutines. Instead: Add PGID=programName Or even PGID=filename ProgramName To the top of the program - quick and easy. Use of system routines such as SYSTEM(9001) is usually overkill. Your program should be aware of it's name - if no other reasons than: * display on the screen to help users identify where their problem came from * print on reports * add to log-file entries + and of course, to answer the original question: how can I read the + current program source A well-designed system/program should hard-code as little as possible as well. What better key to use for a configuration record than the program name itself. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Adrian Overs Sent: Monday, May 12, 2014 7:39 PM To: U2 Users List Subject: Re: [U2] Read yourself That's true - if the subroutines are catalogued with a noxref clause you're screwed. Sent from my iPad On 13 May 2014, at 10:19 am, David Wasylenko d...@pickpro.com wrote: Wont work --- if you use any external subroutines. -Original Message- From: u2-users-boun
Re: [U2] [Universe] [Windows]
I'd have to agree that it is likely going to be permissions. While I do not have UV on Windows on AIX if I create a record in a type 1 file and then change the ownership to something that I cannot read I get the following: ED PCTMP EDTEST Program ED: pc = 6952, Fatal error has occured. [~] $ CT PCTMP EDTEST Program COPYP: pc = 1A46, Fatal error has occured. [~] $ Perhaps the error you're getting is a windows equivalent of the above or something? The permissions on my file during this test were: [PCTMP] $ ls -l EDTEST -rw---1 root other 56 May 07 08:03 EDTEST [PCTMP] $ So I'd be looking at the permissions of the parent folder as well as its contents. HTH Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au From: u2-users-boun...@listserver.u2ug.org u2-users-boun...@listserver.u2ug.org on behalf of Woodward, Bob bob_woodw...@k2sports.com Sent: Wednesday, 7 May 2014 6:53 To: U2 Users List Subject: Re: [U2] [Universe] [Windows] This sounds like it's back to permissions. If it was UNIX, then I'd say the owner/user for the records(files) was deleted from the system and then editing them assigns a new, valid, owner. You said you're on windows, though. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Tuesday, May 06, 2014 1:09 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] [Universe] [Windows] Yes, Yes, No, Yes, No :) Here's an update. IF I open one of these in notepad, and just add an extra char to the end and then file it, the last modified date now appears for that file, but none of the other ones of course. And doing that, makes it so, in TCL, I can now EDit that particular record, but none of the other records, which still cause the fatal abort. So that's odd. But at least, I can go through and edit every single bleeping entry in the directory, file it, and make it editable again in Universe. WHY this has occurred, and WHETHER it's going to continue with new entries, is still an open question -Original Message- From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Tue, May 6, 2014 11:30 am Subject: Re: [U2] [Universe] [Windows] Can you open the .csv file (the Windows File item within the Windows Directory) with a text editor? Does it look like text? Is there a sub-directory within this directory? Are the permissions of this .csv file the same as the rest of the items within the directory? You're not getting that stupid desktop.ini item within the directory, are you? Just a few thoughts. Bill - Original Message - *From:* wjhon...@aol.com *To:* u2-users@listserver.u2ug.org *Date:* 5/6/2014 10:04 AM *Subject:* [U2] [Universe] [Windows] Running Universe 11.1.9 Information flavor on top of Windows A process which has been running for months, has suddenly decided that it has a Fatal Error ! When I debug it further, I get this symptom. In a Universe BASIC program, I can OPEN the file (a type 1 directory) I can SELECT the elements in the file (perfect) I can READNEXT each element (perfect so far) When I try to READ one of these items (windows files) I get in the ON ERROR clause the error set to 40070 What has occurred? Who has messed with what? How do I fix it? Thanks. ___ 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 ___ 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 --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus
[U2] [UV] Messing with file triggers and error 30107
Hi Everyone, Just thought I'd post a solution to a recent problem to do with a file trigger that was driving me up the wall, across the ceiling and down the other side... I'd made a mod to a particular file trigger to write to an item to a new file and all of a sudden the unirpcd started complaining with this error: IBMU2.UODOTNET.UniSubroutineException: [IBM U2][UODOTNET - UNICLIENT][ErrorCode=30107] The subroutine failed to complete successfully at IBMU2.UODOTNET.UniSubroutine.Call() at FirstMac.Core.BusinessService.FunderService.Connection.Ultracs.UltracsUniDkConnection.Execute(String subroutineName, String[] arguments, Boolean logRequest, Boolean logResponse) Searching around the usual haunts I found a few similar questions but nothing that answered my issue. Am still not entirely sure what other conditions this error 30107 covers but if you ever get this error then I recommend you check the file permissions of any newly created files that your code/modification is trying to write to. Regards, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 7.2.6 Secure submitRequest Question
When you do the addCertificate do you get a zero as the return code? If the RC is non-zero then perhaps check: o is it the correct certificate? o correct usedAs parameter? o correct format (PEM/DER)? o the correct algorithm (RSA/DSA)? o is in the correct location? Also what is happening in your code with the security context (handle) that is returned? It should remain untouched for re-use down the chain of those remaining routines. Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Tuesday, 25 March 2014 07:36 To: U2 Users List Subject: [U2] Unidata 7.2.6 Secure submitRequest Question Anybody ever seen anything like this before: 1523926:error:0D0890A1:asn1 encoding routines:ASN1_verify:unknown message digest algorithm:a_verify.c:141: 1523926:error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed:s3_clnt.c:844: This is displaying on a routine when it hits a submitRequest after the following routines have been successfully called: * createSecurityContext * setAuthenticationDepth * addCertificate * createSecureRequest * addRequestParameters Where should I start digging? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi-threaded phantom processing
My thoughts were that the parent will need to allocate the work and in doing so take the incoming data stream, launching a child and somehow pass the work to it. My only current knowledge of doing that within UV basic is writing to a queue and have the child phantom read from that and respond via another queue. Hence my question if there there's another possibly better way of doing it? It is nice to know if a particular phantom is busy or available though so that suggestion is certainly handy thanks. Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, 7 March 2014 02:52 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Multi-threaded phantom processing I was referring solely to the point of launching phantoms and how they could communicate back to their master who launched them. Not back to a different server. So the thread was mentioning a master-slave relationship on *a* server as I understood it. And the question asked was how do the slaves and master communicate. -Original Message- From: David A. Green dgr...@dagconsulting.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Mar 6, 2014 5:43 am Subject: Re: [U2] Multi-threaded phantom processing Will you kinda lost me on this approach. Since the Server socket is on a different machine than the client they don't see each other's locks. Different clients might be on different servers too. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, March 05, 2014 5:26 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Multi-threaded phantom processing Peter is the only point of the parent child communications to address points like 1 I'm busy go away; OR 2 I'm available to work If so, you could simply use a lock-semaphore to address both of those issues.\ -Original Message- From: Horacio Pellegrino pellegrin...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Mar 5, 2014 4:19 pm Subject: Re: [U2] Multi-threaded phantom processing Why don't you have one port listening for requests, and as soon as they come in, you create a new phantom to answer that request ( liberating the listener immediately for the next request ), then when the phantom finishes it could log off. Might be you want to keep a pool of phantoms alive for a while, on the assumption they might be reused. That way you are sill using one license per request, but you have the benefit of pooling... You can always set min-max limit for those phantom-workers. Horacio Pellegrino On Tue, Mar 4, 2014 at 11:30 PM, Peter Cheney peter.che...@firstmac.com.auwrote: Thanks David. As they say Bigger than Ben-Hur! That's a great idea. The server I have is listening on a predetermined port. I trolled through /etc/services and a netstat on the remote host to select something that looked unused. So then if it the main phantom spawns 1-n children (presumably more phantoms?), it would also need to select 1-n ports which I suppose must also be predetermined? Or is there a call to the OS that can return an unused port? We're on AIX but the remote host is HPUX. Cheers Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Wednesday, 5 March 2014 13:01 To: 'U2 Users List' Subject: Re: [U2] Multi-threaded phantom processing Peter, first of all let me congratulate you on this achievement. Having just finished a similar feat using UniData I understand the complexities that went into it. The system I'm current working with will be relatively low traffic. But I was pondering on the method of having a server socket that would just spawn a transfer server socket and send the socket address to the calling client. Then the client disconnects from the main server and just uses the transfer server to complete the task. Having 10 open phantoms with sockets will use up 10 licenses. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Tuesday, March 04, 2014 6:18 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Multi-threaded phantom processing Hi Everyone, A project that I'm currently working on requires transmission of transactional and ancillary data from one UV site to site to another. I have the communications all set up and it is working very well via
Re: [U2] Multi-threaded phantom processing
Thanks for that suggestion too. I did not know the SEND command could be used like that. So I suppose the listeners would use the openpipe and wait then? Must try that. This also reminded me of a time during mid-late 90's programming on a Sequoia pick system. That version of basic had a PAUSE command that you could use to pause a phantom indefinitely. Then wake it up again via another command in another program (POKE I think) directed at its PID. It was a very handy tool back then but have not seen it or an equivalent since. Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, 7 March 2014 10:20 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Multi-threaded phantom processing The simplest approach is to use the queue, but that requires check...wait...check...wait Another way, is to have one master and several always awake slaves listening as devices. The master uses the SEND command to pipe a command directly into the input stream of the listeners. This makes them wake up instantly (more or less) instead of waiting a second or a minute to check the queue. -Original Message- From: Peter Cheney peter.che...@firstmac.com.au To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Mar 6, 2014 4:05 pm Subject: Re: [U2] Multi-threaded phantom processing My thoughts were that the parent will need to allocate the work and in doing so take the incoming data stream, launching a child and somehow pass the work to it. My only current knowledge of doing that within UV basic is writing to a queue and have the child phantom read from that and respond via another queue. Hence my question if there there's another possibly better way of doing it? It is nice to know if a particular phantom is busy or available though so that suggestion is certainly handy thanks. Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Friday, 7 March 2014 02:52 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Multi-threaded phantom processing I was referring solely to the point of launching phantoms and how they could communicate back to their master who launched them. Not back to a different server. So the thread was mentioning a master-slave relationship on *a* server as I understood it. And the question asked was how do the slaves and master communicate. -Original Message- From: David A. Green dgr...@dagconsulting.com To: 'U2 Users List' u2-users@listserver.u2ug.org Sent: Thu, Mar 6, 2014 5:43 am Subject: Re: [U2] Multi-threaded phantom processing Will you kinda lost me on this approach. Since the Server socket is on a different machine than the client they don't see each other's locks. Different clients might be on different servers too. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Wednesday, March 05, 2014 5:26 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Multi-threaded phantom processing Peter is the only point of the parent child communications to address points like 1 I'm busy go away; OR 2 I'm available to work If so, you could simply use a lock-semaphore to address both of those issues.\ -Original Message- From: Horacio Pellegrino pellegrin...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Wed, Mar 5, 2014 4:19 pm Subject: Re: [U2] Multi-threaded phantom processing Why don't you have one port listening for requests, and as soon as they come in, you create a new phantom to answer that request ( liberating the listener immediately for the next request ), then when the phantom finishes it could log off. Might be you want to keep a pool of phantoms alive for a while, on the assumption they might be reused. That way you are sill using one license per request, but you have the benefit of pooling... You can always set min-max limit for those phantom-workers. Horacio Pellegrino On Tue, Mar 4, 2014 at 11:30 PM, Peter Cheney peter.che...@firstmac.com.auwrote: Thanks David. As they say Bigger than Ben-Hur! That's a great idea. The server I have is listening on a predetermined port. I trolled through /etc/services and a netstat on the remote host to select something that looked unused. So then if it the main phantom spawns 1-n children (presumably more phantoms?), it would also need to select 1-n ports which I suppose must also be predetermined? Or is there a call to the OS that can return an unused port? We're on AIX but the remote host is HPUX. Cheers Peter
Re: [U2] Handle multi request
Hi Christo, Thankyou for your reply and welcome to the list! I hope you enjoy this fantastic community of ours. With some small differences, you have described almost exactly what I have created. I am using file triggers on the client end to place items in a queue. Once the queued items are processed, indexes on the various (translated) keys are created they’re moved to a log. The communications is done by UV basic socket functions: opensocket(), writesocket(), readsocket(), and closesocket(). Other functions used are: protocollogging(), getsocketinformation(), setsocketoptions(), and getsocketoptions(). The client/server communications also have a “heartbeat” function to determine if the link is alive or not. Most of the data we send back and forth is XML but there is one case where raw attribute data direct from a UV file is transmitted. This was made necessary by the complex structure of the fields within some files data resulting in it being too hard to convert to XML. The communications is also en/decrypted via the encrypt function. I will also need to audit our results and create various reports and this is yet to be done but I have most of the structure in place so just have to write the code. I’m releasing a beta version to test on 17th and there’s still plenty of work left for me to do. Cheers and thanks. Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au From: Van Rooyen, C. (Christo) [mailto:chris...@nedbank.co.za] Sent: Friday, 7 March 2014 15:11 To: Peter Cheney Subject: Handle multi request Peter, This is the first I respond on this mailing list. I have developed a method where I use shared folders to receive requests for information. It works on the basis of a “request” folder with a “commit” folder. To return the result I place it in a “result” folder and commit it in the “done” folder. I use D3 on RedHat Linux. I have a Phantom that poll the commit folder for any file placed. Using the filename it read the request in the request folder with the same name. The process then removes the filename from the commit folder. After processing it, it will place the result in the “result” folder, and let the incoming requestor know by committing it in the “done” folder. I have a clean-up process that removes any unclaimed results older than a week. For audit purpose, the requests are archived. In all cases the filename is the same. I have a header in the request telling the process what to do and use an inscription section for any data passed. With this method you can have any client system in any environment that can either use FTP, SAMBA, NFS, Apache with PHP, e.c.t. to place request to the folders. I use this method also for outgaining requests to a VB app running on a Windows server that handle my PDF mailing of invoices and statements. It is fast, and as long as the folders are accessible the requests can be placed. I use a controlling phantom that spawn a phantom for each requests received. If your phantom is not running, you won’t miss out on requests coming in. it will just process them the moment the phantom restart. We use this for most of the communication between the systems. Mainframe to UNIX to Windows and so on. Regards, Christo van Rooyen Systems Analyst / Designer II - Nedbank Limited (South Africa) Nedbank Limited Reg No 1951/09/06. The following link displays the names of the Nedbank Board of Directors and Company Secretary. [ http://www.nedbank.co.za/terms/DirectorsNedbank.htm ] This email is confidential and is intended for the addressee only. The following link will take you to Nedbank's legal notice. [ http://www.nedbank.co.za/terms/EmailDisclaimer.htm ] --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600
Re: [U2] Multi-threaded phantom processing
Initially data volume will be small - probably about 20 customers per day and about 6 records per customer but it is likely to grow very quickly up to some unknown amount. We'll have to see I guess. The records per customer are likely to be the high volume stuff. There is transaction logging on the remote system that I can use and am relying on for data integrity but I did not know about the SQL stuff until this week. Not sure if it would work until I can find time to play with it and see how it might suit us. Some of the other constraints were: no access allowed to the remote unirpc port, the remote UV is below 10.3 and different from ours, neither site has a UV/Net licence in prod. So I think I'm pretty much stuck with file queuing and multiple phantoms for now at least. I also was able to get a successful remote file process going on our test system while waiting for confirmation of UV/Net accessibility. It is very nice and might have been a nice solution too. Then I did some experimenting with the performance requirements on the file triggers and found there to be too much of a lag for the triggers to fire directly to the other end. This would've caused unacceptable problems in testing not to mention going live so a file queuing process had to be devised. In all the file queuing works quite well and can be coded for rock solid reliability so it has a lot of pluses. I can also fine tune the phantom loop times and socket timeouts on the fly at both ends once the data starts flowing and we get some idea of what needs changing. Fingers, toes, arms, legs (and eyes!) all currently crossed. Cheers Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Friday, 7 March 2014 13:41 To: U2 Users List Subject: Re: [U2] Multi-threaded phantom processing Hi Peter Sounds like an interested piece of work, just a couple of questions for you: - what sort of data volumes and update frequencies are involved? - do you need to know if the data has been successfully committed to the remote UV database? - did you consider SQL BCI or even UV/Net (read the different UV versions is an issue and so this may be a constraint) Gregor mentioned SQL BCI as an alternative interface - I've used that before to exchange data between systems and it works well. If you had the same UV version on both hosts - then UV/Net is simple effect way of transmitting data between UV systems with only licenses required on the remote system. With BCI you could utilise the Stored Procedure facility via an ExecDirect() call to push the data to the remote system in your UV file trigger. With UV/Net you could push the items to be copied the by your UV file trigger - thus the updates being written directly onto the remote host. BCI is free/included in UV and of course will utilise a license on the remote host. You need to write your own custom code. Probably a bit easier to maintain than any TCP/IP sockets based interface. Definitely a lot easier to troubleshoot ;-) ! YMMV. UV/Net is licensed on the number user connections on the remote host. Hence the above alternative as designed to eliminate the file-based queue - which in some instances by be desirable to maintain - depending on business, technical or operational needs/objections. Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Wednesday, 5 March 2014 12:18 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Multi-threaded phantom processing Hi Everyone, A project that I’m currently working on requires transmission of transactional and ancillary data from one UV site to site to another. I have the communications all set up and it is working very well via the UV socket functions with a client at one end and a server at the other. Both the client and the server both run as a UV phantom processes written in UV basic and the data being transferred (also encrypted) is more or less real time with various UV file triggers on the client end creating queue items for transmission based on the data content / transaction type. This set up is a single threaded affair and I am wondering how it will cope and what options I’ll have as the volume of data increases. Multi-threading my server process to dish out some of the load might be one possibility and I’ve seen examples in the past where the last digit of a numeric key (i.e. 0-9) is used to determine which one of 10 phantoms to call thus providing an effective distribution of the work. But even then, reading/writing processing data to a file for each child process seems to me to be the only way to achieve parent - child phantom communications at either end
Re: [U2] Multi-threaded phantom processing
So I went looking for options to query the OS for a free port and found an answer on stackoverflow that I think is simply brilliant. (I hope it's OK to quote from others here? Apologies if not.) If your server was told what port to use, just bind() it. Seriously. Sure, you could parse /proc/net/tcp and see if the port's in use. But then what? You still need to call bind() now that you know your port is free, and it'll tell you if the port was free then anyway, and so there was no point in groveling through /proc/net/tcp and doing all that (slow!) string production and parsing and extra kernel trips through not-very-well-optimized (read: super slow compared to bind()) diagnostic paths, just to get information that could well be out of date before you even finished parsing it. So just call bind() and be happy. The full article is here for those interested: http://stackoverflow.com/questions/10294515/how-do-i-find-in-c-that-a-port-is-free-to-use So back in UV Basic we'd just call initServerSocket with the desired port number and action according to success or failure! Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Wednesday, 5 March 2014 22:35 To: 'U2 Users List' Subject: Re: [U2] Multi-threaded phantom processing I don't know how you would query the OS on the fly, but you can do a manual search for a bank of 10 or 20 unused ports and claim them. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Tuesday, March 04, 2014 9:30 PM To: 'U2 Users List' Subject: Re: [U2] Multi-threaded phantom processing Thanks David. As they say Bigger than Ben-Hur! That's a great idea. The server I have is listening on a predetermined port. I trolled through /etc/services and a netstat on the remote host to select something that looked unused. So then if it the main phantom spawns 1-n children (presumably more phantoms?), it would also need to select 1-n ports which I suppose must also be predetermined? Or is there a call to the OS that can return an unused port? We're on AIX but the remote host is HPUX. Cheers Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Multi-threaded phantom processing
Hi Everyone, A project that I’m currently working on requires transmission of transactional and ancillary data from one UV site to site to another. I have the communications all set up and it is working very well via the UV socket functions with a client at one end and a server at the other. Both the client and the server both run as a UV phantom processes written in UV basic and the data being transferred (also encrypted) is more or less real time with various UV file triggers on the client end creating queue items for transmission based on the data content / transaction type. This set up is a single threaded affair and I am wondering how it will cope and what options I’ll have as the volume of data increases. Multi-threading my server process to dish out some of the load might be one possibility and I’ve seen examples in the past where the last digit of a numeric key (i.e. 0-9) is used to determine which one of 10 phantoms to call thus providing an effective distribution of the work. But even then, reading/writing processing data to a file for each child process seems to me to be the only way to achieve parent - child phantom communications at either end. Is there another way perhaps? It may be that I will need 2 sets of phantoms, 1 for the transactions and one for the ancillary data. Although we run UV on AIX the only other requirement is that I must be able to do it within UV Basic. Does anyone out there on the list know of a better way or any alternatives/advice so I can get a better appreciation of what else might be possible please? Many thanks in advance, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi-threaded phantom processing
Thanks Gregor I will look into the SQL interface and see what I can glean. I did look at the submit request stuff and had a working proof of concept between my workstation and our dev AIX host but the destination UV system is an earlier release and didn't support a lot of that stuff. So we had to find a middle of the road solution and sockets was it. For the moment at least until they upgrade. :) Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Gregor Scott Sent: Wednesday, 5 March 2014 11:29 To: U2 Users List Subject: Re: [U2] Multi-threaded phantom processing There are options you can explore using the BASIC SQL Client Interface. These will allow basic programs running as phantoms to establish their own connection to the remote site and run subroutines supplied with data as parameters. This would bypass the need for multiple server phantoms listening and reacting to socket connections. You could also look at hosting web services on the AIX server and use the submitrequest() functions. Gregor Scott System Group Manager 549 Blackburn Rd Mount Waverley VIC 3149 Australia P: +61 3 9535 F: +61 3 9535 2274 E: gregor.sc...@pentanasolutions.com W: pentanasolutions.com Pentana Solutions accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. Gregor Scott System Group Manager 549 Blackburn Rd Mount Waverley VIC 3149 Australia P: +61 3 9535 F: +61 3 9535 2274 E: gregor.sc...@pentanasolutions.com W: pentanasolutions.com Pentana Solutions accepts no liability for the content of this email, or for the consequences of any actions taken on the basis of the information provided, unless that information is subsequently confirmed in writing. If you are not the intended recipient, you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Multi-threaded phantom processing
Thanks David. As they say Bigger than Ben-Hur! That's a great idea. The server I have is listening on a predetermined port. I trolled through /etc/services and a netstat on the remote host to select something that looked unused. So then if it the main phantom spawns 1-n children (presumably more phantoms?), it would also need to select 1-n ports which I suppose must also be predetermined? Or is there a call to the OS that can return an unused port? We're on AIX but the remote host is HPUX. Cheers Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David A. Green Sent: Wednesday, 5 March 2014 13:01 To: 'U2 Users List' Subject: Re: [U2] Multi-threaded phantom processing Peter, first of all let me congratulate you on this achievement. Having just finished a similar feat using UniData I understand the complexities that went into it. The system I'm current working with will be relatively low traffic. But I was pondering on the method of having a server socket that would just spawn a transfer server socket and send the socket address to the calling client. Then the client disconnects from the main server and just uses the transfer server to complete the task. Having 10 open phantoms with sockets will use up 10 licenses. David A. Green (480) 201-7953 DAG Consulting -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Tuesday, March 04, 2014 6:18 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] Multi-threaded phantom processing Hi Everyone, A project that I’m currently working on requires transmission of transactional and ancillary data from one UV site to site to another. I have the communications all set up and it is working very well via the UV socket functions with a client at one end and a server at the other. Both the client and the server both run as a UV phantom processes written in UV basic and the data being transferred (also encrypted) is more or less real time with various UV file triggers on the client end creating queue items for transmission based on the data content / transaction type. This set up is a single threaded affair and I am wondering how it will cope and what options I’ll have as the volume of data increases. Multi-threading my server process to dish out some of the load might be one possibility and I’ve seen examples in the past where the last digit of a numeric key (i.e. 0-9) is used to determine which one of 10 phantoms to call thus providing an effective distribution of the work. But even then, reading/writing processing data to a file for each child process seems to me to be the only way to achieve parent - child phantom communications at either end. Is there another way perhaps? It may be that I will need 2 sets of phantoms, 1 for the transactions and one for the ancillary data. Although we run UV on AIX the only other requirement is that I must be able to do it within UV Basic. Does anyone out there on the list know of a better way or any alternatives/advice so I can get a better appreciation of what else might be possible please? Many thanks in advance, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ 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] [UV] INPUTTRAP Statement
Could you do this via a combination of the PTERM command's BREAK and INTR options along with the ON.ABORT etc? Something like changing the break from ctrl-C to another key combo during that session? Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au From: u2-users-boun...@listserver.u2ug.org u2-users-boun...@listserver.u2ug.org on behalf of Perry Taylor perry.tay...@zirmed.com Sent: Tuesday, 24 December 2013 5:41 To: U2-Users List Subject: [U2] [UV] INPUTTRAP Statement Has anyone ever used the INPUTTRAP statement in UniVerse BASIC? I want to be able to trap a break (Ctrl-c) but I can't seem to get it to work with CHAR(3), or any other character for that matter. The UniVerse BASIC Commands documentation provides no examples on its use. Anybody done anything like this? Any sample code you're willing to share? Thanks. Perry Taylor Senior MV Architect ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ 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 http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] BASIC code - upper, lower, CamelCase, what say you?
Hi Doug, Re the Eclipse thing, do you have any pointers or links etc for setting up eclipse in a Linux workstation environment please? Most of the stuff I've seen for U2 seems to all be windows based and I'm only knew to Eclipse as well having been a vi fan for ages. My colleague has recently introduced me to the joys of Emacs but am struggling to un-learn vi. Cheers Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au From: u2-users-boun...@listserver.u2ug.org u2-users-boun...@listserver.u2ug.org on behalf of Doug Averch dave...@gmail.com Sent: Sunday, 22 December 2013 12:23 AM To: U2 Users List Subject: Re: [U2] BASIC code - upper, lower, CamelCase, what say you? BFIND are your really serious. Is this one of those, we must us only use UniBasic code? Because if it is, we U2 programmers are really dinosaurs not knowing the comet already has changed the world. We have been using Eclipse since 2004. The search engine is so fast and will search my local machine, not the database, in seconds. The Eclipse search engine shows not only the program but the entire line that matches. You can click on the line in the search window and the editor start up and loads the program focusing on the line in question. Gee, you should wonder how Eclipse compares to a single telnet window driven program written UniBasic? Regards, Doug www.u2logic.com Industrial strength tools for U2 programmers and shops On Sat, Dec 21, 2013 at 6:08 AM, Symeon Breen syme...@gmail.com wrote: Not this one again -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: 20 December 2013 19:02 To: U2 Users List Subject: [U2] BASIC code - upper, lower, CamelCase, what say you? First off - Merry Christmas and Happy New Year to all. I'm starting to write a lot of new BASIC (Universe 11.1) subroutines for our DesignBais application, and since I'll be starting with a blank code template instead of modifying existing code, and I thought 'hey why not join the 21st century' and make the code look more mainstream, and readable. (falling back on our last TEXMUG presentation by Clif Oliver on refactoring). And considering Universe 11.2 now supports local subroutines and functions, I should make the code look and behave more object-like. Does anyone know of a set of rules or guidelines on how to do this?Just experimenting briefly, Universe BASIC compiler will allow any mix of cases for keywords, but variables are case sensitive. Example: ED BP TEST ABC=1 Abc=2 abc=3 PRINT ABC Print Abc pRiNt abc stop end RUN TEST 1 2 3 So, how are developers mixed case in their code these day? Do keywords, local variables, common variable, equates follow a standard method? thanks in advance, ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [OT] Interview Questions
This would work for the last of the previous month
But I also needed to consult the manual for the correct date conversions...
Get internal date for 1st of current month.
Subtract 1 gets you internal end date of previous month
Loop until numeric day of week = 4 (assuming Monday is 1)
Subtract 1 from internal end date of previous month
Repeat
e.g.
code
* Date format is DD/MM/
CurrentMonth = oconv(date(), 'DM')
CurrentYear = oconv(date(), 'DY4')
InternalFirstThisMonth = iconv('1/':CurrentMonth:'/':CurrentYear, 'D4/')
InternalLastPreviousMonth = InternalFirstThisMonth - 1
loop
IsThisThursday = (oconv(InternalLastPreviousMonth, 'DW') = 4)
until IsThisThursday do
InternalLastPreviousMonth -= 1
repeat
if IsThisThursday then crt oconv(InternalLastPreviousMonth, 'D4')
/code
Peter Cheney
Ultracs Developer
t 07 3017 8837 | f 07 3002 8400
e peter.che...@firstmac.com.au
w firstmac.com.au
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson
Sent: Tuesday, 17 December 2013 10:17
To: u2-users@listserver.u2ug.org
Subject: Re: [U2] [OT] Interview Questions
What is the last Thursday of the current month.
Current Date minus Current Day of Month number plus 1 puts you on the first of
the current month Or you could just Oconv d2/ and replace the middle number
with 01 with Iconv that.
Now take that internal date and add 32, this will *always* put you exactly into
the next month somewhere.
Now oconv that date D2/ and replace the middle number with 01 which will always
put on the first of next month
Now if the DOW number is larger than Thursday subtract the difference If its
less than Thursday subtract that number and an extra 2 to get to last Thursday
-Original Message-
From: Daniel McGrath dmcgr...@rocketsoftware.com
To: U2 Users List u2-users@listserver.u2ug.org
Sent: Mon, Dec 16, 2013 2:55 pm
Subject: Re: [U2] [OT] Interview Questions
Build an API to Mechanical Turk.
neededDate = Mech_Turk(In /mm/dd format, what is the last Thursday
of :month: :year)
Hmmm - I guess that's why I don't code anymore ;)
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org]
On Behalf Of Kevin King
Sent: Monday, December 16, 2013 3:22 PM
To: U2 Users List
Subject: Re: [U2] [OT] Interview Questions
Asking the list...I'd label that as resourceful. So yeah, that's a positive.
On Mon, Dec 16, 2013 at 10:08 AM, Woodward, Bob
bob_woodw...@k2sports.comwrote:
Maybe it's a good thing you're not interviewing me, Kevin. My
immediate answer would be I don't know. Let me check the
documentation and get back to you. I've never had to do anything
like that so it's not something I'd know off the top of my head. I'm
sure there's probably and OCONV format that would get me started but.
Oh! I know! I'd as this list! silly smile Does that count?
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King
Sent: Saturday, December 14, 2013 8:15 AM
To: U2 Users List
Subject: Re: [U2] [OT] Interview Questions
David, I've used many of these questions in the past but where it fell
down was that it didn't give any real picture of technical ability.
The one question I've been using lately to assess technical thinking
is how would you calculate the last Thursday in a month? The answers
have been everywhere from accurate to sheer ridiculous. The unexpected
takeaway from this question is that it has helped to identify people
who simply want to answer quickly without thinking - not a good trait
unless the answer is right and to date that's happened a total of zero
times - vs people who think first and then give a reasoned response.
I've just found it too easy for people to stretch the truth when
explaining their technical ability, so I'm asking questions intended
to give some evidence.
On Saturday, December 14, 2013, David Sharp wrote:
Here is something I have used:
What single project
or task would you consider the most significant accomplishment in
your
career so far?
*
Can you give me a detailed overview of the accomplishment?
*
Tell me about the company, your title, your position, your role, and
the team involved.
*
What were the actual results achieved?
*
When did it take place and how long did the project take.
*
Why you were chosen?
*
What were the 3-4 biggest challenges you faced and how did you deal
with them?
*
Where did you go the extra mile or take the initiative?
*
Walk me through the plan, how you managed to it, and if it was
successful.
*
Describe the environment and resources.
*
Describe your manager's style and whether you liked it or not.
*
Describe the technical skills needed to accomplish the objective and
how they were used.
*
Some
Re: [U2] UniVerse Install on HP-Ux
How about making a copy of the cd/dvd to an iso and installing from that? Somewhere in *nix land where it's easier to mount and use the cd... # dd if=/dev/cdrom of=/var/tmp/uv.iso bs=8000 transport the resulting ISO to your HPUX machine # mount -F lofs /some/dir/to/uv.iso /tmp/mount You should then be able to cd to /tmp/mount and run the cpio command as root (or uvadm?) and follow the install instructions for hpux. # cpio -ivcBdum uv.load ./STARTUP # ./uv.load -longnames HTH Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of William Brutzman Sent: Saturday, 14 December 2013 10:49 To: U2 Users List Subject: [U2] UniVerse Install on HP-Ux 1. I am having some problems trying to get to first base. 2. There is this cpio command. 3. Is it necessary to install from a CD or DVD? 4. I would rather install from FTP'd files. 5. Mounting the media is a hassle... so is CDFS on a DVD. 6. Suggestions would be appreciated. --Bill ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV/Net usage and licensing
Hi again, Just on this remote file access, can anyone advise what happens if the remote host is off air such as communications outage or server failure? Do the read/writes queue somehow? Or do they simply fail requiring further coding to accommodate? Many thanks again. Cheers Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 12 December 2013 17:10 To: 'U2 Users List' Subject: Re: [U2] UV/Net usage and licensing Thanks David, There was some confusion about if both hosts need the license and if only one then which? Based on what you've written re the setup below, and from what our VAR has advised I think the remote host will require a UVnet licence which it does not currently have. I am now going to re-check the alignment of the actual UID and GID's as you mentioned below and perhaps turn on logging too. Thanks again for the other tips. Most appreciated. Regards, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Thursday, 12 December 2013 16:45 To: U2 Users List Subject: Re: [U2] UV/Net usage and licensing Hi Peter, It's been a while since I've used/played around with UV/Net, but this may help... 1. Setup You only need a ensure UniRPC is active and you license for UV/Net on the server you wish to access. I don't recall you need to anything other than the UniRPC Daemon listening for requests and it will invoke uvnet for your client request. 2. Security I can't recall if you're using UNIX or not...(it is supposed to OS independent) Although, UV/Net is supposed to set the effective user (UID numer) and group (GID numer) for the remote users connecting to the remote UV server...if required. Plus if specified - as you're doing so. My experience with similar DB product tools is it is far better to have the UID and GIDs directly aligned. Specifically: make sure the UID and GID for the same named accounts are exactly the same on both servers. Or if you use SET.REMOTE.ID that the account locally has sufficient rights or in fact it exists. I have issues with the same accounts and groups on different users have different UIDs and GIDs on the different client and servers - causing grief/ havoc on similar products to UV/Net, etc. Also - check if you have UniVerse Dynamic Type30 files, that your UNIX file ownerships, group ownership and Other are set exactly the same. This includes the hidden file.Type30. Having different settings are recipe for lots of grief! Finally, be forewarned that allowing testers/developers access to your production server via UV/Net is an EXTREMELY bad idea! (Career terminating if things go pear shaped when they have write/delete rights!). It is far too easy for these types of users to be unaware their test account is in fact pointing to your production service and there access is write/delete. Did you try the UVNETRID environment variable in place of SET.REMOTE.ID? If you are still having issues, you may have to enabled UniRPC debugging which is very extensive and generate logs of data - but is useful for seeing exactly where things are going wrong. Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 12 December 2013 2:23 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] UV/Net usage and licensing Hi Everyone, We’re looking at doing some remote file mangling and was wondering if there are any gotchas when using UV/Net to do this? In my scenario if I am on host A and want to read/write files on host B. Host B only needs to read/write files on host B but not on host A. Do I need UV/Net on host A as well as host B or just on host A? Host A is running UV 10.3.4 and host B is running UV 10.2.6. Local testing on host A to host A/DR shows record locking is working OK but if the remote file does not have read/write on ‘other’ (e.g. 660) then all writes fail regardless of how I spec the credentials via SET.REMOTE.ID. Setting the permissions to 666 is the only way I can get this to work even when using the same login and group membership at each end. Also does anyone know if firewall ports other than standard unirpc port 31438 need to be opened either end for bi-directional file access too please? Regards, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains
Re: [U2] Exporting to File regularly
Hi David, If you can do some UV basic coding or have access to a resource who can then: Have a look at installing a file trigger on the file(s) you need to monitor. The sysdesc manual contains trigger information. The reason I suggest this is that the trigger will fire on your designated condition (INSERT/UPDATE etc) which in turn can cause other events so is more efficient than running a query on the file every n seconds/minutes. Alternatively, seeing as you're probably running on a unix host (/var was the giveaway) then a poor man's version of a trigger might entail a shell script that does an `ls -lt /path/FILE.NAME` and check the last mod time of the file. This would give you a fair idea as to when it was last modified and can then launch into UV for your csv creation routine..? If the UV FILE.NAME is a directory (which it may or may not be) then you could simply `ls -lrt | tail -1` periodically in a cron job to derive the last updated record. Regards, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Campbell Sent: Wednesday, 11 December 2013 15:39 To: u2-users@listserver.u2ug.org Subject: [U2] Exporting to File regularly Hi Everyone, I'm new to universe (a complete noob) and I couldn't quite find what I was looking for on google and I've been smashing my face against this for a while until I stumbled upon this mailing list so I was wondering if anyone could help me out here. I'm writing a script that will hopefully alert me via email whenever a new record is added to a particular universe file, if there is a better way to do this I would be all ears. I'm working around another proprietary system which operates on universe and I dont know enough about universe to really say for sure what is proprietary and what is universe standard code and the proprietary stuff is covered in NDA's and no touchy hand slappy orders so I cannot really modify the way it works, I just need to know when a new entry appears, preferably via an smtp email. My Current plan works like this I'm looking to regularly (every 5 minutes) output data into a text or csv file, doesn't matter really, so long as it is not full of characters that batch scripts hate and it can happen in an automated fashion. The closest thing I can get to what I want right now is SP.ASSIGN HS LIST FILE.NAME LPTR this lists all the records and dumps them in a spool file under /var/spool/uv/ and then a script I have written in the past retrieves that spool file for me, I have trained that spool file to look for specific markers in the first line of the file and apply a particular script to it This spooled print job gives me a list of the records that I can then sort numerically, pick the highest number, check that number against what the number was last time and alert me via email if its different. Ultimately I would love for a regularly running script to just output the highest record (maybe sort numerically and give me the highest number and dump just that number into a file on the unix box for me to retrieve and the work with. Any help would be greatly appreciated! -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/Exporting-to-File-regularly-tp42264.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV/Net usage and licensing
Hi Everyone, We’re looking at doing some remote file mangling and was wondering if there are any gotchas when using UV/Net to do this? In my scenario if I am on host A and want to read/write files on host B. Host B only needs to read/write files on host B but not on host A. Do I need UV/Net on host A as well as host B or just on host A? Host A is running UV 10.3.4 and host B is running UV 10.2.6. Local testing on host A to host A/DR shows record locking is working OK but if the remote file does not have read/write on ‘other’ (e.g. 660) then all writes fail regardless of how I spec the credentials via SET.REMOTE.ID. Setting the permissions to 666 is the only way I can get this to work even when using the same login and group membership at each end. Also does anyone know if firewall ports other than standard unirpc port 31438 need to be opened either end for bi-directional file access too please? Regards, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV/Net usage and licensing
Thanks David, There was some confusion about if both hosts need the license and if only one then which? Based on what you've written re the setup below, and from what our VAR has advised I think the remote host will require a UVnet licence which it does not currently have. I am now going to re-check the alignment of the actual UID and GID's as you mentioned below and perhaps turn on logging too. Thanks again for the other tips. Most appreciated. Regards, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Thursday, 12 December 2013 16:45 To: U2 Users List Subject: Re: [U2] UV/Net usage and licensing Hi Peter, It's been a while since I've used/played around with UV/Net, but this may help... 1. Setup You only need a ensure UniRPC is active and you license for UV/Net on the server you wish to access. I don't recall you need to anything other than the UniRPC Daemon listening for requests and it will invoke uvnet for your client request. 2. Security I can't recall if you're using UNIX or not...(it is supposed to OS independent) Although, UV/Net is supposed to set the effective user (UID numer) and group (GID numer) for the remote users connecting to the remote UV server...if required. Plus if specified - as you're doing so. My experience with similar DB product tools is it is far better to have the UID and GIDs directly aligned. Specifically: make sure the UID and GID for the same named accounts are exactly the same on both servers. Or if you use SET.REMOTE.ID that the account locally has sufficient rights or in fact it exists. I have issues with the same accounts and groups on different users have different UIDs and GIDs on the different client and servers - causing grief/ havoc on similar products to UV/Net, etc. Also - check if you have UniVerse Dynamic Type30 files, that your UNIX file ownerships, group ownership and Other are set exactly the same. This includes the hidden file.Type30. Having different settings are recipe for lots of grief! Finally, be forewarned that allowing testers/developers access to your production server via UV/Net is an EXTREMELY bad idea! (Career terminating if things go pear shaped when they have write/delete rights!). It is far too easy for these types of users to be unaware their test account is in fact pointing to your production service and there access is write/delete. Did you try the UVNETRID environment variable in place of SET.REMOTE.ID? If you are still having issues, you may have to enabled UniRPC debugging which is very extensive and generate logs of data - but is useful for seeing exactly where things are going wrong. Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 12 December 2013 2:23 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] UV/Net usage and licensing Hi Everyone, We’re looking at doing some remote file mangling and was wondering if there are any gotchas when using UV/Net to do this? In my scenario if I am on host A and want to read/write files on host B. Host B only needs to read/write files on host B but not on host A. Do I need UV/Net on host A as well as host B or just on host A? Host A is running UV 10.3.4 and host B is running UV 10.2.6. Local testing on host A to host A/DR shows record locking is working OK but if the remote file does not have read/write on ‘other’ (e.g. 660) then all writes fail regardless of how I spec the credentials via SET.REMOTE.ID. Setting the permissions to 666 is the only way I can get this to work even when using the same login and group membership at each end. Also does anyone know if firewall ports other than standard unirpc port 31438 need to be opened either end for bi-directional file access too please? Regards, Peter Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line
Re: [U2] List of display control @ variables for UVBasic
Try in the UniVerse Basic Commands Reference manual - UniVerse BASIC Commands section - @ function Peter Cheney Ultracs Developer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au w firstmac.com.au On 20/11/13 07:54, Jeff Schasny wrote: Anyone know where the list of @ variables for display control ( @(-1) = clear screen) is in the Universe documentation? I can't seem to find it. Thanks --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] moving UV from one server to another (windows)
Hi Bob, Post migration, one thing for consideration might be user education regarding the new use of their workstation/PC? No more will the user just be able to re-boot it when it freezes etc or shut it down each night at home-o'clock. Cheers Peter On 19/11/13 05:55, Woodward, Bob wrote: Oh, I'd always say go for more memory. Especially if there are other Windows apps that are going to be used on that computer. As to the locking, the normal record locks inside of UV once it's moved. Just do a simple edit of a record on the workstation, then from another workstation, edit the same record. If there is a problem, the workstation hosting UV is probably not locking the records. When I saw the problem, it was because the workstation was accessing UV through the C: drive, which was local, of course. To fix it, you have to map a network drive and ONLY use the network drive on that workstation. The idea was that local drives didn't NEED to be locked since it's a single user OS. At least that's the way it was explained to me. Come to think of it, Win7 may not even maintain a network locking table. Remember, I said I did this on a PE version where I was pretty much the only user. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, November 18, 2013 11:38 AM To: U2 Users List Subject: Re: [U2] moving UV from one server to another (windows) Locking issues once UV is running on the Windows 7 machine, or locking issues caused by Copying over the data and overwriting the fresh install? This won't be a heavily used system (3 or 4 users maximum and even then should be too taxing). Should they max out the memory on the PC it's going to be installed on? Or is 4gb fine? George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Monday, November 18, 2013 2:28 PM To: U2 Users List Subject: Re: [U2] moving UV from one server to another (windows) One of the things you may need to watch real careful would be locking. Especially on the workstation that is hosting UV. Then, as long as all the drive letters are the same as on the server, everything should be okay. Of course, YMMV but I've done this type of swapping on my home network with the personal edition a number of years ago. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Monday, November 18, 2013 11:04 AM To: U2 Users Subject: [U2] moving UV from one server to another (windows) Had someone ask me this question. They are downsizing their PC's They have UV currently installed on a Windows Server PC - and each of the PC's using wintergate to access it. This server is having some issues, so they want to move UV off of it, and have it run on one of their client PC Running windows 7. My thought was that you would install UV on that PC, Then (with the services off), copy the file structure from The Server to the PC. Assuming the all the folders are named the same on both systems for the install. And of Course remove UV from the Server once all it good. Should this be all that would be needed? Will UV function on a Windows 7 PC? Can it be used as working PC - as well as be a UV server? Everything I've heard says it should run by itself - but - can it run on a PC as background service? George Gallen Senior Programmer/Analyst Accounting/Data Division, EDI Administrator ggal...@wyanokegroup.com ph:856.848.9005 Ext 220 The Wyanoke Group http://www.wyanokegroup.comhttp://www.wyanokegroup.com/ ___ 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 ___ 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 --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do
Re: [U2] Non-SQL re-entrant query calls are not allowed??? (UV 10.0.2 )
Hi George,
I was curious so I tried it on my workstation running UniVersePE 11.1.12 with
same results.
So I put a debug statement in the CRM.RETURN.PROFESSION subroutine.
JUNK var contains `Non-SQL re-entrant query calls are not allowed.þ'
So it certainly seems to be the SELECT as Andy just mentioned.
Regards,
Peter
Peter Cheney
Universe Engineer
t 07 3017 8837 | f 07 3002 8400
e peter.che...@firstmac.com.au | w www.firstmac.com.au
From: u2-users-boun...@listserver.u2ug.org
u2-users-boun...@listserver.u2ug.org on behalf of George Gallen
ggal...@wyanokegroup.com
Sent: Friday, 8 November 2013 5:05 AM
To: U2 Users
Subject: [U2] Non-SQL re-entrant query calls are not allowed??? (UV 10.0.2 )
OK.
I Setup a Subroutine that if I call from an IDESC Gives me the following error:
Non-SQL re-entrant query calls are not allowed'
Am I to take this as, you can't do a SELECT on a file, from an IDESC Subroutine?
However, If I call it from another basic program, it works just fine.
The program runs the following code:
CMD=SELECT FRED-XREF-FILE WITH FILENAME = ':FILENAME:' TO 5
PRINT CMD
EXECUTE CMD RTNLIST CAPTURING JUNK
PRINT JUNK
PRINT @SELECTED: SELECTED
SIDNO=
LOOP
READNEXT ID FROM 5 ELSE EXIT
PRINT ID
SIDNO=FIELD(ID,_,2)
REPEAT
*
And the IDESC:
0001: I
0002: SUBR('*CRM.RETURN.PROFESSION','MASTER.HEMONC',@ID)
0003:
0004: PROFESSION
0005: 30L
0006: S
It's the SELECT that fails - but only when run from the IDESC
Example:
0001: FILE=MASTER.HEMONC
0002: ID=123456
0003: CALL *CRM.RETURN.PROFESSION(PROFESSION,FILE,ID)
0004: PRINT PROFESSION
George Gallen
Senior Programmer/Analyst
Accounting/Data Division, EDI Administrator
ggal...@wyanokegroup.com
ph:856.848.9005 Ext 220
The Wyanoke Group
http://www.wyanokegroup.comhttp://www.wyanokegroup.com/
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
---
Note:
This email (inc all attachments) is for the use of the intended recipient(s)
only.
Privileged or confidential information may be contained in this communication.
If you have received this email in error, please notify the sender immediately
and then delete all copies of this message from your computer network. If you
are not the intended recipient, you must not keep, use, disclose, copy or
distribute this email without the author's prior permission. If you are the
intended recipient and you do not wish to receive similar electronic messages
from us in future, then please respond to the sender to this effect.
We have taken precautions to minimise the risk of transmitting software
viruses, but advise you to carry out your own virus checks on this email and
its attachments. We do not accept liability for any loss or damage caused by
software viruses and do not represent that this transmission is free from
viruses or other defects.
Firstmac Limited (ABN 59 094 145 963) (AFSL 290600)
---
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV Basic parsing xml with XDOM commands
A brief explanation of the above code snippet: 1. Open the xml document with XDOMOpen 2. Obtain a handle to the root node based on the specified xpathString and nsMAP parameters 3. Display the root node name 4. Obtain a handle to the parent node 5. Display the parent node name 6. Obtain a handle to the child node 7. Display the child node name 8. Obtain a handle to the 1st value node 9. display the 1st value node name 10. Obtain a handle to the text node 11. Display the 1st text data 12. Obtain a handle to the 2nd (next) value node 13. Display the 2nd value node name 14. Obtain a handle to the 2nd text node 15. Display the 2nd text data Cheers Peter [Description: Description: https://www.firstmac.com.au]https://webmail.firstmac.com.au/owa/redir.aspx?C=3TxBWxfLckGBVPoLiIA9bpVACaOTOtAI5wx873XG4iVimMG4ihRNvq2GjE8ncHzAUsu8CiQ8FdM.URL=http%3a%2f%2fwww.firstmac.com.au%2f Peter Cheney Universe Engineer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.auhttps://webmail.firstmac.com.au/owa/redir.aspx?C=3TxBWxfLckGBVPoLiIA9bpVACaOTOtAI5wx873XG4iVimMG4ihRNvq2GjE8ncHzAUsu8CiQ8FdM.URL=mailto%3apeter.cheney%40firstmac.com.au | w www.firstmac.com.auhttps://webmail.firstmac.com.au/owa/redir.aspx?C=3TxBWxfLckGBVPoLiIA9bpVACaOTOtAI5wx873XG4iVimMG4ihRNvq2GjE8ncHzAUsu8CiQ8FdM.URL=https%3a%2f%2fwww.www.firstmac.com.au%2f --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] REPLICATING DATA
Back in 2000 at a previous employer my then boss and I implemented our DR plan on UV9.something using a nightly rsync. It wasn't a hot DR site but that didn't matter and we were also able to shut down UV for the duration of the backup which was from the live disks to backup disks using the Solaris dump/restore and once complete we'd dump the backup file systems off to tape and then rsync it to DR. The backup scripts were mostly perl but the rsync was ksh scripts. Only took a few months to hack together. The disks themselves were all under Veritas VM control. Regadrs, Peter Peter Cheney Universe Engineer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au | w www.firstmac.com.au From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] on behalf of Ard956 [ard...@optonline.net] Sent: Wednesday, 4 September 2013 2:18 AM To: u2-users@listserver.u2ug.org Subject: [U2] REPLICATING DATA Does anyone do replication with a tool outside of the U2 toolbox? We are on UV 10.2.10 which does not support UV replication. We have no plans to upgrade at this time but need a backup for our Universe server. Our database is about 180GB. Thank you, Andrea Dente Taylored Services Sent from my iPad ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Exchanging XML data instead of JSON between hosts via RESTful Server
Hi Everyone,
Is it possible to configure a RESTful service subroutine to accept XML as the
input to one of its defined parameters?
I keep getting the following error:
500: Expected+a+','+or+'}'com.rs.u2.u2rest.marshaller.U2JSONTokenizer@13c33b7
The subroutine has 2 parameters XML.IN in Position 1 and XML.OUT in Position 2.
Each type is set to string.
Normally this program is used elsewhere in our other services so it is already
XML ready.
I've converted my test xml to json and tried that. While the error disappears
the response while valid xml (output from the program) is otherwise empty. (I
changed the type from string to json too).
If I key in any random string I get the same valid yet empty program response.
So how do I configure the server to pass this xml string straight to the
subroutine?
Perhaps I need to convert some of the characters (e.g. '/' in the xml below as
per uri requirements?
Is it possible or am I way off course here?
Sample xml:
code
batchRequestsBatchRequestreferenceNumberf549c4dd-01f4-4b9b-99e2-6dd6862cf364/referenceNumberserviceRequestSERVICE
name=VALID.POST.CODEPORTAL_USER_IDtestuser/PORTAL_USER_IDPOSTCODE4300/POSTCODESUBURBGOODNA/SUBURB/SERVICE/serviceRequest/BatchRequest/batchRequests
/code
Converted to json:
code
{batchRequests: {BatchRequest: {referenceNumber:
f549c4dd-01f4-4b9b-99e2-6dd6862cf364,serviceRequest: {SERVICE:
{-name:VALID.POST.CODE,PORTAL_USER_ID: testuser,POSTCODE:
4300,SUBURB: GOODNA}
/code
Many thanks in advance.
Cheers
Peter
[Description: Description:
https://www.firstmac.com.au]http://www.firstmac.com.au/
Peter Cheney
Universe Engineer
t 07 3017 8837 | f 07 3002 8400
e peter.che...@firstmac.com.aumailto:peter.che...@firstmac.com.au | w
www.firstmac.com.auhttps://www.www.firstmac.com.au/
---
Note:
This email (inc all attachments) is for the use of the intended recipient(s)
only.
Privileged or confidential information may be contained in this communication.
If you have received this email in error, please notify the sender immediately
and then delete all copies of this message from your computer network. If you
are not the intended recipient, you must not keep, use, disclose, copy or
distribute this email without the author's prior permission. If you are the
intended recipient and you do not wish to receive similar electronic messages
from us in future, then please respond to the sender to this effect.
We have taken precautions to minimise the risk of transmitting software
viruses, but advise you to carry out your own virus checks on this email and
its attachments. We do not accept liability for any loss or damage caused by
software viruses and do not represent that this transmission is free from
viruses or other defects.
Firstmac Limited (ABN 59 094 145 963) (AFSL 290600)
---
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] resolved: RE: Exchanging XML data instead of JSON between hosts via RESTful Server
Hi Larry,
Sorry, that code was my posting to a forum vs e-mail list brain snap...
I've since discovered that for my XML example (among others) to be included as
the payload for a JSON object then all the JSON illegal chars (e.g. , /, \)
in the XML need to be escaped (e.g. \, \/,\\).
With this basic filter in place both ends I can do what I want and at least
evaluate the results etc. without (yet) having to JSON-ize our code.
I'm also looking into direct socket comms as suggested by our VAR too as well
as SOAP as suggested by Kurt.
Many thanks for the replies.
Cheers
Peter
From: u2-users-boun...@listserver.u2ug.org
[u2-users-boun...@listserver.u2ug.org] on behalf of Larry Hiscock
[lar...@wcs-corp.com]
Sent: Thursday, 22 August 2013 1:29 AM
To: 'U2 Users List'
Subject: Re: [U2] Exchanging XML data instead of JSON between hosts via RESTful
Server
code
{batchRequests: {BatchRequest: {referenceNumber:
f549c4dd-01f4-4b9b-99e2-6dd6862cf364,serviceRequest: {SERVICE:
{-name:VALID.POST.CODE,PORTAL_USER_ID: testuser,POSTCODE:
4300,SUBURB: GOODNA} /code
Curious why you're mixing XML JSON in your converted example?
Shouldn't that read:
{code:
{batchRequests:
{BatchRequest:
{referenceNumber: f549c4dd-01f4-4b9b-99e2-6dd6862cf364,
serviceRequest:
{SERVICE:
{-name:VALID.POST.CODE,
PORTAL_USER_ID: testuser,
POSTCODE: 4300,
SUBURB: GOODNA}
}
}
}
}
}
Larry Hiscock
Western Computer Services
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney
Sent: Wednesday, August 21, 2013 12:30 AM
To: 'U2 Users List' [u2-users@listserver.u2ug.org]
Subject: [U2] Exchanging XML data instead of JSON between hosts via RESTful
Server
Hi Everyone,
Is it possible to configure a RESTful service subroutine to accept XML as
the input to one of its defined parameters?
I keep getting the following error:
500:
Expected+a+','+or+'}'com.rs.u2.u2rest.marshaller.U2JSONTokenizer@13c33b7
The subroutine has 2 parameters XML.IN in Position 1 and XML.OUT in Position
2. Each type is set to string.
Normally this program is used elsewhere in our other services so it is
already XML ready.
I've converted my test xml to json and tried that. While the error
disappears the response while valid xml (output from the program) is
otherwise empty. (I changed the type from string to json too).
If I key in any random string I get the same valid yet empty program
response.
So how do I configure the server to pass this xml string straight to the
subroutine?
Perhaps I need to convert some of the characters (e.g. '/' in the xml below
as per uri requirements?
Is it possible or am I way off course here?
Sample xml:
code
batchRequestsBatchRequestreferenceNumberf549c4dd-01f4-4b9b-99e2-6dd686
2cf364/referenceNumberserviceRequestSERVICE
name=VALID.POST.CODEPORTAL_USER_IDtestuser/PORTAL_USER_IDPOSTCODE43
00/POSTCODESUBURBGOODNA/SUBURB/SERVICE/serviceRequest/BatchReques
t/batchRequests
/code
Converted to json:
code
{batchRequests: {BatchRequest: {referenceNumber:
f549c4dd-01f4-4b9b-99e2-6dd6862cf364,serviceRequest: {SERVICE:
{-name:VALID.POST.CODE,PORTAL_USER_ID: testuser,POSTCODE:
4300,SUBURB: GOODNA} /code
Many thanks in advance.
Cheers
Peter
[Description: Description:
https://www.firstmac.com.au]http://www.firstmac.com.au/
Peter Cheney
Universe Engineer
t 07 3017 8837 | f 07 3002 8400
e peter.che...@firstmac.com.aumailto:peter.che...@firstmac.com.au | w
www.firstmac.com.auhttps://www.www.firstmac.com.au/
---
Note:
This email (inc all attachments) is for the use of the intended recipient(s)
only.
Privileged or confidential information may be contained in this
communication. If you have received this email in error, please notify the
sender immediately and then delete all copies of this message from your
computer network. If you are not the intended recipient, you must not keep,
use, disclose, copy or distribute this email without the author's prior
permission. If you are the intended recipient and you do not wish to receive
similar electronic messages from us in future, then please respond to the
sender to this effect.
We have taken precautions to minimise the risk of transmitting software
viruses, but advise you to carry out your own virus checks on this email and
its attachments. We do not accept liability for any loss or damage caused by
software viruses and do not represent that this transmission is free from
viruses or other defects.
Firstmac Limited (ABN 59 094 145 963) (AFSL 290600)
---
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] ED PERMISSIONS subroutine
If you think it could be DNS related then... Are able to compile a more or less complete list of host names that you are trying to resolve via DNS and placing these in your hosts file on the server with the problem? Ensuring that the hostname search order was files dns (this config file would be windows equivalent of unix /etc/nsswitch.conf). This would let the problem host resolve hostnames locally without the need to go to a (networked) DNS lookup. Then see if that improves the DNS response times? Peter Cheney Universe Engineer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au | w www.firstmac.com.au From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] on behalf of Robert Frailey [rfrai...@utahmed.com] Sent: Wednesday, 21 August 2013 7:46 AM To: U2 Users List Subject: Re: [U2] [UV] ED PERMISSIONS subroutine mine are under /usr/ud I also have /ud as a top level directory - Original Message - From: Bill Haskett wphask...@advantos.net To: U2 Users List u2-users@listserver.u2ug.org Sent: Tuesday, August 20, 2013 3:12 PM Subject: Re: [U2] [UV] ED PERMISSIONS subroutine Diane: I use UniData and always put my accounts underneath a level separate from @UDTHOME (in E:\UDAccounts). I've never had this kind of problem, but have had DNS issues. I wouldn't even contemplate putting anything under C: so have no idea what can happen there. :-( Bill - Original Message - *From:* dia...@aptron.com *To:* U2 Users List u2-users@listserver.u2ug.org *Date:* 8/20/2013 1:29 PM *Subject:* Re: [U2] [UV] ED PERMISSIONS subroutine c:\level contains about 10 universe accounts. All are local directories, none are remote. -Dianne On 8/20/2013 4:24 PM, Aaron Titus wrote: Hi Diane, a couple of questions. How many other directories exist within c:\level ? Is C:\ACCOUNT a local directory and c:\level remote? *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.com On Tue, Aug 20, 2013 at 2:00 PM, Dianne Ackerman dia...@aptron.com wrote: OK, I've found the PERMISSIONS subroutine (APP.PROGS PERMS.B) and have narrowed this issue down more. It's actually a slowness in the basic command STATUS. It's instantaneous in an upper level account (eg C:\ACCOUNT) but takes 4-5 seconds in a lower level account (eg C:\level\ACCOUNT). Any thoughts? Thanks -Dianne On 8/15/2013 9:50 AM, Dianne Ackerman wrote: Does anyone know anything about the -PERMISSIONS subroutine used by the ED verb in Universe? Running 11.1.12 on Windows, the ED verb has a huge delay and we've tracked it down to that subroutine call in the basic ED program. If I could look at that subroutine to see what it's doing, maybe I can figure out what's causing that delay. Thanks! -Dianne ED BP ED.B The file BP is read-only and cannot be updated. 3988 lines long. : L PERMISSIONS 0153: PERMISSIONS = '-PERMISSIONS' : L 0308: CALL @PERMISSIONS(EDIT.FILE,EDIT.**PERM.MODE,EDIT.PERM.IN,EDIT .PERM.OUT) : EX __**_ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/**mailman/listinfo/u2-usershttp://listserver.u2ug.org/mailman/listinfo/u2-users ___ 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 ___ 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 --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do
Re: [U2] Stumped on a WRITE failure
Hi Bob, While I'm no Windows/UD expert I did think of a few things while reading your problem: 1. You say it works every time when you run it from your logged in session. If this were unix I'd say check the PATH in your script. What ever the windows equivalent to unix PATH environment variable is I'd be checking it to make sure that your script environment has access to whatever exe's/resources you need to run. 2. What is the windows equivalent of a unix inode? Can this be changing between when you detect and open the file to when you go to read it? 3. Locks. Someone else mentioned this. Conflicts with backups etc. Hope this is of some help. Cheers Peter Peter Cheney Universe Engineer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au | w www.firstmac.com.au From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] on behalf of Wjhonson [wjhon...@aol.com] Sent: Saturday, 17 August 2013 4:57 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Stumped on a WRITE failure UNschedule the job completely Then REschedule it It says the password data from the time it was scheduled, and when that password gets stale it does not tell you. It just starts failing. Another thought, run a job that can READ the directory of the targeted source. Run this as a Windows BATCH job, not from Universe. This can tell you if for some reason that target location is going OFFline at a critical time. I've seen it. It happens. -Original Message- From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Fri, Aug 16, 2013 11:28 am Subject: Re: [U2] Stumped on a WRITE failure Hi John, Not applicable in this case. The scheduler runs the program every two hours. The files are staged from another server via an OS level COPY and are only something like 5 to 20k. Good thought, though. Thanks. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, August 16, 2013 11:12 AM To: U2 Users List Subject: Re: [U2] Stumped on a WRITE failure Bob, If you are loading data from an outside source, might you be grabbing a data file that is not 100% written to disk? I have seen this a number of times. The 2 solutions to this that I recommend are either: 1) look for a 2nd file that indicates the 1st is 100% complete (be sure to delete the stub file after processing) or 2) look at the size or date/time of the data file, sleep for 10 seconds, then look again. Repeat this process until the criteria does not change Might or might not be applicable in your case. JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, August 16, 2013 2:05 PM To: U2 Users List Subject: Re: [U2] Stumped on a WRITE failure Hi John, It is random and I've not been able to identify a common indicator between the files that work and the ones that don't. The source files are coming in from the other side of the world so it's happening in the very early hours of the morning. By the time I get in, the scheduler has tried to run the program on the bad file a couple of times. I've not tried using COMO, yet. This is exactly why I like this list so much. I'll put this in right away. I'll dig into the udterrorlog file, too, as Colin suggests. Thanks! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Friday, August 16, 2013 10:17 AM To: U2 Users List Subject: Re: [U2] Stumped on a WRITE failure Bob, Can you re-create the error on demand (from the Scheduler) or is it random? Have you tried capturing anything with a COMO? Are these on NEW records, existing records or both? Are the indexes being updated to reflect the writes even if the primary file is not? JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, August 16, 2013 1:09 PM To: U2 Users List Subject: [U2] Stumped on a WRITE failure Hi folks, I have a UNIDATA program that is being run from a Windows Task Schedule entry that is failing on a WRITE statement and I'm having a heck of a time figuring out why. Here are some key observations and discoveries so far: - The WRITE statement has an ON ERROR that is not being executed. - Just before the WRITE statement, FILEINFO shows the file is OPEN and has a permissions value of 6 (R/W). - It does not always fail but when it does fail, it will continue to fail on that input file every time the program is run from the Windows Scheduler. - If I run the program directly, from my logged in session, it works perfectly every time. - Every tool I have says there is nothing wrong
Re: [U2] Universe Configuration --
From my UV9.4 internals manual in the UV data structures chapter... Sizing lock tables... - The file lock table has FSEMNUM (default 23) rows, each with FLTABSZ (default 11) entries. - The group lock table has GSEMNUM (default 23) rows, each with GLTABSZ (default 300) entries. - The record update lock table has GSEMNUM (default 23) rows, each with RLTABSZ (default 300) entries Each row in each table has a semaphore associated with it. The whole chapter talks about semaphore collisions and retries etc when dealing with locks. Further on is another section also called Sizing lock tables that says... Increasing GSEMNUM spreads the concurrent group locks across more rows, reducing the average count of group locks per semaphore. The shorter list reduces the amount of time the semaphore needs to be held to process the tables. This reduced time not only reduces the probability of collision but also reduces the number of retries before the semaphore becomes available. Reducing the processing time also reduces the probability that the time slice will expire while the user owns the semaphore. If the time slice expires while the semaphore is held, other users may put significant load on the system trying to get the semaphore. Further on it says... Shared file locks and shared record locks are handled as linked lists From the UV9.3 system administration manual... RLOWNER - Sets the number of lock owner entries that are maintained for shared (READL) locks in a group lock semaphore set. Great care should be exercised when changing this parameter. The performance of the disk i/o subsystem may be profoundly affected. I've always been advised that the default RLOWNER value of 300 is too big and should be reduced to about 120. So does the above mean that RLOWNER controls the number of entries in a semaphore? HTH Cheers Peter -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Rick Nuckolls Sent: Friday, 16 August 2013 2:33 AM To: 'U2 Users List' Subject: Re: [U2] Universe Configuration -- More research than anything else. We are having an occasional performance problem with one file, and I was checking the lock tables and tuneables. And realized that I might be misinterpreting RLOWNER, since smat-a does not list out a separate table for it, at least that I could see. On some earlier versions of Solaris UV, it is possible to configure the lock tables to be too large for the memory segment, and uvregen will balk. I have not played with this at the current releases. I agree that the default for RLOWNER of 300 does not sound very taxing, but if it really is 300 table entries for each group semaphore x 40 bytes or so, that could add up to a chunk of wasted space. + Okay, I tested a couple of these changes: Changing RLOWNER from 300 + to 400 has no effect on the segment size output of uvregen. Changing + RLOWNER to 2000 also has no effect. Changing the RLTABSZ by 100 upped + the usage by 1.7 M ( GSEMNUM=97). Likewise, bumping GSEMNUM by 10 to + 107 bumped the segment size by 0.52 M. (No units, since it is not + reported by uvregen. It could be bytes or words.) From this, I deduce that RLOWNER, does not affect the size of any tables, rather it might be a limit on the number of users that can concurrently lock a single record using the READL statement. Not sure what else it could be. -Rick -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Aaron Titus Sent: Thursday, August 15, 2013 7:20 AM To: U2 Users List Subject: Re: [U2] Universe Configuration -- I wouldn't be concerned about the default value being too high. The main reason to modify the tunables is to increase them when you are hitting a limit. Years ago, when kernels had very little shared memory in their out-of-the-box configuration, the tunables were set quite low so that Universe would function after installation. With decent sized concurrent users (or lots of phantoms) it would frequently need to be increased. The defaults now are more reasonable. smat -a will show all the lock tables; with that you can see where you are at a given point in time. Increase it if you are reaching the limit but there is no reason to lower them if you are not. *Aaron Titus* Senior Software Engineer F.W. Davison Company, Inc. 508-747-7261 x245 ati...@fwdco.commailto:ati...@fwdco.com On Wed, Aug 14, 2013 at 6:23 PM, Rick Nuckolls r...@lynden.commailto:r...@lynden.com wrote: The link to SQL makes some sense. My original thought was RLOWNER was to Shared Locks (RL) as RLTABSZ is to Exclusive (RU) locks, but the default (300) seemed a little high for tracking RL locks, especially if that is 300 x GSEMNUM. Also, the only reporting that I can find is as
Re: [U2] Removing bad Q-pointers. Good idea or not so much?
If you were worried then you could write the suspect ones off to a log file before you deleted them. Then you could see what the were afterwards if needed? Perhaps also for some reason you might have q-pointer off to another account that may not exist right now but that will be used down the track? Peter Cheney Universe Engineer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au | w www.firstmac.com.au From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] on behalf of Wjhonson [wjhon...@aol.com] Sent: Thursday, 8 August 2013 11:10 AM To: u2-users@listserver.u2ug.org Subject: [U2] Removing bad Q-pointers. Good idea or not so much? Does anyone see any issues with removing Q pointers to files that won't open? 0001 * 0002 * Find Q-pointers that point to nothing, and delete them 0003 * 0004 EQUATE FALSE TO 0, TRUE TO 1 0005 OPEN 'VOC' TO F.VOC ELSE 0006 DISPLAY 'Cannot open VOC file.' ; STOP 0007 END 0008 SELECT F.VOC 0009 DONE = FALSE ; CNT = 0 ; CNT2 = 0 0010 LOOP 0011 READNEXT K.VOC ELSE DONE = TRUE 0012 UNTIL DONE DO 0013 CNT += 1 0014 READ R.VOC FROM F.VOC, K.VOC THEN 0015 IF R.VOC1[1,1] = 'Q' THEN 0016OPEN K.VOC TO F2.VOC ELSE 0017 CNT2 += 1 0018 DISPLAY CNTR#4: :CNT2R#4: :K.VOC 0019 DELETE F.VOC, K.VOC 0020END 0021 END 0022 END 0023 REPEAT 0024 STOP ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mobile phones
An update on this re the google libphonenumber library.
https://code.google.com/p/libphonenumber/
Our web developers have now implemented this to validate the number when it is
entered by the user or our customer service. Apparently it works a treat. Sure
there is a call to google but I've just been told it will validate just about
any rubbish keyed in and reformat to the correct (what ever that may be) format.
Another trade-off is that it apparently adds about 100k to the size of the page
and also increases the page load time slightly but in our view the benefits
outweigh this.
So it looks like we'll be using this now and just storing the validated numbers
in UV.
Cheers
Peter
Peter Cheney
Universe Engineer
t 07 3017 8837 | f 07 3002 8400
e peter.che...@firstmac.com.au | w www.firstmac.com.au
From: u2-users-boun...@listserver.u2ug.org
[u2-users-boun...@listserver.u2ug.org] on behalf of Peter Cheney
[peter.che...@firstmac.com.au]
Sent: Thursday, 11 July 2013 9:47 AM
To: U2 Users List
Subject: Re: [U2] Mobile phones
Hi Symeon,
Interestingly we're facing a similar issue here in Oz whereby we're wanting to
send certain activation codes to our overseas clients for security purposes.
Currently we're doing this for our local clients and apart from the odd modem
failure, have no issues sending to domestic mobile numbers, sending to
international mobiles is proving to be a headache particularly with number
validation and certainty of delivery as others have mentioned.
There is the cost associated with this too. Currently I think it is $0.50 per
international SMS message and given that there's no guarantee of delivery
success, the likelihood of repeated failed attempts is quite real.
Searching around for possible solutions we found these which may be of interest
to you:
Firstly a possible regex solution to validate a number and the related
discussions
/^(\+|\d)[0-9]{7,16}$/;
Reference:
http://stackoverflow.com/questions/5066329/regex-for-valid-international-mobile-phone-number
And then there's this phone number validator:
https://code.google.com/p/libphonenumber/
I've only started playing with the regex this week so do not have a working
solution yet and haven't really looked at the libphonenumber but it may be
useful as a front end validation prior to storing the number in UV.
One other thing I've considered is to not implement mobile number validation at
all. If the number is prefixed with a + then it would be considered an
international destination. As long as the remainder of the number is all
numeric I can send it to our SMS gateway and job is done.
We also have an alternative procedure/screen for customer service to use to
circumvent the international SMS failures and edit/enable the related functions
for those clients overseas.
HTH
Cheers
Peter
Peter Cheney
Universe Engineer
t 07 3017 8837 | f 07 3002 8400
e peter.che...@firstmac.com.au | w www.firstmac.com.au
From: u2-users-boun...@listserver.u2ug.org
[u2-users-boun...@listserver.u2ug.org] on behalf of Symeon Breen
[syme...@gmail.com]
Sent: Wednesday, 10 July 2013 9:11 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Mobile phones
Hi
I have an application that is based in the UK, one of the things it does is
allow entry of a phone number, I then determine if this is a mobile (cell
phone) and send a text (easy in the uk as all mobiles begin with 07)
We are embarking upon our first US client (well existing uk customer with a
US presence) so my question is - how with US phone numbers can I determine
if it is a cell phone ?
Thanks
Symeon.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
---
Note:
This email (inc all attachments) is for the use of the intended recipient(s)
only.
Privileged or confidential information may be contained in this communication.
If you have received this email in error, please notify the sender immediately
and then delete all copies of this message from your computer network. If you
are not the intended recipient, you must not keep, use, disclose, copy or
distribute this email without the author's prior permission. If you are the
intended recipient and you do not wish to receive similar electronic messages
from us in future, then please respond to the sender to this effect.
We have taken precautions to minimise the risk of transmitting software
viruses, but advise you to carry out your own virus checks on this email and
its attachments. We do not accept liability for any loss or damage caused by
software viruses and do not represent that this transmission is free from
viruses or other defects.
Firstmac Limited (ABN 59 094 145 963) (AFSL 290600
Re: [U2] [UV] Auto Starting Applications
You can certainly launch a UV process from a unix script. e.g. #!/usr/bin/bash cd /$path_to_uv_account/$ACCOUNTNAME $UVHOME/bin/uv phantom PROGRAMNAME /somedir/log1.txt $UVHOME/bin/uv LIST SOMEFILE DICTITEM1 DICTITEM2 /somedir/log2.txt You can call this from cron too if required. Cheers Peter Peter Cheney Universe Engineer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au | w www.firstmac.com.au From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] on behalf of Kevin King [ke...@precisonline.com] Sent: Thursday, 11 July 2013 8:34 AM To: U2 Users List Subject: Re: [U2] [UV] Auto Starting Applications Wouldn't a simple startup script suffice - like in /etc/init.d/rc*x*.d (depending on Linux)? On Wed, Jul 10, 2013 at 12:42 PM, Perry Taylor perry.tay...@zirmed.comwrote: What techniques are you folks using to start up apps when UniVerse on Linux is started? Obviously hooking into uv.rc is an option. Are there others? Thanks. Perry Perry Taylor Senior MV Architect Office (877) 494-7633 ext. 4392 Direct (502) 779-4392 ZirMed 888 West Market Street, Suite 400 Louisville, KY 40202 www.zirmed.comhttp://www.zirmed.com/ 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 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 --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Mobile phones
Hi Symeon,
Interestingly we're facing a similar issue here in Oz whereby we're wanting to
send certain activation codes to our overseas clients for security purposes.
Currently we're doing this for our local clients and apart from the odd modem
failure, have no issues sending to domestic mobile numbers, sending to
international mobiles is proving to be a headache particularly with number
validation and certainty of delivery as others have mentioned.
There is the cost associated with this too. Currently I think it is $0.50 per
international SMS message and given that there's no guarantee of delivery
success, the likelihood of repeated failed attempts is quite real.
Searching around for possible solutions we found these which may be of interest
to you:
Firstly a possible regex solution to validate a number and the related
discussions
/^(\+|\d)[0-9]{7,16}$/;
Reference:
http://stackoverflow.com/questions/5066329/regex-for-valid-international-mobile-phone-number
And then there's this phone number validator:
https://code.google.com/p/libphonenumber/
I've only started playing with the regex this week so do not have a working
solution yet and haven't really looked at the libphonenumber but it may be
useful as a front end validation prior to storing the number in UV.
One other thing I've considered is to not implement mobile number validation at
all. If the number is prefixed with a + then it would be considered an
international destination. As long as the remainder of the number is all
numeric I can send it to our SMS gateway and job is done.
We also have an alternative procedure/screen for customer service to use to
circumvent the international SMS failures and edit/enable the related functions
for those clients overseas.
HTH
Cheers
Peter
Peter Cheney
Universe Engineer
t 07 3017 8837 | f 07 3002 8400
e peter.che...@firstmac.com.au | w www.firstmac.com.au
From: u2-users-boun...@listserver.u2ug.org
[u2-users-boun...@listserver.u2ug.org] on behalf of Symeon Breen
[syme...@gmail.com]
Sent: Wednesday, 10 July 2013 9:11 PM
To: u2-users@listserver.u2ug.org
Subject: [U2] Mobile phones
Hi
I have an application that is based in the UK, one of the things it does is
allow entry of a phone number, I then determine if this is a mobile (cell
phone) and send a text (easy in the uk as all mobiles begin with 07)
We are embarking upon our first US client (well existing uk customer with a
US presence) so my question is - how with US phone numbers can I determine
if it is a cell phone ?
Thanks
Symeon.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
---
Note:
This email (inc all attachments) is for the use of the intended recipient(s)
only.
Privileged or confidential information may be contained in this communication.
If you have received this email in error, please notify the sender immediately
and then delete all copies of this message from your computer network. If you
are not the intended recipient, you must not keep, use, disclose, copy or
distribute this email without the author's prior permission. If you are the
intended recipient and you do not wish to receive similar electronic messages
from us in future, then please respond to the sender to this effect.
We have taken precautions to minimise the risk of transmitting software
viruses, but advise you to carry out your own virus checks on this email and
its attachments. We do not accept liability for any loss or damage caused by
software viruses and do not represent that this transmission is free from
viruses or other defects.
Firstmac Limited (ABN 59 094 145 963) (AFSL 290600)
---
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Running total
I believe the expression in the second example is referred to as a compound expression? Can't put my finger on the exact documentation but I seem to recall that compound expressions are broken up into parts (for want of a better term) delimited by a ';' and each part can be referenced throughout the entire expression by an @ number e..g. @1 refers to the first part and the nth part is @n etc. So for: LIST VOC SIZE EVAL SIZE + @2;@ My take on how this works is the the first part of the expression (SIZE + @2) can be referenced later on as @1, The second part is referenced as @ (instead of @2) and I believe is used to refer to the result of the entire expression (sum of all the parts). Can @ in this case also be referenced as @2? It probably could but would break the expression. Therefore the reference to @2 is causing the expression to grab the entire result using contents of @ (via @2 thus keeping it separate to @) and add it to SIZE which then becomes the new result (@) of the expressions and the whole thing is repeated. Does that sound about tight? Or have I got it way wrong? Cheers Peter Peter Cheney Universe Engineer t 07 3017 8837 | f 07 3002 8400 e peter.che...@firstmac.com.au | w www.firstmac.com.au From: u2-users-boun...@listserver.u2ug.org [u2-users-boun...@listserver.u2ug.org] on behalf of Wjhonson [wjhon...@aol.com] Sent: Thursday, 4 July 2013 7:31 AM To: u2-users@listserver.u2ug.org; donr_w...@yahoo.com Subject: Re: [U2] Running total Can anyone explain this situation better. I've only ever used the @ to simplify a few I-descriptors. I have a dict item SIZE that is just the LEN(@RECORD) So in this thread we've seen two EVAL solutions to a running total LIST VOC SIZE EVAL @1+SIZE LIST VOC SIZE EVAL SIZE + @2;@ In the first example is the @1 just saving the previous result of THIS eval ? And then in the second example does the fact that SIZE is first in the Eval, effectively *push* the accumulator into position two or something? So that's why you need @2 ? And then what would be the meaning of ;@ at the end of that? Pretty confusing stuff! ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] TCL input and response logging such as COMO
I guess it depends on what legislation you must comply with for auditing purposes and what you can get away with. If you have to log everything then I'd agree that the unix tee command as others suggest would be best. The following works OK on our AIX dev box but there are a few strange terminal characters in the log file that might make parsing difficult and require some quality time with sed and/or awk. A log roll utility should also be employed to regularly compress and archive the resulting logs once they reach a certain size/age. $ `cat /.uvhome`/bin/uv | tee -a /var/uvlogs/user1.log If you just need to lock down and/or log the relevant UV verbs then remote VOC pointers will do the job. This might include a false TCL program invoked at login or when exiting from the menu (e.g. loop, input, log, execute, repeat) that just logs everything at TCL. Doctoring the TCL verbs for logging/security would require to disable break and possibly make exceptions for any phantoms and other background/batch jobs though which may be more effort to implement thoroughly. HTH Peter -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Scott Zachary Sent: Thursday, 25 April 2013 6:35 To: u2-users@listserver.u2ug.org Subject: [U2] TCL input and response logging such as COMO For PCI compliance, we are tasked to log/capture all TCL entries and responses. I am familiar with COMO, which is one possible solution. 1) What other TCL logging methods are available in UniVerse besides COMO? 2) What AIX Unix tools are available to capture keyboard input and responses at TCL? -- View this message in context: http://u2-universe-unidata.1073795.n5.nabble.com/TCL-input-and-response-logging-such-as-COMO-tp40528.html Sent from the U2 - Users mailing list archive at Nabble.com. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] UV Creating a Soap Request
Hi Everyone, Recently I had some success getting a secure version of this to work etc. but now they want to change it to non-SSL so am trying to get plain old http to work. Using this example as a starting point: https://u2devzone.rocketsoftware.com/accelerate/articles/soap-api I've managed to (I think) translate the example above with our URL and soap action etc. but I have a question regarding the UV SOAPCreateRequest and hope someone may be able to assist. The URL I specify in SOAPCreateRequest is http://our-dev.domain.com/apps/jobs/Services/Job.svc However in the log file I get: 04/16/2013 15:05:16 [ 446706 925928 ] Assembled Request: POST /apps/jobs/Services/Job.svc HTTP/1.1 Date: Tue, 16 Apr 2013 05:05:16 GMT Host: our-dev.domain.com SOAPAction: http://tempuri.org/IJobService/CreateJob1UserPartyRole User-Agent: IBM UniVerse 11.x Content-Type: text/xml; charset=utf-8 Content-Length: 1670 The POST seems to be missing the first part of the URL and with the response being a 400 bad request I'm wondering if there's anything I can do to force the complete URL? In particular is there a SOAP command that I'm missing? Briefly I do the following in this order: Ret = setHTTPDefault( VERSION , 1.1 ) Ret = SOAPSetDefault( VERSION , 1.2 ) Ret = SOAPCreateRequest( URL , SoapAction , SoapReq ) Ret = SOAPSetRequestContent( SoapReq , PAYLOAD , 1 ) Ret = SOAPSubmitRequest( SoapReq, Timeout, RespHeaders, RespData, SoapStatus ) The return codes from above are: setHTTPDefault result = 0 SOAPSetDefault result = 0 SOAPCreateRequest result = 0 SOAPSetRequestContent result = 0 SOAPSubmitRequest result = 0 The SoapStatus from SOAPSubmitRequest above is: Response status : 400▒Bad Request The RespHeaders returned from SOAPSubmitRequest above is: Response headers : Cache-Control▒private▒Server▒Microsoft-IIS/7.5▒X-Powered-By▒4.0.30319▒X-Powered-By▒ASP.NET▒Date▒Tue, 16 Apr 2013 05:46:06 GMT▒Content-Length▒0 To me the soap action seems good and the xml in the payload looks ok too so it has to be something in the delivery. We're running UV 10.3.4 on AIX 5.3. Reckon I must be missing something above so looking at the basic ref manual but it does not indicate if any of the soap commands therein and the above have other dependencies/pre-requisites and in what order they should occur. I guess a prior soap knowledge is expected but I'm just starting to get into this so if anyone can assist that'd be really helpful thanks. Cheers Peter --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV Creating a Soap Request
Thanks again David and Symeon for your replies I thought the SOAPAction was correct but now am not sure. If I browse to the WSDL schema I see the following spec though. Would this mean the 'tempuri.org' should be replaced with 'our-dev.domain.com' in the WSDL too? wsdl:operation name=CreateJob1UserPartyRole soap:operation soapAction=http://tempuri.org/IJobService/CreateJob1UserPartyRole; style=document/ wsdl:input soap:body use=literal/ /wsdl:input wsdl:output soap:body use=literal/ /wsdl:output /wsdl:operation I went and checked out the www.webservicex.net site (from the e.g. below) and looking in there and comparing to what I had and they seem to be pretty much a match except for the domain part of the SOAPAction. So perhaps I need to look elsewhere? There seems to me to be only 3 variables at play here: The URL, the SOAPAction, and the XML request. Given that I've just finished fiddling with the URL and SOAPAction with no apparent change in the log output I'll turn my attention to the XML ... One other question is it possible to query the WSDL from UV? Cheers Peter -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Tuesday, 16 April 2013 17:57 To: U2 Users List Subject: Re: [U2] UV Creating a Soap Request Hi Peter Is your SOAPAction correct?? The tempURI.org is a Microsoft standard placeholder - usually replaced by a proper URI or hostname name, etc. SOAPAction: http://tempuri.org/IJobService/CreateJob1UserPartyRole Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Tuesday, 16 April 2013 4:14 PM To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] UV Creating a Soap Request Hi Everyone, Recently I had some success getting a secure version of this to work etc. but now they want to change it to non-SSL so am trying to get plain old http to work. Using this example as a starting point: https://u2devzone.rocketsoftware.com/accelerate/articles/soap-api I've managed to (I think) translate the example above with our URL and soap action etc. but I have a question regarding the UV SOAPCreateRequest and hope someone may be able to assist. The URL I specify in SOAPCreateRequest is http://our-dev.domain.com/apps/jobs/Services/Job.svc However in the log file I get: 04/16/2013 15:05:16 [ 446706 925928 ] Assembled Request: POST /apps/jobs/Services/Job.svc HTTP/1.1 Date: Tue, 16 Apr 2013 05:05:16 GMT Host: our-dev.domain.com SOAPAction: http://tempuri.org/IJobService/CreateJob1UserPartyRole User-Agent: IBM UniVerse 11.x Content-Type: text/xml; charset=utf-8 Content-Length: 1670 The POST seems to be missing the first part of the URL and with the response being a 400 bad request I'm wondering if there's anything I can do to force the complete URL? In particular is there a SOAP command that I'm missing? Briefly I do the following in this order: Ret = setHTTPDefault( VERSION , 1.1 ) Ret = SOAPSetDefault( VERSION , 1.2 ) Ret = SOAPCreateRequest( URL , SoapAction , SoapReq ) Ret = SOAPSetRequestContent( SoapReq , PAYLOAD , 1 ) Ret = SOAPSubmitRequest( SoapReq, Timeout, RespHeaders, RespData, SoapStatus ) The return codes from above are: setHTTPDefault result = 0 SOAPSetDefault result = 0 SOAPCreateRequest result = 0 SOAPSetRequestContent result = 0 SOAPSubmitRequest result = 0 The SoapStatus from SOAPSubmitRequest above is: Response status : 400▒Bad Request The RespHeaders returned from SOAPSubmitRequest above is: Response headers : Cache-Control▒private▒Server▒Microsoft-IIS/7.5▒X-Powered-By▒4.0.30319▒X-Powered-By▒ASP.NET▒Date▒Tue, 16 Apr 2013 05:46:06 GMT▒Content-Length▒0 To me the soap action seems good and the xml in the payload looks ok too so it has to be something in the delivery. We're running UV 10.3.4 on AIX 5.3. Reckon I must be missing something above so looking at the basic ref manual but it does not indicate if any of the soap commands therein and the above have other dependencies/pre-requisites and in what order they should occur. I guess a prior soap knowledge is expected but I'm just starting to get into this so if anyone can assist that'd be really helpful thanks. Cheers Peter --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish
Re: [U2] UV: Consuming https service from within UVBasic using SOAP
Hi again, Finally had a chance to get back to this and have had success using a slightly modified version of the code here: http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg17243.html After reviewing David's suggestions below and confirming the certificate requirements, the only areas requiring change were the URL (to the https url we had set up), and the path to where our client certificate accessible by UV (e.g. /opt/uv/certificates/Client-Root.cer) This brought some success as I was at least getting a response from the webserver but it was an error code 415 indicating incorrect mime type. e.g. 415 Cannot process the message because the content type 'application/x-www-form-urle. (the output is truncated but is just enough to get an idea of what is wrong) Then I discovered that the http_method parameter for 'POST' in the createSecureRequest function has a default mime type of application/x-www-form-urlencoded so I changed the HTTP.POST variable from POST to POST:application/soap+xml. Hey presto! Now I get this reply from the webserver: e.g. ResponseHeaders : Content-Length▒518▒Content-Type▒application/soap+xml; charset=utf-8▒Server▒Microsoft-IIS/7.0▒X-Powered-By▒ASP.NET▒Date▒Tue, 05 Mar 2013 23:41:35 GMT ResponseData: s:Envelope xmlns:s=http://www.w3.org/2003/05/soap-envelope; xmlns:a=http://www.w3.org/2005/08/addressing;s:Headera:Action s:mustUnderstand=1http://tempuri.org/IJobService/CreateJob1UserPartyRoleResponse/a:Actiona:RelatesTourn:uuid:5af711cc-4ed3-4208-baa1-48aa9f74af60/a:RelatesTo/s:Headers:BodyCreateJob1UserPartyRoleResponse xmlns=http://tempuri.org/;CreateJob1UserPartyRoleResult513682af531c9e1090b67f20/CreateJob1UserPartyRoleResult/CreateJob1UserPartyRoleResponse/s:Body/s:Envelope HttpStatus : 200 OK Many thanks again to David and Symeon for their assistance in this. Cheers Peter PS My code at this stage is only a prototype and is functionally the same as the example in the URL above but if anyone would like a copy then please let me know. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Friday, 22 February 2013 9:33 To: U2 Users List Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP Hi Peter, You easily change that sample source code try amending these lines to access any SSL webserver/appserver. For example the Firstmac.com.au website using SSL by default I see - so that'll be a good site to use as an worked example - that uses a CA Root certificate. Basically, all you'll need a copy of you GeoTrust's root certificate accessible by your (UV SOAP/HTTP) client application. You must upload this (or any other SSL certificate) to your UV host and tell you UV application where it can be found... * Assumes client host can resolve and access this URL * For HTTPS SSL www.firstmac.com.au is using GeoTrust CA certificates, hence upload a DER copy of it first. URL = https://www.firstmac.com.au/home; * Define the full path to the GeoTrust CA Root certificate, uploaded to the host (exported in DER format) X.CERT.PATH=@PATH:/geotrust.cer ;* Full path to a DER copy of GeoTrust CA Root Certificate X.USED.AS=2 ; * 1=Self-signed, 2=CA Issued certificate X.FORMAT=2 ; * DER format X.ALGORITHM=1; * RSA key Hope this helps. The CA Root SSL certificate business is complex and is part of that steep learning curve! Good luck! Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 21 February 2013 11:44 AM To: U2 Users List Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP Hi David, Thanks for the url - am going through this now and the accompanying log. It seems the host not found in hostlist error is not an issues so will continue investigating other causes. I do believe the answer will lie somewhere in my own malformed request so just need to work it out I guess. Will post updates as this progresses. Many thanks, Cheers Peter -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, 20 February 2013 20:17 To: U2 Users List Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP Peter, As Symeon mentioned, protocol logging is required to help troubleshoot issues. If you like to use Firefox, the 'Firebug' plug-in is helpful to see what goes on behind the scenes - but only once you have familiarised yourself with the basic concepts of the HTTP protocol. Otherwise, not much will make much sense... The variable unassigned and UV version, shouldn't be an issue... we got UV
Re: [U2] VOC Pointer
How about using scp with public/private key authentication running from a unix cron to scp from the windows host to a dir on the unix host? Requires ssh installed on both hosts. I've also installed Cygwin on a windows host in the past and used that for the ssh/scp component as you get a nice unix flavour when you ssh in remotely. Alternatively as someone has already said try using smbmount to mount a windows share on a unix dir and use unix cp or mv. Requires samba installed on your HPUX host and that install must have the smbmount (or equivalent) utility. You could also use ftp to fetch the files from the windows server. Requires ftp server installed on windows host. All the above could be driven from within a UD/UV basic program. HTH Peter -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Israel, John R. Sent: Tuesday, 5 March 2013 7:12 To: U2 Users List Subject: Re: [U2] VOC Pointer I have done things from Window to UNIX with Samba before. As you say, we do it all the time. The issue I have is I need my Unix box to grab the data from Windows and copy it from Windows to Unix. The copy needs to be run from Unix, not Windows. THAT is the problem I am having. Mapping a network drive in Windows will be great from Windows, but will not solve the problem of issuing the command from Unix (unless I am completely missing the point). JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of John Thompson Sent: Monday, March 04, 2013 4:06 PM To: U2 Users List Subject: Re: [U2] VOC Pointer If copying from the windows server to the HP-UX machine... If you use the samba method... you would need: 1) Samba installed on HP-UX server running Unidata 2) Setup a share to share a directory on HP-UX 3) Map the network drive on the Windows Server 4) Just do a standard windows copy from one drive letter to the other That being said, my steps above are grossly over-simplified If you have never done a samba install on HP-UX and configuration before, this could take you several days/weeks. If its a one time deal, then the previous posters idea of ftp, is so much easier. Its been a number of years, since I put samba on HP-UX. If you can find a package that utilizes swinstall (sam) somewhere out on the web, it might make your life easier. On Mon, Mar 4, 2013 at 3:55 PM, Israel, John R. johnisr...@daytonsuperior.com wrote: We have used Samba other ways, but I have never actually tried to copy from Windows to Unix. What would the syntax be to copy? Thanks JRI -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Monday, March 04, 2013 3:45 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] VOC Pointer On 04/03/13 20:36, Israel, John R. wrote: I need to copy PDFs from a Windows server into a UNIX dir (where UniData lives). Can I map a VOC pointer? Can the unix machine see a windows share? You MAY be able to put a network path in field 2 of a voc entry, but by default, if UD recognises a network path it'll probably refuse to access it. And is copying PDFs (binary files) using the UD command line a good idea? Other thoughts? Put samba on the HPUX box, share your HPUX directory, and copy the pdfs from Windows to nix. Or if you need to do it from the nix end, share your Windows directory and use smbmount (probably part of samba, I'm not quite sure what's happened to it) to make the windows share look like a nix directory where you can use nix commands to copy. Running HPUX, UniData 7.2.1. John Cheers, Wol ___ 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 -- John Thompson ___ 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 --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the
Re: [U2] UV: Consuming https service from within UVBasic using SOAP
Thanks David, I have obtained a client certificate that I hope will work and will try when I get a chance. Many thanks for your support and advice. Cheers Peter -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Friday, 22 February 2013 9:33 To: U2 Users List Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP Hi Peter, You easily change that sample source code try amending these lines to access any SSL webserver/appserver. For example the Firstmac.com.au website using SSL by default I see - so that'll be a good site to use as an worked example - that uses a CA Root certificate. Basically, all you'll need a copy of you GeoTrust's root certificate accessible by your (UV SOAP/HTTP) client application. You must upload this (or any other SSL certificate) to your UV host and tell you UV application where it can be found... * Assumes client host can resolve and access this URL * For HTTPS SSL www.firstmac.com.au is using GeoTrust CA certificates, hence upload a DER copy of it first. URL = https://www.firstmac.com.au/home; * Define the full path to the GeoTrust CA Root certificate, uploaded to the host (exported in DER format) X.CERT.PATH=@PATH:/geotrust.cer ;* Full path to a DER copy of GeoTrust CA Root Certificate X.USED.AS=2 ; * 1=Self-signed, 2=CA Issued certificate X.FORMAT=2 ; * DER format X.ALGORITHM=1; * RSA key Hope this helps. The CA Root SSL certificate business is complex and is part of that steep learning curve! Good luck! Cheers, David -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: Thursday, 21 February 2013 11:44 AM To: U2 Users List Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP Hi David, Thanks for the url - am going through this now and the accompanying log. It seems the host not found in hostlist error is not an issues so will continue investigating other causes. I do believe the answer will lie somewhere in my own malformed request so just need to work it out I guess. Will post updates as this progresses. Many thanks, Cheers Peter -Original Message- From: u2-users-boun...@listserver.u2ug.orgmailto:u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, 20 February 2013 20:17 To: U2 Users List Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP Peter, As Symeon mentioned, protocol logging is required to help troubleshoot issues. If you like to use Firefox, the 'Firebug' plug-in is helpful to see what goes on behind the scenes - but only once you have familiarised yourself with the basic concepts of the HTTP protocol. Otherwise, not much will make much sense... The variable unassigned and UV version, shouldn't be an issue... we got UV SOAP going on UV10.1 ...years ago... using the IBM UV sample code mentioned in this URL: http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg17243.html We cloned this code for a proof of concept and our version worked for us (if I recall correctly)... Obviously (maybe not), this is sample code in the URL will not actually work anymore - if actually did all those years ago (I can't recall) but it should give you a heads-up so to speak and point you in the right direction (more or less - hopefully more!)... Regards, David ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies
Re: [U2] UV: Consuming https service from within UVBasic using SOAP
Thankyou Symeon that logging info is gold... I can see now that I'm getting a host test.hostname.com:443 not found in hostlist error so will be investigating that further. Also if you can send me the https post sub that you've mentioned below I'd be keen to see how that works as well. Many thanks for your help Peter -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Symeon Breen Sent: Wednesday, 20 February 2013 19:09 To: 'U2 Users List' Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP Hi - the first port of call is to enable the protocol logging E.G. err=protocolLogging(SoapTest.log,ON,10) You can then look at the log for errors Does The https end point you are using allow self certification authentication? If not you may need to do a bit more work on certificates. Restful webservices are nothing magical, it is still just a http(s) endpoint , the difference is you normally send more info in the path as well as post data, and you use the http verbs - Seriously I would encourage you to read up about http so you understand what is going on underneath - it is pretty simple its only a text conversation over a socket, you can do http conversations via telnet, or use a tool outside of uv like curl/wget on linux or wfetch on windows just to see what headers are being passed etc. Also if you want -I can email you my simple https post sub I use with endpoints that allow self cert -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Peter Cheney Sent: 20 February 2013 07:57 To: U2 Users List (u2-users@listserver.u2ug.org) Subject: [U2] UV: Consuming https service from within UVBasic using SOAP Hi Everyone, Think I'm suffering a bit from old dog new trick syndrome... Been reading up on and playing with the Soap functions in UV basic but can't seem to get any joy with https url that I've been supplied to use. Was wondering if anyone might have some advice? In particular I've been playing with the code examples here: https://u2devzone.rocketsoftware.com/accelerate/articles/soap-api/soap-api Also came across this in which I recognised some of the list members: http://comments.gmane.org/gmane.comp.db.u2.general/67904 Upgrading to UV11.1.9 may well be a better choice with availability of Dynamic Objects for JSON but we're stuck with 10.3.4 for a good while yet due to other constraints. Code: Ret = SoapCreateRequest(URL , SoapAction , SoapReq) vs Ret = SoapCreateSecureRequest(URL , SoapAction , SoapReq , SecHandle) For the https url I tried using the SoapCreateSecureRequest but when I compile I get a variable unassigned for the 3rd SoapReq parameter. Is our UV version the issue here? Another thought I had was that the security_handle variable is somehow affecting the other variables. Using the SoapCreateRequest function the program compiles OK with no errors (the 3rd SoapReq parameter is assigned OK however I get an error 2 - network subsystem failure for the https url. If I point at the http url then I at least get a 404 not found. I can also telnet from the host to both ports 80 and 443 no worries so comms appear OK. The project is required to fire off DB events into our new workflow system hence my focus in this direction. Have also read about just writing a message to a pipe etc and other intermediate solutions as per the above but it'd be real nice if I can get this working via soap. Oh and one other question please. Is it possible to have a UV basic program communicate with or consume / use a restful http service? I may have my wires crossed here so please set me straight. I've seen examples of (and we currently use) a web front end accessing a UV db but not the other way around. Many thanks in advance for your time. Cheers Peter --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac
Re: [U2] UV: Consuming https service from within UVBasic using SOAP
Hi David, Thanks for the url - am going through this now and the accompanying log. It seems the host not found in hostlist error is not an issues so will continue investigating other causes. I do believe the answer will lie somewhere in my own malformed request so just need to work it out I guess. Will post updates as this progresses. Many thanks, Cheers Peter -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hona, David Sent: Wednesday, 20 February 2013 20:17 To: U2 Users List Subject: Re: [U2] UV: Consuming https service from within UVBasic using SOAP Peter, As Symeon mentioned, protocol logging is required to help troubleshoot issues. If you like to use Firefox, the 'Firebug' plug-in is helpful to see what goes on behind the scenes - but only once you have familiarised yourself with the basic concepts of the HTTP protocol. Otherwise, not much will make much sense... The variable unassigned and UV version, shouldn't be an issue... we got UV SOAP going on UV10.1 ...years ago... using the IBM UV sample code mentioned in this URL: http://www.mail-archive.com/u2-users@listserver.u2ug.org/msg17243.html We cloned this code for a proof of concept and our version worked for us (if I recall correctly)... Obviously (maybe not), this is sample code in the URL will not actually work anymore - if actually did all those years ago (I can't recall) but it should give you a heads-up so to speak and point you in the right direction (more or less - hopefully more!)... Regards, David ** IMPORTANT MESSAGE * This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. We can be contacted through our web site: commbank.com.au. If you no longer wish to receive commercial electronic messages from us, please reply to this e-mail by typing Unsubscribe in the subject line. ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] AIX 5.3 IBMIHS Web Server
Perhaps a silly question but it's not something as simple as file permissions or owner/group membership or environment path is it? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Wednesday, 20 February 2013 10:03 To: U2 Users List Subject: Re: [U2] AIX 5.3 IBMIHS Web Server Yes, I have both the LoadModule and Listen, though my Listen is unqualified, like this: Listen 443 The error I'm getting in the logs tells me there is no key for api or api.client.com (I've tried both) despite the fact that gsk7cmd shows that the certificate absolutely is in there. That's what's vexing; I can see the certificate, but for some reason Apache cannot. You don't suppose the unqualified Listen might have something to do with it, do you? On Tue, Feb 19, 2013 at 11:19 AM, John Hester jhes...@momtex.com wrote: Kevin, I have both chained and self-signed certs on various servers. The example from my workstation is a self-signed cert. Self-signed is actually less prone to error because you don't have to worry about importing the intermediate certs into the keystore database. The only other thing I know to suggest at the moment is verify you're loading the IBM ssl module and listening on port 443: LoadModule ibm_ssl_module modules/mod_ibm_ssl.so Listen 0.0.0.0:443 Are you getting any errors in the IHS SSL logs, either at server startup or when you attempt to browse to port 443? -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Monday, February 18, 2013 5:04 PM To: U2 Users List Subject: Re: [U2] AIX 5.3 IBMIHS Web Server John (Thompson)... This IHS Apache is definitely a cracked Apache with some odd configuration SSL setup in particular is completely different. John (Hester), I can see the cert in the key file (through the gsk7cmd command) but with the name api.client.com it cannot be found. I even recreated the cert as api (without dots) because I found a page that said that the dots could be causing problems, but still no love. It seems I've done everything correctly but still it just can't find a combination that works. I'm wondering if the problem here is the fact that it's a self-signed cert without a chain? Are you using a self-signed cert here? Do you have other certs in your key file that may represent a chain for the self-signed cert? Thank you gentlemen for the insight. Most appreciated. -K On Mon, Feb 18, 2013 at 3:09 PM, John Hester jhes...@momtex.com wrote: It sounds like you've done all you need to for basic IHS SSL functionality. As long as api.client.com matches the name you gave the certificate via ikeyman, and you have the KeyFile directive, you should be OK. There are a lot of other options you can add for optimization and browser compatibility, but I don't think leaving any of those out would break it outright. Here's my working IHS config from the development server on my Windows workstation for comparison: VirtualHost *:443 SSLEnable SSLProtocolDisable SSLv2 SSLServerCert is12.momtex.com Directory c:/IBM/HTTPServer/htdocs/html Options +Includes AddType text/html .shtml AddOutputFilter INCLUDES .shtml /Directory /VirtualHost KeyFile C:/IBM/HTTPServer/key.kdb SSLDisable -John -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Saturday, February 16, 2013 4:02 PM To: U2 Users List Subject: [U2] AIX 5.3 IBMIHS Web Server Might anyone have any tips or tricks for getting SSL to work on the IBMIHS/Apache 2.0.47 web server on an AIX 5.3 box? The documentation I've found on the web is byzantine at best and it would be fine if the commands actually worked, but I keep getting odd error messages and stalled at every turn. I've upgrade the GSK so that the server will start with SSL enabled, I have a virtual host configured, but I have no clue how to tie a specific certificate to the VirtualHost. Well, let's say I have clues, but nothing is working. Here's the VirtualHost stanza I have set up in httpd.conf: VirtualHost *:443 SSLEnable SSLClientAuth None SSLServerCert api.client.com ServerName api.client.com DocumentRoot /usr/www Directory /usr/www Order Allow,Deny Allow From All /Directory ErrorLog logs/api_error.log CustomLog logs/api_error.log common /VirtualHost I've been able to generate a CSR and create a self-signed certificate, and it would appear that I've even successfully imported that certificate into my key database, as demonstrated by this command: $ gsk7cmd -cert
[U2] UV: Consuming https service from within UVBasic using SOAP
Hi Everyone, Think I'm suffering a bit from old dog new trick syndrome... Been reading up on and playing with the Soap functions in UV basic but can't seem to get any joy with https url that I've been supplied to use. Was wondering if anyone might have some advice? In particular I've been playing with the code examples here: https://u2devzone.rocketsoftware.com/accelerate/articles/soap-api/soap-api Also came across this in which I recognised some of the list members: http://comments.gmane.org/gmane.comp.db.u2.general/67904 Upgrading to UV11.1.9 may well be a better choice with availability of Dynamic Objects for JSON but we're stuck with 10.3.4 for a good while yet due to other constraints. Code: Ret = SoapCreateRequest(URL , SoapAction , SoapReq) vs Ret = SoapCreateSecureRequest(URL , SoapAction , SoapReq , SecHandle) For the https url I tried using the SoapCreateSecureRequest but when I compile I get a variable unassigned for the 3rd SoapReq parameter. Is our UV version the issue here? Another thought I had was that the security_handle variable is somehow affecting the other variables. Using the SoapCreateRequest function the program compiles OK with no errors (the 3rd SoapReq parameter is assigned OK however I get an error 2 - network subsystem failure for the https url. If I point at the http url then I at least get a 404 not found. I can also telnet from the host to both ports 80 and 443 no worries so comms appear OK. The project is required to fire off DB events into our new workflow system hence my focus in this direction. Have also read about just writing a message to a pipe etc and other intermediate solutions as per the above but it'd be real nice if I can get this working via soap. Oh and one other question please. Is it possible to have a UV basic program communicate with or consume / use a restful http service? I may have my wires crossed here so please set me straight. I've seen examples of (and we currently use) a web front end accessing a UV db but not the other way around. Many thanks in advance for your time. Cheers Peter --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Record locks (Unidata 7.2)
In the example below what happens to the lock? Does it release if the write is not executed? If not shouldn't you have a RELEASE statement at the end after the last END? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jon Wells Sent: Saturday, 9 February 2013 3:57 To: U2 Users List Subject: Re: [U2] Record locks (Unidata 7.2) I should add that (in our test account) I switched to the READU statement along with a LOCKED clause - READU STU.REC FROM STU.FILE, STU.ID LOCKED CRT STU.ID: RECORD IS LOCKED END THEN STU.REC48 = INST.CRED STU.REC49 = INET.CRED WRITE STU.REC ON STU.FILE, STU.ID END I locked one of the records in the list I was processing. When the program was working on that record, the CRT statement was executed, and the program moved right along processing the rest of the list; and record I had locked was not updated. Looking through the 'UniBasic Commands Reference' PDF, I found 'RECORDLOCKED (file.var, rec.id.expr)'. Perhaps this could be used within a LOOP to control things, allowing terminal input where the user can choose what to do about the record lock? I've decided to write the data to a new file, so this is no longer a big issue for me. If I had created the program using our vendor's tool kit, the generated code would have added all the appropriate gunk the system uses for record locks. The responses have been interesting as I've been looking for a chance to better understand how Unidata shops handle locks. Thank you, Jon Wells From: Tony Gravagno 3xk547...@sneakemail.com To: u2-users@listserver.u2ug.org Sent: Friday, February 8, 2013 2:30 AM Subject: Re: [U2] Record locks (Unidata 7.2) I think people understand exactly what you're saying, but disagree. Most applications don't use the more rigorous coding for having a Locked clause that provides additional information to the user, retries, etc. That's not wrong, it's just not necessary ... depending on the site. That said, when we used to have a lot of people in an office and a dumb terminal beeping was a recognized message to everyone, it was OK (generally) to just do the READU. These days with more alternative UIs, thick-client, thin-client, web services, mobile, etc, there's no one to hear that beep. So for modern development I would agree that you really don't want an unconditional lock hanging around, you want a Locked clause with logic to rollback the transaction and exit gracefully, perhaps with a message sent to the site admin. The penalty for Not having a Locked clause with a new UI is that the port will hang, the UI will receive a timeout (which many clients aren't prepared to process), and the DBMS port could be sitting there indefinitely with no one aware of the condition. This can cascade to multiple ports until suddenly everything grinds to a halt and GUI users around the world are unable to access the app. I believe some heads will be nodding here because I hear about this happening occasionally. T From: Wjhonson Then you're misunderstanding what I'm saying. From: Kevin King +1. Well stated. Woodward, Bob wrote: In an active user session where users are obtaining a lock for a length of time, you're right. There are lots of times, though, that lock intervention is not a benefit. It all depends on the need of the application and many situations where I would highly recommend using the default locking system of READU. From: Wjhonson I wouldn't however *recommend* this approach to locking as the user can never tell if their terminal is waiting on a lock, or just hung in some other odd manner, or perhaps processing a batch of something. So it's rather a nasty trick to play on the user, to just use READU without a LOCKED clause ___ 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 --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses,
[U2] : Evaluating DCOUNT
Hi Everyone, Does a DCOUNT get evaluated again for each iteration of a loop? Or is UniVerse these days intelligent enough to keep track of what's going on? e.g. for i = 1 to dcount(array,@fm) *commands here next i versus totalattributes = dcount(array,@fm) for i = 1 to totalattributes *commands here next i Apart from readability and perhaps easier debugging is there an actual internal difference? I know it was an issue on older pick releases but I cannot remember if it ever affected UV? Cheers Peter --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Record locks (Unidata 7.2)
I think it would also be useful to add some form of exit routine inside the LOCKWAIT loop. Something like a counter to only allow say 10 attempts at trying to obtain the lock. That way you don't keep looping for ever if some other process which has the lock does not release it for whatever reason. Cheers Peter -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Woodward, Bob Sent: Friday, 8 February 2013 7:02 To: Jon Wells; U2 Users List Subject: Re: [U2] Record locks (Unidata 7.2) With the LOCKED clause included, the READU does not pause. You can put anything you want in that section but just realize that the statement fully executes and proceeds to the next command. If you want to simulate wait until I obtain the lock then you just have to create this into a small loop. Something like this: LOCKWAIT: READU xxx FROM yyy, zzz LOCKED Xxx commands, if you want to do anything other than just loop GOTO LOCKWAIT END THEN Xxx got the lock and have read the record so do whatever Xxx14 = I was here END ELSE Xxx got the lock but it's a new record. Xxx = Xxx14 = I was here END Do some more stuff. WRITE xxx ON yyy, zzz You don't HAVE to do anything in the locked section other than just goto your label. You could add a small delay, if you wanted, just so your process isn't in a super tight loop chewing up all your computers horsepower. Also, remember, you need to do something with the lock, even if it's a new record. Either a WRITE or RELEASE statement on the zzz key value. BobW -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jon Wells Sent: Thursday, February 07, 2013 12:47 PM To: U2 Users List Subject: Re: [U2] Record locks (Unidata 7.2) What I'm wondering is; what can I put into the 'Xxx what to do if locked' section whereby it waits until the record lock clears, once it clears, set my own lock, read the record, alter the record, and then write the record (which would release my lock)? Thank you, Jon Wells From: Woodward, Bob bob_woodw...@k2sports.com To: U2 Users List u2-users@listserver.u2ug.org Sent: Thursday, February 7, 2013 12:35 PM Subject: Re: [U2] Record locks (Unidata 7.2) Sorry Mecki but I think you have the LOCKED in the wrong place. At least in my version of Unidata. It comes before the THEN segment so the full, proper syntax would be: READU xxx FROM xxx, xxx ON ERROR Xxx what to do if a hard error like file not open END LOCKED Xxx what to do if locked END THEN Xxx what to do if lock is obtained and record is read END ELSE Xxx what to do if lock is obtained but record does not exist. END There is a second format for the READU command but it's a lot easier if the OP just reads about, himself, in the HELP information. HELP UNIBASIC READU from ECL in Unidata will get him that. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Mecki Foerthmann Sent: Thursday, February 07, 2013 12:27 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Record locks (Unidata 7.2) The READU statement has a LOCKED clause that is true if a record is locked. You can put all your locking ha logic in there. READU record FROM filevariable,itemID THEN code if record exists and isn't locked (optional) LOCKED code to handle locked record condition (optional) END ELSE code if record doesn't exist (required) END Now if you put that into a loop you can display a message and give the user the option to try again or abort. And if you put the code into a subroutine you can use that in all your programs with a single line like this. CALL SR.READU(record,filevariable,ItemID,Option,Err) On 06/02/2013 21:52, Jon Wells wrote: Hi all, I have not looked at the world of record locks since my R83 Pick days. I'm hoping to add the ability for the program I'm working on to: * Check if a record is locked * Wait until the lock is removed * Once the lock is removed, or if the record is not locked: * Lock the record * Perform the WRITE statement I'm hoping someone can share an example of how to accomplish this in UniBasic. Thank you, Jon Wells Campbell University ___ 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 ___ 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] UV: Generating XML from Retrieve
Hi Jeff, Thanks for the reply. We had a look at the document you mentioned and found a few tips within. I ended up adding a map item in the XML file which we're deploying tomorrow. Cheers Peter -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeff Schasny Sent: Wednesday, 6 February 2013 3:03 To: U2 Users List Subject: Re: [U2] UV: Generating XML from Retrieve You might take a look at Cedarrville's DOWNLOAD utility ftp://ftp.cedarville.edu/download/download.pdf Peter Cheney wrote: Hi Everyone, Hoping someone can help me here or at least point me in the right direction please. I am trying to generate xml output via a retrieve sentence so that a single valued field is either a) the parent to 3 multi-valued fields, or b) nested correctly within a parent element along with multi-valued fields. The sentence is using the TOXML and ELEMENTS keywords. According to the retrieve manual due to the inclusion of the ELEMENTS keyword the output is element-centric. I think what I need to do is specify attribute-centric output for just the few dictionary items listed below. According to the manual this is called Mixed Mode. Can this be done in a mapping file? Also can I use a file other than XML to store a custom mapping file? If so how do I do this? (Why? Because some genius designed our app to use the XML file for other data as well and as a consequence it gets cleared out regularly.) Will a mapping file allow me to customise how the dictionary items are output and can this output be nested as desired below? I've already made an association called PENDING_AUTHS for the three MV'd fields AUTH_NUMBER, AUTH_DATE, AUTH_AMOUNT and these are all converted but in the element centric mode thus: FILENAME2 _ID9/_ID REPAY_AMOUNT538.99/REPAY_AMOUNT NEXT_DUE02 SEP 2012/NEXT_DUE AUTH_TOTAL99.00/AUTH_TOTAL PENDING_AUTHS_MV AUTH_NUMBER123456/AUTH_NUMBER AUTH_DATE22/01/13/AUTH_DATE AUTH_AMOUNT40.00/AUTH_AMOUNT /PENDING_AUTHS_MV PENDING_AUTHS_MV AUTH_NUMBER654321/AUTH_NUMBER AUTH_DATE23/01/13/AUTH_DATE AUTH_AMOUNT59.00/AUTH_AMOUNT /PENDING_AUTHS_MV If I change the dictionary item AUTH_TOTAL from S to M and add it to the association then I get that repeated within the PENDING_AUTHS node, the first one has the data and the remainder are empty like this: FILENAME2 _ID9/_ID REPAY_AMOUNT538.99/REPAY_AMOUNT NEXT_DUE02 SEP 2012/NEXT_DUE PENDING_AUTHS_MV AUTH_TOTAL99.00/AUTH_TOTAL AUTH_NUMBER123456/AUTH_NUMBER AUTH_DATE22/01/13/AUTH_DATE AUTH_AMOUNT40.00/AUTH_AMOUNT /PENDING_AUTHS_MV PENDING_AUTHS_MV AUTH_TOTAL/ AUTH_NUMBER654321/AUTH_NUMBER AUTH_DATE23/01/13/AUTH_DATE AUTH_AMOUNT59.00/AUTH_AMOUNT /PENDING_AUTHS_MV So I tried to wrap this a basic subroutine but I couldn't get that to work either since I couldn't work out the correct syntax of the array to return. Is there a place that documents this? Everything I tried just mangled the data. Ideally what I'd like to get is something like this: FILENAME2 _ID9/_ID REPAY_AMOUNT538.99/REPAY_AMOUNT NEXT_DUE02 SEP 2012/NEXT_DUE AUTHS TOTAL=99.00 AUTH NUMBER=123456 DATE=22/01/13 AMOUNT=40.00/AUTH AUTH_NUMBER=654321 DATE=23/01/13 AMOUNT=59.00/AUTH /AUTHS or even this would do: FILENAME2 _ID9/_ID REPAY_AMOUNT538.99/REPAY_AMOUNT NEXT_DUE02 SEP 2012/NEXT_DUE PENDING_AUTHS_MV TOTAL99.00/TOTAL AUTH AUTH_NUMBER123456/AUTH_NUMBER AUTH_DATE22/01/13/AUTH_DATE AUTH_AMOUNT40.00/AUTH_AMOUNT /AUTH AUTH AUTH_NUMBER654321/AUTH_NUMBER AUTH_DATE23/01/13/AUTH_DATE AUTH_AMOUNT59.00/AUTH_AMOUNT /AUTH /PENDING_AUTHS_MV Not really fussy about the element names. Just wondering if I can achieve the correct element structure/nesting if I employ a mapping to create a mixed mode xml document? Any tips for where to start with the mapping? Do I need to specify all map elements or can I leave out unwanted ones to their system defaults? Will this map affect all xml output in the same file or just those dictionary items specifically in the map? Many thanks in advance, Cheers Peter Dictionary items PENDING_AUTHS 2 lines long. : P 0001: PH 0002: AUTH_NUMBER AUTH_DATE AUTH_AMOUNT Bottom at line 2. : EX AUTH_TOTAL SELECTed record name = AUTH_TOTAL. This is a Type I Descriptor last compiled on 05/02/13 at 09:49. 20 lines long. : L7 0001: I 0002: EXTRACT(RAISE(TRANS(FILENAME1,ACCOUNT,10,X)),1,1,1) 0003: MD2 0004: Total▒Auths. 0005: 15R 0006: S 0007: : EX AUTH_NUMBER SELECTed record name = AUTH_NUMBER. This is a Type I Descriptor last compiled on 05/02/13 at 10:24. 20 lines long. : L7 0001: I 0002: EXTRACT(RAISE(TRANS(FILENAME1,ACCOUNT,11,X)),1,0,0) 0003: 0004: Auth
[U2] UV: Generating XML from Retrieve
Hi Everyone, Hoping someone can help me here or at least point me in the right direction please. I am trying to generate xml output via a retrieve sentence so that a single valued field is either a) the parent to 3 multi-valued fields, or b) nested correctly within a parent element along with multi-valued fields. The sentence is using the TOXML and ELEMENTS keywords. According to the retrieve manual due to the inclusion of the ELEMENTS keyword the output is element-centric. I think what I need to do is specify attribute-centric output for just the few dictionary items listed below. According to the manual this is called Mixed Mode. Can this be done in a mapping file? Also can I use a file other than XML to store a custom mapping file? If so how do I do this? (Why? Because some genius designed our app to use the XML file for other data as well and as a consequence it gets cleared out regularly.) Will a mapping file allow me to customise how the dictionary items are output and can this output be nested as desired below? I've already made an association called PENDING_AUTHS for the three MV'd fields AUTH_NUMBER, AUTH_DATE, AUTH_AMOUNT and these are all converted but in the element centric mode thus: FILENAME2 _ID9/_ID REPAY_AMOUNT538.99/REPAY_AMOUNT NEXT_DUE02 SEP 2012/NEXT_DUE AUTH_TOTAL99.00/AUTH_TOTAL PENDING_AUTHS_MV AUTH_NUMBER123456/AUTH_NUMBER AUTH_DATE22/01/13/AUTH_DATE AUTH_AMOUNT40.00/AUTH_AMOUNT /PENDING_AUTHS_MV PENDING_AUTHS_MV AUTH_NUMBER654321/AUTH_NUMBER AUTH_DATE23/01/13/AUTH_DATE AUTH_AMOUNT59.00/AUTH_AMOUNT /PENDING_AUTHS_MV If I change the dictionary item AUTH_TOTAL from S to M and add it to the association then I get that repeated within the PENDING_AUTHS node, the first one has the data and the remainder are empty like this: FILENAME2 _ID9/_ID REPAY_AMOUNT538.99/REPAY_AMOUNT NEXT_DUE02 SEP 2012/NEXT_DUE PENDING_AUTHS_MV AUTH_TOTAL99.00/AUTH_TOTAL AUTH_NUMBER123456/AUTH_NUMBER AUTH_DATE22/01/13/AUTH_DATE AUTH_AMOUNT40.00/AUTH_AMOUNT /PENDING_AUTHS_MV PENDING_AUTHS_MV AUTH_TOTAL/ AUTH_NUMBER654321/AUTH_NUMBER AUTH_DATE23/01/13/AUTH_DATE AUTH_AMOUNT59.00/AUTH_AMOUNT /PENDING_AUTHS_MV So I tried to wrap this a basic subroutine but I couldn't get that to work either since I couldn't work out the correct syntax of the array to return. Is there a place that documents this? Everything I tried just mangled the data. Ideally what I'd like to get is something like this: FILENAME2 _ID9/_ID REPAY_AMOUNT538.99/REPAY_AMOUNT NEXT_DUE02 SEP 2012/NEXT_DUE AUTHS TOTAL=99.00 AUTH NUMBER=123456 DATE=22/01/13 AMOUNT=40.00/AUTH AUTH_NUMBER=654321 DATE=23/01/13 AMOUNT=59.00/AUTH /AUTHS or even this would do: FILENAME2 _ID9/_ID REPAY_AMOUNT538.99/REPAY_AMOUNT NEXT_DUE02 SEP 2012/NEXT_DUE PENDING_AUTHS_MV TOTAL99.00/TOTAL AUTH AUTH_NUMBER123456/AUTH_NUMBER AUTH_DATE22/01/13/AUTH_DATE AUTH_AMOUNT40.00/AUTH_AMOUNT /AUTH AUTH AUTH_NUMBER654321/AUTH_NUMBER AUTH_DATE23/01/13/AUTH_DATE AUTH_AMOUNT59.00/AUTH_AMOUNT /AUTH /PENDING_AUTHS_MV Not really fussy about the element names. Just wondering if I can achieve the correct element structure/nesting if I employ a mapping to create a mixed mode xml document? Any tips for where to start with the mapping? Do I need to specify all map elements or can I leave out unwanted ones to their system defaults? Will this map affect all xml output in the same file or just those dictionary items specifically in the map? Many thanks in advance, Cheers Peter Dictionary items PENDING_AUTHS 2 lines long. : P 0001: PH 0002: AUTH_NUMBER AUTH_DATE AUTH_AMOUNT Bottom at line 2. : EX AUTH_TOTAL SELECTed record name = AUTH_TOTAL. This is a Type I Descriptor last compiled on 05/02/13 at 09:49. 20 lines long. : L7 0001: I 0002: EXTRACT(RAISE(TRANS(FILENAME1,ACCOUNT,10,X)),1,1,1) 0003: MD2 0004: Total▒Auths. 0005: 15R 0006: S 0007: : EX AUTH_NUMBER SELECTed record name = AUTH_NUMBER. This is a Type I Descriptor last compiled on 05/02/13 at 10:24. 20 lines long. : L7 0001: I 0002: EXTRACT(RAISE(TRANS(FILENAME1,ACCOUNT,11,X)),1,0,0) 0003: 0004: Auth.▒Number 0005: 10R 0006: M 0007: PENDING_AUTHS : EX AUTH_DATE SELECTed record name = AUTH_DATE. This is a Type I Descriptor last compiled on 05/02/13 at 10:24. 20 lines long. : L7 0001: I 0002: EXTRACT(RAISE(TRANS(FILENAME1,ACCOUNT,12,X)),1,0,0) 0003: D2/ 0004: Auth.▒Date 0005: 8R 0006: M 0007: PENDING_AUTHS : EX AUTH_AMOUNT SELECTed record name = AUTH_AMOUNT. This is a Type I Descriptor last compiled on 05/02/13 at 10:24. 20 lines long. : L7 0001: I 0002: EXTRACT(RAISE(TRANS(FILENAME1,ACCOUNT,13,X)),1,0,0) 0003: MD2 0004: Auth.▒Amount 0005: 12R 0006: M 0007: PENDING_AUTHS : EX --- Note: This
Re: [U2] Searching for 'Bad' Dates
How about a DICT item that performs a match like 2n'/'2n'/'2n on that field? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Wednesday, 30 January 2013 8:38 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Searching for 'Bad' Dates All, Can anyone help me with a query to find instances where an external date has been written to a date field? I would like to use ...WITH MPAR.STATUS.DATE LIKE .. ./... (the dates would be in the fomat: '12/16/12', but this field is set with external formatting so I end up bringing back everything. Is there a way I can 'turn off' formatting for this field within the query? Thanks, Greg ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Triggers in Universe
Could use the trigger program to call one or more external subroutines based on the trigger action required? I understand that the external subroutines are not cached and can be updated without needing to stop/start the master trigger. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Brian Leach Sent: Saturday, 26 January 2013 20:19 To: U2 Users List Subject: Re: [U2] Triggers in Universe Remember also that triggers, as subroutines, are cached in memory so if you recompile a trigger the changes won't be picked up by any processes that have not logged off or returned to TCL. Brian Sent from my iPad On 25 Jan 2013, at 22:18, Bobby Worley bwor...@coburns.com wrote: That's what I did, Perry! GMTA ;) On Fri, Jan 25, 2013 at 4:07 PM, Perry Taylor perry.tay...@zirmed.comwrote: You can globally catalog in a Pick-flavored account. Copy the CATALOG VOC record from the UV account to your Pick-flavored account VOC renaming it something like ICATALOG. We do it all the time for our file-based triggers. Perry -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, January 25, 2013 3:03 PM To: U2 Users List Subject: Re: [U2] Triggers in Universe The problem was the locally cataloged program.I was in an account that is PICK flavor and wouldn't allow global cataloging. When I catalog the program globally from the UV account the CREATE TRIGGER now works. Thanks! On Fri, Jan 25, 2013 at 3:56 PM, Woodward, Bob bob_woodw...@k2sports.com wrote: In Unidata the problem would be that the trigger has to be cataloged globally, not locally. I'm not sure how to do that in Universe, though. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto: u2-users-boun...@listserver.u2ug.org] On Behalf Of Bobby Worley Sent: Friday, January 25, 2013 1:33 PM To: U2 Users List Subject: [U2] Triggers in Universe I'm up against a wall here - trying to use triggers for the first time, on Universe. Can't seem to get my test to work - Universe on AIX: RELLEVEL 001 X 002 11.1.9 003 PICK 004 PICK.FORMAT 005 11.1.9 BASIC BDW TRIGTEST Compiling: Source = 'BDW/TRIGTEST', Object = 'BDW.O/TRIGTEST' * Compilation Complete. CATALOG BDW TRIGTEST TRIGTEST cataloged. .L TRIGTEST TRIGTEST 001 V 002 BDW.O/TRIGTEST 003 B 004 BNP 005 006 PICK.FORMAT 007 S²N²P²I²A²E²H 008 NO.WARN²NOPAGE²LPTR²KEEP.COMMON²²TRAP²HDR-SUPP 009 BDW.O CREATE TRIGGER TRIGTEST BEFORE UPDATE OR INSERT OR DELETE ON RENTAL FOR EACH ROW CALLING 'TRIGTEST'; Unable to locate trigger program BDW.O/TRIGTEST. -- *Bobby D. Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ** ** ___ 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 -- *Bobby D. Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ** ** ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users 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 http://listserver.u2ug.org/mailman/listinfo/u2-users -- *Bobby D. Worley* IT Applications Developer Coburn Supply Company o: 903.753.8613 | m: 214.676.9825 bwor...@coburns.com ** ** ___ 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] Universal COMO
Hi Will, I think the biggest *con* you might come up against will be concurrency issues with multiple processes writing to the one central location. If you had a solution where each session log is unique amongst all processes then that would work very well. You will still need to clean it out though whether it be one big centralised dir or one for each account. As others have indicated, and if you run a unix box, then an overnight cron job to find and clean out any COMO dirs older than a set number of days would an option for you. I would suggest that you identify any logs that were important historically to you and roll them first. Probably zipping them up and moving them to an archive area would be viable. Google may even cough up a log rotate script that you could adapt. Regards, Peter -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wjhonson Sent: Thursday, 24 January 2013 4:28 To: u2-users@listserver.u2ug.org Subject: [U2] Universal COMO By default, Universe will create several files in each account you create. Like SAVEDLISTS, and ED... one of these default files is COMO which is where you can stick session logs. We use this constantly to monitor the output of phantoms, for review and debugging the next day. The logs are emailed to myself and some other programmers here. By altering the VOC entries in the accounts, we could have a central, universal COMO for all accounts, instead of one for each account. I see a *pro* in this, for the ease of cleaning up old logs from years ago, obviously no longer needed, which can be done from the O/S level. What might be a *con* ? Will Johnson ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Universal COMO
Or lymbollic sinks if you're little endian? :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Augusto Alonso Sent: Thursday, 24 January 2013 11:17 To: U2 Users List Subject: Re: [U2] Universal COMO What about symbolic links at OS level? -- Augusto Alonso 2013/1/23 Wjhonson wjhon...@aol.com By default, Universe will create several files in each account you create. Like SAVEDLISTS, and ED... one of these default files is COMO which is where you can stick session logs. We use this constantly to monitor the output of phantoms, for review and debugging the next day. The logs are emailed to myself and some other programmers here. By altering the VOC entries in the accounts, we could have a central, universal COMO for all accounts, instead of one for each account. I see a *pro* in this, for the ease of cleaning up old logs from years ago, obviously no longer needed, which can be done from the O/S level. What might be a *con* ? Will Johnson ___ 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 --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly
Distance should not be an obstacle. You may not be able to physically access the console but console access should still be possible either by getting someone else to physically eyeball it or a launch remote console session yourself. How about using something like a Cyclades terminal server to access one or more host consoles remotely via ssh? Even if a Cyclades is not an option then what about a network connected management facility such as an ALOM/ILOM or similar? Again via ssh, login and launch the console process from there. As long as the chassis had power then you should have LOM access if the WAN is available. Voila! Serial console heaven from the other side of the world even. Sure talking someone on the other end of a phone through a system recovery is not the easiest of tasks and it may not be as quick as direct connect in the same room or even an ssh session over your LAN but it sure would beat an acoustic coupled 300 baud half duplex modem that we used to use at AWA to dial in and fix GFE's etc. So how do you access your system console? Cheers Peter -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Wols Lists Sent: Saturday, 19 January 2013 3:33 To: u2-users@listserver.u2ug.org Subject: Re: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly On 18/01/13 03:18, Kevin King wrote: Peter, I'm 1200+ miles away from the box. Getting to the console is not an option. To restart, I've been forcing Unidata down with stopud -f and starting it again with startud. Yeah, drastic, I know. But that's why I'm looking for better ways. How do you get to the box to do a stopud/startud? This implies AIX is up and responding. So it shouldn't be too hard to open a remote session at the AIX level to find out what is going wrong. Not that I can advise how to do it ... Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly
Not sure what it's called in AIX/IBM speak but if it was a Solaris machine I'd be finding the system console and looking at that to see if anything interesting is showing. At least then you have a direct serial connection (and/or K/B + monitor) facility to get directly to the host without relying on telnet or any other communications daemon to be running. Are you sure it's completely dead? What do you do to get back up and running again? Does it come alive again suddenly? The aix server we have here sometimes slows down so much during the nightly backup that it seems completely dead. Apparently this is/was the disks being thrashed during the save and nothing else gets a look in for ages. As others have said - writing a sript to dump out current list of running processes is a good idea. You might want to also include some other stuff like the load averages and io activities on the system at the same time. See the uptime, iostat, and vmstat commands. ThIssuing a sngle iostat or vmstat may not always yield accurate results - my experience on Solaris is the first line of output is trash and you need the next few lines to get a clearer picture. So an 'iostat 1 5' might get you a better idea as to where a potential bottleneck might be. I'd also be running a similar script during the day or at least a few times during. This will give you a 'normal' point of reference to compare to the overnight happenings. Cheers Peter -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, 17 January 2013 4:40 To: U2 Users List Subject: [U2] Unidata 6.1.13/AIX 5.3 Stops Unexpectedly We have a customer with a box as described in the subject that has recently been experiencing something odd. Overnight, the system will just lock up and stop responding. Normally there isn't anyone doing anything at night; the backup runs, that sort of thing, but then some days when they come in early in the morning the entire machine is unresponsive. Connecting with telnet there is no login prompt, just a blank screen. It happened last night and I've confirmed from the logs that the backup (which is using a split mirror backup strategy) ran successfully and finished at 2:02am. Sometime between then and 4am, when there really should not have been anything going on, it just locked up. Are there any logs that can be enabled on AIX to record some evidence for these kinds of failures so we can figure out what's going on with this machine? -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [UV Retrieve] Selecting file based on partial key
Dear U2 List, Is the below at all possible in universe retrieve please? I didn't think it was but there're a lot more clever people out there than I plus it's been too long since I was doing this regularly and cannot remember if it is or not. I cannot see anything obvious in the manuals. We have a file in a production environment with 5477108 records whose @ID/Key are all '9-digit-account-number':'4-digit-sequence-number'. Q. Is it possible to obtain a list of @ID's based on a separate saved list of '9-digit-account-number'? The remaining record fields are all out of scope for the selection apart from an internal date in attribute 4 but that can be interrogated later. Is it possible to construct a kind of reverse select based on my existing saved-list and pass this data into a dict item for the account number? I've tried numerous permutations of this but have yet to find the answer. Or can I do something lie an sql SELECT FILENAME WHERE ACC_NBR = 'GET-LIST ACC_LIST'? How is this done on a (live) normal type 18 UV file? Of course I can always whip up some basic code to do this but it is production and getting it there will take a while. (and no I didn't design the file layout ...) Many thanks in advance. Regards, Peter --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV Retrieve] Selecting file based on partial key
Hi Manu, Thankyou very very much for this it worked a treat. Absolutely brilliant! The index was already created so just had to find the right one amongst the others and all was good. Regards, Peter -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Manu Fernandes Sent: Tuesday, 15 January 2013 17:00 To: U2 Users List Subject: Re: [U2] [UV Retrieve] Selecting file based on partial key hi peter, I suggest this : 1) build a indexfile based on ACC_NBR 2) set a VOC file pointer directly on the index file FILENAME.INDEX0 F I__FILENAME/INDEX.000 (or other physical filename) for selection 3) GET.LIST ACC_LIST 4) QSELECT FILENAME.INDEX0 the active select list is the content of FILENAME.INDEX0 ... the keys you need I hope this help manu Manu Peter Cheney peter.che...@firstmac.com.au a écrit : Dear U2 List, Is the below at all possible in universe retrieve please? I didn't think it was but there're a lot more clever people out there than I plus it's been too long since I was doing this regularly and cannot remember if it is or not. I cannot see anything obvious in the manuals. We have a file in a production environment with 5477108 records whose @ID/Key are all '9-digit-account-number':'4-digit-sequence-number'. Q. Is it possible to obtain a list of @ID's based on a separate saved list of '9-digit-account-number'? The remaining record fields are all out of scope for the selection apart from an internal date in attribute 4 but that can be interrogated later. Is it possible to construct a kind of reverse select based on my existing saved-list and pass this data into a dict item for the account number? I've tried numerous permutations of this but have yet to find the answer. Or can I do something lie an sql SELECT FILENAME WHERE ACC_NBR = 'GET-LIST ACC_LIST'? How is this done on a (live) normal type 18 UV file? Of course I can always whip up some basic code to do this but it is production and getting it there will take a while. (and no I didn't design the file layout ...) Many thanks in advance. Regards, Peter --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ 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 --- Note: This email (inc all attachments) is for the use of the intended recipient(s) only. Privileged or confidential information may be contained in this communication. If you have received this email in error, please notify the sender immediately and then delete all copies of this message from your computer network. If you are not the intended recipient, you must not keep, use, disclose, copy or distribute this email without the author's prior permission. If you are the intended recipient and you do not wish to receive similar electronic messages from us in future, then please respond to the sender to this effect. We have taken precautions to minimise the risk of transmitting software viruses, but advise you to carry out your own virus checks on this email and its attachments. We do not accept liability for any loss or damage caused by software viruses and do not represent that this transmission is free from viruses or other defects. Firstmac Limited (ABN 59 094 145 963) (AFSL 290600) --- ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] {BDT] Commenting A Block Of Code
Hi Bill,
In UV's ED use the (start block) and (end block) to define a block of code.
Then do C//*/B
This will prompt for confirmation of change block from line n through m.
Alternatively in unix vi:
:s/^/*/999
This will (s)ubstitue nothing at the beginning of each line (^) with an asterix
(*) for the next 999 lines from the current line.
HTH
Cheers
Peter
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Bill Brutzman
Sent: Thursday, 10 January 2013 11:25
To: U2 Users List
Subject: [U2] {BDT] Commenting A Block Of Code
Rather than going line-by-line... is there a way... or a trick to highlighting
several lines of code...
And commenting out all of these lines in aggregate?
I have a legacy program whose code is no longer compliant... that I am trying
to isolate.
--Bill
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
---
Note:
This email (inc all attachments) is for the use of the intended recipient(s)
only.
Privileged or confidential information may be contained in this communication.
If you have received this email in error, please notify the sender immediately
and then delete all copies of this message from your computer network. If you
are not the intended recipient, you must not keep, use, disclose, copy or
distribute this email without the author's prior permission. If you are the
intended recipient and you do not wish to receive similar electronic messages
from us in future, then please respond to the sender to this effect.
We have taken precautions to minimise the risk of transmitting software
viruses, but advise you to carry out your own virus checks on this email and
its attachments. We do not accept liability for any loss or damage caused by
software viruses and do not represent that this transmission is free from
viruses or other defects.
Firstmac Limited (ABN 59 094 145 963) (AFSL 290600)
---
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
