Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations?
Thankyou, thankyou! Phil. H didn't work - but it made me go and look up what other options are available for field 4 in the VOC. I needed to add a G - Allowed in an SQL CALL statement. So, no coding changes required at all - fantastic, just the way I like it. Thanks again. Adrian -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of phil walker Sent: Wednesday, 30 June 2010 12:02 PM To: U2 Users List Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? You could try setting adding an 'H' (I think) to attribute 4 or 5 of the VOC MESSAGE record. This will allow the verb to be issues as part of a transaction Sorry to be vague, but I am not connected to a system at the moment... Cheer,s DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations?
Does the !MESSAGE subroutine work? It probably just calls the MESSAGE verb! :) Pages 57-59 (3-15) of the UV 10.3 Sysdesc.pdf (Feb 09) details the Dispatch Codes and Processor Modes available. I can't recall watch combination you need. But you likely need the Dispatch Code not be E or U. Simply look at any VOC entry of a VERB that does do work as a phantom or via the UV API/JDBC and add those Dispatch Codes - at your own risk, of course :) -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, 30 June 2010 1:59 PM To: 'U2 Users List' Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? Thanks for that Dan - I was coming to the same conclusion myself. We already have another phantom that uses MESSAGE, so I knew that wouldn't be a problem. I was a bit disheartened when I found out i could use PHANTOM either - that would have been a relatively painless approach. We do have a number of other phantoms already doing tasks at various intervals, so adding an extra task to just poll a file would be too much to ask. It's a pity that I can't use MESSAGE (or PHANTOM) directly. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Wednesday, 30 June 2010 11:54 AM To: U2 Users List Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? I just checked on our system and I can call MESSAGE within a PHANTOM if it is executed from a normal session. With this in mind, a possible work around would be to run a 24/7 phantom that either accepts data from a named piped/socket or polls a file and sends out a message based on the data received. From your UV subroutine you could then just passed the required data by the appropriate method. It's dirty and obviously having it work natively from your UV sub would be better, but if it isn't possible... Regards, Dan ** 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
Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations?
I'm wondering if it's because MESSAGE can optionally prompt for input, and because the call statement is executed from the jsp page via executeQuery - maybe it won't allow input inside a query (similar to the rule about input inside a transaction). Perhaps if I execute a PHANTOM command to perform the MESSAGE commands in a different process - maybe that would work. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, 30 June 2010 9:18 AM To: 'U2 Users List' Subject: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? We have a jsp page that calls a Universe subroutine using that method detailed in the JDBC manual, this works as expected and the subroutine completes it's task successfully. Also from a separate phantom process for certain important events we have some code that sends a splat message to line 23 of specific users' sessions (this uses the Universe MESSAGE command) -this also works fine. We're now trying to get the subroutine called via JDBC to also use the MESSAGE command. But each time it throws this error message into the uv errlog: root VOC entry MESSAGE illegal as or in a procedure. Does anyone know what's wrong here? I've looked through the manuals and the help and can't find any mention of this particular restriction. Thanks, Adrian DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations?
Oh, great - now I'm getting the same error for PHANTOM - so I can't use that workaround. VOC entry PHANTOM illegal as or in a procedure. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, 30 June 2010 9:50 AM To: 'U2 Users List' Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? I'm wondering if it's because MESSAGE can optionally prompt for input, and because the call statement is executed from the jsp page via executeQuery - maybe it won't allow input inside a query (similar to the rule about input inside a transaction). Perhaps if I execute a PHANTOM command to perform the MESSAGE commands in a different process - maybe that would work. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations?
I just checked on our system and I can call MESSAGE within a PHANTOM if it is executed from a normal session. With this in mind, a possible work around would be to run a 24/7 phantom that either accepts data from a named piped/socket or polls a file and sends out a message based on the data received. From your UV subroutine you could then just passed the required data by the appropriate method. It's dirty and obviously having it work natively from your UV sub would be better, but if it isn't possible... Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, June 30, 2010 1:39 PM To: 'U2 Users List' Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? Oh, great - now I'm getting the same error for PHANTOM - so I can't use that workaround. VOC entry PHANTOM illegal as or in a procedure. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, 30 June 2010 9:50 AM To: 'U2 Users List' Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? I'm wondering if it's because MESSAGE can optionally prompt for input, and because the call statement is executed from the jsp page via executeQuery - maybe it won't allow input inside a query (similar to the rule about input inside a transaction). Perhaps if I execute a PHANTOM command to perform the MESSAGE commands in a different process - maybe that would work. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations?
Thanks for that Dan - I was coming to the same conclusion myself. We already have another phantom that uses MESSAGE, so I knew that wouldn't be a problem. I was a bit disheartened when I found out i could use PHANTOM either - that would have been a relatively painless approach. We do have a number of other phantoms already doing tasks at various intervals, so adding an extra task to just poll a file would be too much to ask. It's a pity that I can't use MESSAGE (or PHANTOM) directly. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Dan McGrath Sent: Wednesday, 30 June 2010 11:54 AM To: U2 Users List Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? I just checked on our system and I can call MESSAGE within a PHANTOM if it is executed from a normal session. With this in mind, a possible work around would be to run a 24/7 phantom that either accepts data from a named piped/socket or polls a file and sends out a message based on the data received. From your UV subroutine you could then just passed the required data by the appropriate method. It's dirty and obviously having it work natively from your UV sub would be better, but if it isn't possible... Regards, Dan -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, June 30, 2010 1:39 PM To: 'U2 Users List' Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? Oh, great - now I'm getting the same error for PHANTOM - so I can't use that workaround. VOC entry PHANTOM illegal as or in a procedure. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, 30 June 2010 9:50 AM To: 'U2 Users List' Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? I'm wondering if it's because MESSAGE can optionally prompt for input, and because the call statement is executed from the jsp page via executeQuery - maybe it won't allow input inside a query (similar to the rule about input inside a transaction). Perhaps if I execute a PHANTOM command to perform the MESSAGE commands in a different process - maybe that would work. DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users __ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ### The information transmitted in this message and attachments (if any) is intended only for the person or entity to which it is addressed. The message may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from any computer. The intended recipient of this e-mail may only use, reproduce, disclose or distribute the information contained in this e-mail and any attached files with the permission of IMB. ### ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments
Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations?
You could try setting adding an 'H' (I think) to attribute 4 or 5 of the VOC MESSAGE record. This will allow the verb to be issues as part of a transaction Sorry to be vague, but I am not connected to a system at the moment... Cheer,s -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Womack, Adrian Sent: Wednesday, 30 June 2010 1:30 p.m. To: 'U2 Users List' Subject: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? We have a jsp page that calls a Universe subroutine using that method detailed in the JDBC manual, this works as expected and the subroutine completes it's task successfully. Also from a separate phantom process for certain important events we have some code that sends a splat message to line 23 of specific users' sessions (this uses the Universe MESSAGE command) -this also works fine. We're now trying to get the subroutine called via JDBC to also use the MESSAGE command. But each time it throws this error message into the uv errlog: root VOC entry MESSAGE illegal as or in a procedure. Does anyone know what's wrong here? I've looked through the manuals and the help and can't find any mention of this particular restriction. Thanks, Adrian DISCLAIMER: Disclaimer. This e-mail is private and confidential. If you are not the intended recipient, please advise us by return e-mail immediately, and delete the e-mail and any attachments without using or disclosing the contents in any way. The views expressed in this e-mail are those of the author, and do not represent those of this company unless this is clearly indicated. You should scan this e-mail and any attachments for viruses. This company accepts no liability for any direct or indirect damage or loss resulting from the use of any attachments to this e-mail. ___ U2-Users mailing list U2-Users@listserver.u2ug.org 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