Fellow U2 users, The Universe documentation suggests that it is possible to retrieve data from a remote SQL DB on a Windows server from Universe using ODBC. We do the reverse here at present, but haven't done what I am attempting. Can anyone verify or shed some light on how to do this, please? We have Universe 10.3 running on AIX and have ODBC in use.
Thanks, Ken Ford, FirstMac Pty Ltd, Brisbane, QLD Australia. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, 1 July 2010 5:00 AM To: [email protected] Subject: U2-Users Digest, Vol 14, Issue 24 Send U2-Users mailing list submissions to [email protected] To subscribe or unsubscribe via the World Wide Web, visit http://listserver.u2ug.org/mailman/listinfo/u2-users or, via email, send a message with subject or body 'help' to [email protected] You can reach the person managing the list at [email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of U2-Users digest..." Today's Topics: 1. UniJDBC calling UV subroutine: MESSAGE command limitations? (Womack, Adrian) 2. Re: UniJDBC calling UV subroutine: MESSAGE command limitations? (Womack, Adrian) 3. Re: UniJDBC calling UV subroutine: MESSAGE command limitations? (Womack, Adrian) 4. Re: UniJDBC calling UV subroutine: MESSAGE command limitations? (Dan McGrath) 5. Re: UniJDBC calling UV subroutine: MESSAGE command limitations? (Womack, Adrian) 6. Re: UniJDBC calling UV subroutine: MESSAGE command limitations? (phil walker) 7. Re: UniJDBC calling UV subroutine: MESSAGE command limitations? (Womack, Adrian) 8. Re: UniJDBC calling UV subroutine: MESSAGE command limitations? (Hona, David) ---------------------------------------------------------------------- Message: 1 Date: Wed, 30 Jun 2010 09:17:45 +0800 From: "Womack, Adrian" <[email protected]> To: "'U2 Users List'" <[email protected]> Subject: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? Message-ID: <[email protected]> Content-Type: text/plain; charset="us-ascii" 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. ------------------------------ Message: 2 Date: Wed, 30 Jun 2010 09:49:33 +0800 From: "Womack, Adrian" <[email protected]> To: "'U2 Users List'" <[email protected]> Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? Message-ID: <[email protected]> Content-Type: text/plain; charset="us-ascii" 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: [email protected] [mailto:[email protected]] 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. ------------------------------ Message: 3 Date: Wed, 30 Jun 2010 11:38:31 +0800 From: "Womack, Adrian" <[email protected]> To: "'U2 Users List'" <[email protected]> Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? Message-ID: <[email protected]> Content-Type: text/plain; charset="us-ascii" 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: [email protected] [mailto:[email protected]] 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. ------------------------------ Message: 4 Date: Wed, 30 Jun 2010 13:53:45 +1000 From: "Dan McGrath" <[email protected]> To: "U2 Users List" <[email protected]> Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? Message-ID: <[email protected]> Content-Type: text/plain; charset="us-ascii" 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: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]] 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 [email protected] 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. ########################################################################################### ------------------------------ Message: 5 Date: Wed, 30 Jun 2010 11:58:59 +0800 From: "Womack, Adrian" <[email protected]> To: "'U2 Users List'" <[email protected]> Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? Message-ID: <[email protected]> Content-Type: text/plain; charset="us-ascii" 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: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]] 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 [email protected] 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 [email protected] 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 to this e-mail. ------------------------------ Message: 6 Date: Wed, 30 Jun 2010 16:01:38 +1200 From: "phil walker" <[email protected]> To: "U2 Users List" <[email protected]> Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? Message-ID: <[email protected]> Content-Type: text/plain; charset="US-ASCII" 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: [email protected] [mailto:u2-users- > [email protected]] 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 > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > ------------------------------ Message: 7 Date: Wed, 30 Jun 2010 14:03:53 +0800 From: "Womack, Adrian" <[email protected]> To: "'U2 Users List'" <[email protected]> Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? Message-ID: <[email protected]> Content-Type: text/plain; charset="us-ascii" 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: [email protected] [mailto:[email protected]] 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. ------------------------------ Message: 8 Date: Wed, 30 Jun 2010 16:05:40 +1000 From: "Hona, David" <[email protected]> To: 'U2 Users List' <[email protected]> Subject: Re: [U2] UniJDBC calling UV subroutine: MESSAGE command limitations? Message-ID: <297b19fd90fdb14da1c8ceff0b6cffe76750ea5...@vaunsw139.au.cbainet.com> Content-Type: text/plain; charset="us-ascii" 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: [email protected] [mailto:[email protected]] 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: [email protected] [mailto:[email protected]] 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users End of U2-Users Digest, Vol 14, Issue 24 **************************************** ##################################################################################### 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 [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
