Re: [U2] UniVerse/SQL: This EVAL field requires a qualifying file name
This worked! Thanks Ray! rayw at mindless.com writes: It does wherever the column reference is or may be ambiguous (or wherever the query parser assumes it may be ambiguous!). Try this. SELECT A.field1, B.field2, EVAL B.'TESTING' AS field3 FROM table1 A, table2 B WHERE A.KeyField = B.KeyField; ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
I had to redo the FTP scripts when we moved to 7.2 on a 64bit box due to the security of Windows. I had to go from a batch file that called a txt file for the commands to a single batch file that executed all of the commands. I enter this text in a .bat file and just call it from the paragraph. Nothing fancy. The trick is that the batch file is making the DAT file so there are no windows security issues. @echo off echo user YOURUSERNAME ftpcmd.dat echo YOUPASSWORD ftpcmd.dat echo bin ftpcmd.dat echo put E:\tmp\FILETOSEND.txt FILENAMEATSITE.txt ftpcmd.dat echo cl ftpcmd.dat echo qui ftpcmd.dat ftp -n -s:ftpcmd.dat www.WEBSITE.com del ftpcmd.dat Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Thursday, February 17, 2011 7:48 PM To: U2 Users List Subject: [U2] Frustrated with Rocket / Unidata 7.2 About a week ago I upgraded Unidata 7.1 on Windows XP/32 to Unidata 7.2 on Windows 7/64. Everything I need in Unidata seems to work fine on this release with one notable exception: Unidata 7.2 on Windows will no longer properly execute the Windows ftp program. Rocket support has basically said that in this version they changed the telnet server so that it can only run fully stdin/stdout compliant programs in the shell. Because the Windows ftp program isn't exactly stdin/stdout compliant, it is no longer a functional PCPERFORM program. Even if the ftp program is scripted to connect, transfer, and exit with no additional inputs or outputs, the ftp program will still fail. Of course, in this case if there's a put in the commands it'll fail after writing a zero byte file, potentially overwriting something. I could be frustrated with Microsoft because, after all, it's their program that's failing, I'm more frustrated with Rocket. While it's frustrating to have a past ability removed it's more frustrating to have received absolutely zero warning from Rocket that this could happen. I've searched the docs for 7.2... can't find a word about this change. (Hey, and I could be missing something; that's certainly a possibility.) It's fortunate that this install isn't a big production system, but what if it was? There are several production systems running Unidata on Windows, so if any of y'all are using ftp or any OS commands that may not meet Rocket's muster, please be aware of this change in 7.2. BTW, for me the fix was to use WinSCP (in command line mode) instead of Microsoft's FTP program. So far it seems to work just fine though the scripting is a bit different from Microsoft's ftp client. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] Interactive FTP commands when shelling out from UniData ECL with !cmd
Kevin, et al: I suspect the main difference you are seeing is due to whether you are initiating a UniData session via telnet or via the console. I don't think you have ever been able to get the prompting and responses back thru the layers when you start a UniData session in telnet. Typically it will hang after entering your user id on the target server. I just tested UniData 7.2.7 on both XP and Windows 7-32bit. If you start a console session and then shell out from ECL with !cmd - all is well. I was able to connect to another server and transfer a file with Windows ftp interactively. So - I don't think UniData introduced a change intentionally or unintentionally - though I have not yet tracked down the source of the information that was conveyed to Kevin's support provided in the context of his inquiry. We make mistakes, but we try very hard not to introduce any regressions or change behavior without providing a switch for that - witness 116 UDT.OPTIONS settings. Regards, Wally Ps Totally unreleated to UniData (that is - just opening a dos window without interacting with UniData at all), on my W7-32 laptop - I cannot use Windows ftp interactively when connected to our VPN. Hangs when any data is being sent back (even just an 'ls' of the directory where connected). Works fine when directly connected to our network. As an alternative - I tried using Filezilla. Works like a charm. Wally Terhune U2 Support Architect Rocket Software 4600 South Ulster Street, Suite 1100 **Denver, CO 80237 **USA Tel: +1.720.475.8055 Email: wterh...@rs.com Web: www.rocketsoftware.com/u2 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] UODOTNET.DLL and 64bit windows.
I am developing and using applications with UniObjects.NET on 64 bit Windows 7 and have had no problems. Jacques G. wrote: Hello, I wanted to know if anyone here uses the Uodotnet.dll with 64bit versions of Windows. Particularly windows 2003. If so, which version of the uodotnet.dll do you use ? I am getting an Uodotnet error 81011 saying that the host is unknown. I am able do open a telnet session to the host and I specified the host with the ip address. I am getting ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users -- Jeff Schasny - Denver, Co, USA jschasny at gmail dot com ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] UODOTNET.DLL and 64bit windows.
I 2nd that! no issues. Now, if you use classic COM UniObjects - that's a different story. :-) On 2/18/2011 9:17 AM, Jeff Schasny wrote: I am developing and using applications with UniObjects.NET on 64 bit Windows 7 and have had no problems. Jacques G. wrote: Hello, I wanted to know if anyone here uses the Uodotnet.dll with 64bit versions of Windows. Particularly windows 2003. If so, which version of the uodotnet.dll do you use ? I am getting an Uodotnet error 81011 saying that the host is unknown. I am able do open a telnet session to the host and I specified the host with the ip address. I am getting ___ 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] Frustrated with Rocket / Unidata 7.2
I must agree with Dave on this one. Through my 14-years of experience, the Unidata team has provided exceptional product development, support and seamless upgrades, version after version. Now I am by no means a 'power-user' of the database, but asking from a developers perspective, which of us have NOT broken something in a subsequent release and really honked off one or more of our power users? In my opinion, it's part of the 'game.' That being said, in my 30+ years as a developer in general, one thing I have learned (the hard way) is, to take an otherwise 'private' situation public and rail against the hand that essentially feeds me is just bad form. I look forward to the posts from this forum as long as they are knowledge-seeking and solution based, no matter how longwinded they get. ;^) Sincerely, David Laansma IT Manager Hubbard Supply Co. Direct: 810-342-7143 Office: 810-234-8681 Fax: 810-234-6142 www.hubbardsupply.com Delivering Products, Services and Innovative Solutions -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of David Jordan Sent: Friday, February 18, 2011 12:46 AM To: U2 Users List Subject: Re: [U2] Frustrated with Rocket / Unidata 7.2 U2 has probably spoiled us. You should see some of the issues others face upgrading in Oracle, SQL Server, Windows and so on. We have an expectation of seamless upgrades that does not occur in other environments. For people to have software that is 25 years old still running on U2 is pretty good. Regards David Jordan ___ 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] FTP from UV/unix
FYI - I use the following method from Unix UV for FTPing CMD=ftp -n -u EOF CMD-1=open :FTPSITE CMD-1=user :FTPUSERNAME: :FTPPASSWORD CMD-1=passive CMD-1=lcd /tmp CMD-1=ascii CMD-1=put :FILENAME CMD-1=ls CMD-1=bye CMD-1=EOF CMDHIST=CMD * CONVERT AM TO CHAR(10) IN CMD EXECUTE sh -c ':CMD:' CAPTURING JUNK2 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FTP from UV/unix
I find that using the .netrc file for the connection details is easier than having passwords etc in the actual script I 'spect that's just me though bob -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: 18 February 2011 14:49 To: U2 Users List Subject: Re: [U2] FTP from UV/unix FYI - I use the following method from Unix UV for FTPing CMD=ftp -n -u EOF CMD-1=open :FTPSITE CMD-1=user :FTPUSERNAME: :FTPPASSWORD CMD-1=passive CMD-1=lcd /tmp CMD-1=ascii CMD-1=put :FILENAME CMD-1=ls CMD-1=bye CMD-1=EOF CMDHIST=CMD * CONVERT AM TO CHAR(10) IN CMD EXECUTE sh -c ':CMD:' CAPTURING JUNK2 ___ 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 __ Confidentiality Notice: This e-mail and any attachments are intended solely for the addressee and may contain confidential or privileged information. If you are not the named addressee, or the person responsible for delivering the message to the named addressee, please notify the sender as soon as possible and delete the material from your computer. This message will be protected by copyright. If it has come to you in error, you must not take any action based on its contents nor must you copy or show the message to any person other than the intended recipient. _ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email __ ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] FTP from UV/unix
We keep the passwords encryted in a file, read them into the program, then decrypt them. The .netrc maintains the data in plain text I've always read .netrc is bad security - but depending on where your server sits, security might not be a high priority -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Bob Witney Sent: Friday, February 18, 2011 9:55 AM To: U2 Users List Subject: Re: [U2] FTP from UV/unix I find that using the .netrc file for the connection details is easier than having passwords etc in the actual script I 'spect that's just me though bob ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Interactive FTP commands when shelling out from UniData ECL with !cmd
You are correct that it is over telnet. However, I believe that most people access their Unidata servers via telnet, right? With all due respect, you are incorrect with this statement, however: I don't think you have ever been able to get the prompting and responses back thru the layers when you start a UniData session in telnet. Scripting the ftp command worked fine in 7.1, or *maybe* what worked better was the ftp client on WinXP? Unfortunately, having changed both Windows versions and Unidata versions at the same time, it's hard to know exactly what fell down. Like I said in that other post, I think what set me off was the end of the response where it was stated there is no problem. Had they suggested filezilla or winscp or something else, I would have respected that. But for someone to tell me that my now broken program is not a problem, well, I beg to differ. Thank you Wally for your diligence in offering additional insight and assistance. It is MOST appreciated! -K ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
Jeff, so you're saying that if the ftp script was created by the batch file instead of being created by something else, this works? Gee, that could be the entire issue right there. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UV on Linux question...
Well, it is sort of the OS. The OS, as the likes of Red Hat, are a collection of utilities, of which cut is one. To deal with the changing versions of these utilities, many enterprise versions of Linux will freeze the utilities versions in a release called LTS - Long Term Support. Overtime, 1-2 years, many of these utilities; mySQL, Apache, PHP, and Python, in particular get stuck on old versions. This is why many enterprise applications, of which U2 is one, will specify which brand and release of the OS it will successfully install and run on. If this was not so, then supporting of the ever moving versions of Linux would be a nightmare. This is one of the main disadvantages of Linux and is how Red Hat, Ubuntu, and Suse market their enterprise versions of Linux - a Long Term Supported frozen version of utilities (security fixes are one of the few changes that are backported) that they will support. Fedora, in particular, ubuntu, and others are rather bleeding edge with the versions of utilities which they provide and it is always a continuous chore of dealing with the install and running of applications which break due to the changes. I use Ubuntu for the pretty desktops and boring plain CentOS for servers for these reasons. Cheers, djm George Gallen-2 wrote: apprantly, it's not the OS, it's the version of cut. - Learn and Do Excel and Share http://mvdbs.com http://mvdbs.com -- View this message in context: http://old.nabble.com/UV-on-Linux-question...-tp30953691p30959790.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
Re: [U2] Frustrated with Rocket / Unidata 7.2
Dave, I respect your opinion of my bad form but given that there has been little to no information on this topic, would it make sense to sit on the knowledge that there is a problem (regardless of who is to blame) and just let others stumble blindly into it themselves? It's likely that that the problem really doesn't have anything to do with Rocket. But when their response admitted changing things followed with it's working as designed and no additional information to help mitigate what was a broken program, that's hardly a solution. Thank God for the folks on this list who redirect, clarify, correct, and offer suggestions that actually can help. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
Yes, it appears to me that the issue I experienced was related to updated security in win2008, not in unidata. I've also noticed that every upgrade breaks something. Sometimes you get lucky and things run for 10 years, then one day, BAM! A program stops working after you upgrade the database. It's the nature of the job. Things change. Things break. Things need to be fixed. That is what testing is for. Jeffrey Lettau ERP Systems Manager polkaudio -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, February 18, 2011 10:46 AM To: U2 Users List Subject: Re: [U2] Frustrated with Rocket / Unidata 7.2 Jeff, so you're saying that if the ftp script was created by the batch file instead of being created by something else, this works? Gee, that could be the entire issue right there. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Disclaimer: This email may contain confidential and/or privileged information. It is intended only for the person or persons to whom it is addressed. Any unauthorized review, use, or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email or telephone and destroy all copies of the original message. Please consider the environment before printing this email. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] UniSubroutineException: Unknown Error [30102] Occurred
So we created a basic program to call so we are getting closer, thanks for all your input it is putting us on the correct path. I do seem to have some issues when trying to get the results. What is happening is it is just spitting out the input parameters .. //System.err.println(command.response()); UniSubroutine sub = session.subroutine(S.XTMS.TEST.BASIC, 1); sub.setArg(0, 0491865); sub.call(); sub.resetArgs(); System.err.println(sub.getNumArgs()); System.err.println(sub); System.err.println(sub.getArg(0)); //session.disconnect(); //String r = sub.getArg(0); //String r1 = sub.getArg(1); Logging statements: Version Number :4.1.3 Max Open Files :32 Account Path :/datatel/test/10day/development Locking Strategy :0 Release Strategy :12 Calling S.XTMS.TEST.LOOKUP... 1 asjava.uniobjects.UniSubroutine@6791d8c1 0491865 - same as input, not the result from the routine. On WednesdayF/16/11 5:45 PM, Hona, David david.h...@cba.com.au wrote: Does this subroutine do file I/O? Does it explicitly open the file or assume some other program or subroutine opens it and stores the file variable in labelled common...? Sometimes it can even be a call subroutine call that is called using a labelled common variable (CALL @MYSUB)... Easiest thing to do is look how the subroutine is used now...if you don't emulate the same initialisation sequence it requires from UV native runtime environment in Java runtime environment...it more than likely will not work. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Stephen Jackson Sent: Thursday, 17 February 2011 1:28 AM To: u2-users@listserver.u2ug.org Subject: [U2] UniSubroutineException: Unknown Error [30102] Occurred I am new to the U2 java api. I am trying to make a subroutine call but get the following Exception. It is not in the documentation and I have not had a lot of luck tracking it down. I am able to make a simple query so not sure if there is some configuration or something I am not aware of which is causing the error. Version Number :4.1.3 Max Open Files :32 Account Path :/mypath Locking Strategy :0 Release Strategy :12 Calling S.XTMS.TEST.LOOKUP... [IBM U2][UniObjects for Java][UniSubroutine Exception][ErrorCode: 30102]Unknown Error [30102] Occurred asjava.uniobjects.UniSubroutineException: Unknown Error [30102] Occurred at asjava.uniobjects.UniSubroutine.call(UniSubroutine.java:150) Any help would be much appreciated. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ** 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
That was...ummvery gracious! ;-) We've all been there! -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: Friday, February 18, 2011 1:35 PM To: U2 Users List Subject: Re: [U2] Frustrated with Rocket / Unidata 7.2 Thanks to John Jenkins, who contacted me offlist with some excellent information about the Windows firewall, I return here now to eat my share of crow for casting the blame towards Rocket when in reality the problem was with the Windows firewall. John had me run udt in the console and then run my script, which caused the Windows firewall to prompt for Allow/Deny. Once I allowed access in the console, my original script works fine under telnet. Once again, I am most thankful for the gracious assistance of this group, even when I myself may not be the model of graciousness. ___ 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] Frustrated with Rocket / Unidata 7.2
Overall, I would have to agree. There have been missteps along the way, but as was mentioned before, it happens with any product. I do wish I had come to this list first rather than going through Rocket support. Might have avoided some embarrassing crow. On Fri, Feb 18, 2011 at 1:13 PM, Address mrparkl...@yahoo.com wrote: Unidata is more stable than many versions of Microsoft Windows. Unidata does not frustrate or aggravate me. It is very reliable. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] UODOTNET.DLL and 64bit windows.
I use version 2.2.0.7276 on Windows 2008 R2 (it's only a 64 bit O/S). Bill On 2/17/2011 2:10 PM, Jacques G. wrote: Hello, I wanted to know if anyone here uses the Uodotnet.dll with 64bit versions of Windows. Particularly windows 2003. If so, which version of the uodotnet.dll do you use ? I am getting an Uodotnet error 81011 saying that the host is unknown. I am able do open a telnet session to the host and I specified the host with the ip address. I am getting ___ 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] Frustrated with Rocket / Unidata 7.2
Silly company names. Charlie On 02-18-2011 3:41 PM, Tony Gravagno wrote: Finally, since we're here: From Charlie Noah: Totally OT, and I'm just musing here - Rocket, Raining Data then TigerLogic. Does anyone besides me see a trend here? Uh, I don't get it. How are those related? What trend? T ___ 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] UniSubroutineException: Unknown Error [30102] Occurred
The arg count going in needs to be n+1. Arg 0 will be the return data.
public ArrayList callSub(String sRoutine, ArrayList args)
{
Iterator it = args.iterator();
ArrayList oArgs = new ArrayList();
int iArgs = args.size();
System.out.println(Args: + iArgs);
try
{
UniSubroutine uoSub = ses.subroutine(sRoutine, iArgs + 1);
int iArg = 0;
uoSub.setArg(iArg++, ); // dummy argument - this
will become the return value
// Set user arguments
while (it.hasNext())
{
Object arg=it.next();
//System.out.println(InputArg[+iArg+]=+arg);
uoSub.setArg(iArg++, arg);
}
// call
uoSub.call();
// get returned parameters
iArgs = uoSub.getNumArgs();
for (int i = 0; i iArgs; i++)
{
String arg=uoSub.getArg(i);
//System.out.println(OutputArg[+i+]=+arg);
oArgs.add(arg);
}
} catch (Exception ex)
{
System.err.println(Call to + sRoutine + failed.);
ex.printStackTrace(System.err);
}
return oArgs;
}
On 02/18/2011 01:16 PM, Stephen Jackson wrote:
So we created a basic program to call so we are getting closer, thanks for
all your input it is putting us on the correct path. I do seem to have
some issues when trying to get the results. What is happening is it is
just spitting out the input parameters ..
//System.err.println(command.response());
UniSubroutine sub = session.subroutine(S.XTMS.TEST.BASIC, 1);
sub.setArg(0, 0491865);
sub.call();
sub.resetArgs();
System.err.println(sub.getNumArgs());
System.err.println(sub);
System.err.println(sub.getArg(0));
//session.disconnect();
//String r = sub.getArg(0);
//String r1 = sub.getArg(1);
Logging statements:
Version Number :4.1.3
Max Open Files :32
Account Path :/datatel/test/10day/development
Locking Strategy :0
Release Strategy :12
Calling S.XTMS.TEST.LOOKUP...
1
asjava.uniobjects.UniSubroutine@6791d8c1
0491865 - same as input, not the result from the routine.
On WednesdayF/16/11 5:45 PM, Hona, Daviddavid.h...@cba.com.au wrote:
Does this subroutine do file I/O? Does it explicitly open the file or
assume some other program or subroutine opens it and stores the file
variable in labelled common...? Sometimes it can even be a call
subroutine call that is called using a labelled common variable (CALL
@MYSUB)...
Easiest thing to do is look how the subroutine is used now...if you don't
emulate the same initialisation sequence it requires from UV native
runtime environment in Java runtime environment...it more than likely
will not work.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Stephen Jackson
Sent: Thursday, 17 February 2011 1:28 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UniSubroutineException: Unknown Error [30102] Occurred
I am new to the U2 java api. I am trying to make a subroutine call but
get the following Exception. It is not in the documentation and I have
not had a lot of luck tracking it down. I am able to make a simple query
so not sure if there is some configuration or something I am not aware of
which is causing the error.
Version Number :4.1.3
Max Open Files :32
Account Path :/mypath
Locking Strategy :0
Release Strategy :12
Calling S.XTMS.TEST.LOOKUP...
[IBM U2][UniObjects for Java][UniSubroutine Exception][ErrorCode:
30102]Unknown Error [30102] Occurred
asjava.uniobjects.UniSubroutineException: Unknown Error [30102] Occurred
at asjava.uniobjects.UniSubroutine.call(UniSubroutine.java:150)
Any help would be much appreciated.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
** 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] UniSubroutineException: Unknown Error [30102] Occurred
My issue is that what ever I use as my input args is what prints out as my
return args along with the args number. Can that be caused by the routine not
returning anything?
Stephen Jackson
-Original Message-
From: Jeff Powell [j...@powellclan.com]
Received: Friday, 18 Feb 2011, 6:43pm
To: U2 Users List [u2-users@listserver.u2ug.org]
Subject: Re: [U2] UniSubroutineException: Unknown Error [30102] Occurred
The arg count going in needs to be n+1. Arg 0 will be the return data.
public ArrayList callSub(String sRoutine, ArrayList args)
{
Iterator it = args.iterator();
ArrayList oArgs = new ArrayList();
int iArgs = args.size();
System.out.println(Args: + iArgs);
try
{
UniSubroutine uoSub = ses.subroutine(sRoutine, iArgs + 1);
int iArg = 0;
uoSub.setArg(iArg++, ); // dummy argument - this
will become the return value
// Set user arguments
while (it.hasNext())
{
Object arg=it.next();
//System.out.println(InputArg[+iArg+]=+arg);
uoSub.setArg(iArg++, arg);
}
// call
uoSub.call();
// get returned parameters
iArgs = uoSub.getNumArgs();
for (int i = 0; i iArgs; i++)
{
String arg=uoSub.getArg(i);
//System.out.println(OutputArg[+i+]=+arg);
oArgs.add(arg);
}
} catch (Exception ex)
{
System.err.println(Call to + sRoutine + failed.);
ex.printStackTrace(System.err);
}
return oArgs;
}
On 02/18/2011 01:16 PM, Stephen Jackson wrote:
So we created a basic program to call so we are getting closer, thanks for
all your input it is putting us on the correct path. I do seem to have
some issues when trying to get the results. What is happening is it is
just spitting out the input parameters ..
//System.err.println(command.response());
UniSubroutine sub = session.subroutine(S.XTMS.TEST.BASIC, 1);
sub.setArg(0, 0491865);
sub.call();
sub.resetArgs();
System.err.println(sub.getNumArgs());
System.err.println(sub);
System.err.println(sub.getArg(0));
//session.disconnect();
//String r = sub.getArg(0);
//String r1 = sub.getArg(1);
Logging statements:
Version Number :4.1.3
Max Open Files :32
Account Path :/datatel/test/10day/development
Locking Strategy :0
Release Strategy :12
Calling S.XTMS.TEST.LOOKUP...
1
asjava.uniobjects.UniSubroutine@6791d8c1
0491865 - same as input, not the result from the routine.
On WednesdayF/16/11 5:45 PM, Hona, Daviddavid.h...@cba.com.au wrote:
Does this subroutine do file I/O? Does it explicitly open the file or
assume some other program or subroutine opens it and stores the file
variable in labelled common...? Sometimes it can even be a call
subroutine call that is called using a labelled common variable (CALL
@MYSUB)...
Easiest thing to do is look how the subroutine is used now...if you don't
emulate the same initialisation sequence it requires from UV native
runtime environment in Java runtime environment...it more than likely
will not work.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Stephen Jackson
Sent: Thursday, 17 February 2011 1:28 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UniSubroutineException: Unknown Error [30102] Occurred
I am new to the U2 java api. I am trying to make a subroutine call but
get the following Exception. It is not in the documentation and I have
not had a lot of luck tracking it down. I am able to make a simple query
so not sure if there is some configuration or something I am not aware of
which is causing the error.
Version Number :4.1.3
Max Open Files :32
Account Path :/mypath
Locking Strategy :0
Release Strategy :12
Calling S.XTMS.TEST.LOOKUP...
[IBM U2][UniObjects for Java][UniSubroutine Exception][ErrorCode:
30102]Unknown Error [30102] Occurred
asjava.uniobjects.UniSubroutineException: Unknown Error [30102] Occurred
at asjava.uniobjects.UniSubroutine.call(UniSubroutine.java:150)
Any help would be much appreciated.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
** 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
Re: [U2] UniSubroutineException: Unknown Error [30102] Occurred
Try putting your input data into arg[1].
On 02/18/2011 06:25 PM, Stephen Jackson wrote:
My issue is that what ever I use as my input args is what prints out as my
return args along with the args number. Can that be caused by the routine not
returning anything?
Stephen Jackson
-Original Message-
From: Jeff Powell [j...@powellclan.com]
Received: Friday, 18 Feb 2011, 6:43pm
To: U2 Users List [u2-users@listserver.u2ug.org]
Subject: Re: [U2] UniSubroutineException: Unknown Error [30102] Occurred
The arg count going in needs to be n+1. Arg 0 will be the return data.
public ArrayList callSub(String sRoutine, ArrayList args)
{
Iterator it = args.iterator();
ArrayList oArgs = new ArrayList();
int iArgs = args.size();
System.out.println(Args: + iArgs);
try
{
UniSubroutine uoSub = ses.subroutine(sRoutine, iArgs + 1);
int iArg = 0;
uoSub.setArg(iArg++, ); // dummy argument - this
will become the return value
// Set user arguments
while (it.hasNext())
{
Object arg=it.next();
//System.out.println(InputArg[+iArg+]=+arg);
uoSub.setArg(iArg++, arg);
}
// call
uoSub.call();
// get returned parameters
iArgs = uoSub.getNumArgs();
for (int i = 0; i iArgs; i++)
{
String arg=uoSub.getArg(i);
//System.out.println(OutputArg[+i+]=+arg);
oArgs.add(arg);
}
} catch (Exception ex)
{
System.err.println(Call to + sRoutine + failed.);
ex.printStackTrace(System.err);
}
return oArgs;
}
On 02/18/2011 01:16 PM, Stephen Jackson wrote:
So we created a basic program to call so we are getting closer, thanks for
all your input it is putting us on the correct path. I do seem to have
some issues when trying to get the results. What is happening is it is
just spitting out the input parameters ..
//System.err.println(command.response());
UniSubroutine sub = session.subroutine(S.XTMS.TEST.BASIC, 1);
sub.setArg(0, 0491865);
sub.call();
sub.resetArgs();
System.err.println(sub.getNumArgs());
System.err.println(sub);
System.err.println(sub.getArg(0));
//session.disconnect();
//String r = sub.getArg(0);
//String r1 = sub.getArg(1);
Logging statements:
Version Number :4.1.3
Max Open Files :32
Account Path :/datatel/test/10day/development
Locking Strategy :0
Release Strategy :12
Calling S.XTMS.TEST.LOOKUP...
1
asjava.uniobjects.UniSubroutine@6791d8c1
0491865 - same as input, not the result from the routine.
On WednesdayF/16/11 5:45 PM, Hona, Daviddavid.h...@cba.com.au wrote:
Does this subroutine do file I/O? Does it explicitly open the file or
assume some other program or subroutine opens it and stores the file
variable in labelled common...? Sometimes it can even be a call
subroutine call that is called using a labelled common variable (CALL
@MYSUB)...
Easiest thing to do is look how the subroutine is used now...if you don't
emulate the same initialisation sequence it requires from UV native
runtime environment in Java runtime environment...it more than likely
will not work.
-Original Message-
From: u2-users-boun...@listserver.u2ug.org
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Stephen Jackson
Sent: Thursday, 17 February 2011 1:28 AM
To: u2-users@listserver.u2ug.org
Subject: [U2] UniSubroutineException: Unknown Error [30102] Occurred
I am new to the U2 java api. I am trying to make a subroutine call but
get the following Exception. It is not in the documentation and I have
not had a lot of luck tracking it down. I am able to make a simple query
so not sure if there is some configuration or something I am not aware of
which is causing the error.
Version Number :4.1.3
Max Open Files :32
Account Path :/mypath
Locking Strategy :0
Release Strategy :12
Calling S.XTMS.TEST.LOOKUP...
[IBM U2][UniObjects for Java][UniSubroutine Exception][ErrorCode:
30102]Unknown Error [30102] Occurred
asjava.uniobjects.UniSubroutineException: Unknown Error [30102] Occurred
at asjava.uniobjects.UniSubroutine.call(UniSubroutine.java:150)
Any help would be much appreciated.
___
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
** 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
Re: [U2] silly company names
From Charlie Noah: Totally OT, and I'm just musing here - Rocket, Raining Data then TigerLogic. Does anyone besides me see a trend here? Tony Gravagno wrote: Uh, I don't get it. How are those related? What trend? From: Charlie Noah Silly company names. Oh, well, Raining Data was an amazingly stupid name for a database company. As to the others, is anything really silly anymore considering the names we see every day? Yahoo!, Google, Bing, Twitter, Facebook, Digg, Drupal, Joomla, Mambo, Samba, (or more obscure) Vyatta, Wibiya, Stupeflix, Granicus, Zimbra, Xen (or how about Linux distros) Mandriva (formerly Mandrake), Ubuntu, Debian, Sabayon, (or just Linux release names) Etch, Lenny, Squeeze, Wheezy, Gutsy, Zoot, Shrike... I stopped thinking anything was silly in IT after grep, awk, and sed. The trend started decades ago when names like Johnson Software Co were all taken. This is just the world we live in. T ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] silly company names
I just Googled (oops) silly company names - there are tons of them out there. Sigh... Have a great weekend, Tony, Charlie On 02-18-2011 8:24 PM, Tony Gravagno wrote: From Charlie Noah: Totally OT, and I'm just musing here - Rocket, Raining Data then TigerLogic. Does anyone besides me see a trend here? Tony Gravagno wrote: Uh, I don't get it. How are those related? What trend? From: Charlie Noah Silly company names. Oh, well, Raining Data was an amazingly stupid name for a database company. As to the others, is anything really silly anymore considering the names we see every day? Yahoo!, Google, Bing, Twitter, Facebook, Digg, Drupal, Joomla, Mambo, Samba, (or more obscure) Vyatta, Wibiya, Stupeflix, Granicus, Zimbra, Xen (or how about Linux distros) Mandriva (formerly Mandrake), Ubuntu, Debian, Sabayon, (or just Linux release names) Etch, Lenny, Squeeze, Wheezy, Gutsy, Zoot, Shrike... I stopped thinking anything was silly in IT after grep, awk, and sed. The trend started decades ago when names like Johnson Software Co were all taken. This is just the world we live in. T ___ 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] Frustrated with Rocket / Unidata 7.2
Ah Bill, that was you? Thank you! That was the problem I ran into last week and the new UDT.OPTION fixed very nicely. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
