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