RE: [U2] UniObjects for Java on Linux
You little beauty, thank you very much. That has solved the problem. Time to tell the boss I can deliver on my promises . Cheers PJ -Original Message- From: John Hester [mailto:[EMAIL PROTECTED] Sent: Thursday, 12 January 2006 11:08 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UniObjects for Java on Linux PJ Velzeboer wrote: > I have an interesting problem. I have written a jsp page which queries > data from a UniVerse database using UniObjects for java (asjava.uniobjects.*). > Whenever I read a field from a file the contents of the UniString are > in the following format field1?field2?field3?filed4 etc. Effectively > this means that using UniDynArray.extract(field, value, subvalue); > doesn't work. Does anyone have any ideas? Yes, it seems all of us using UOJ on linux run into that one in the beginning ;). Just make the following change to the LANG environment variable setting: LANG="en_US.iso885915" The place to put it on RH linux is /etc/sysconfig/i18n. I'm not sure about other distros. That change will make the multivalue character translate correctly. -John -- John Hester System & Network Administrator Momentum Group Inc. (949) 833-8886 x623 http://memosamples.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.clearswift.com ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObjects for Java on Linux
On 1/11/06, PJ Velzeboer <[EMAIL PROTECTED]> wrote: > I have an interesting problem. I have written a jsp page which queries data > from a UniVerse database using UniObjects for java (asjava.uniobjects.*). > Whenever I read a field from a file the contents of the UniString are in the > following format field1?field2?field3?filed4 etc. Effectively this means that > using UniDynArray.extract(field, value, subvalue); doesn't work. Does anyone > have any ideas? Yes. Move the code to a Servlet, populate a collection of objects, and use JSTL to display the values: ${txn.code}${txn.branch}${txn.operator} Oh. You meant about the question marks. ;) Check the LANG settings on both the client and server... LANG=C is known to work. -- Wendy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniObjects for Java on Linux
PJ Velzeboer wrote: I have an interesting problem. I have written a jsp page which queries data from a UniVerse database using UniObjects for java (asjava.uniobjects.*). Whenever I read a field from a file the contents of the UniString are in the following format field1?field2?field3?filed4 etc. Effectively this means that using UniDynArray.extract(field, value, subvalue); doesn't work. Does anyone have any ideas? Yes, it seems all of us using UOJ on linux run into that one in the beginning ;). Just make the following change to the LANG environment variable setting: LANG="en_US.iso885915" The place to put it on RH linux is /etc/sysconfig/i18n. I'm not sure about other distros. That change will make the multivalue character translate correctly. -John -- John Hester System & Network Administrator Momentum Group Inc. (949) 833-8886 x623 http://memosamples.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniObjects for Java on Linux
Greetings, I have an interesting problem. I have written a jsp page which queries data from a UniVerse database using UniObjects for java (asjava.uniobjects.*). Whenever I read a field from a file the contents of the UniString are in the following format field1?field2?field3?filed4 etc. Effectively this means that using UniDynArray.extract(field, value, subvalue); doesn't work. Does anyone have any ideas? Cheers PJ sample code: // now we have all the transaction we can display them in reverse order for (int vectorIndex = tranVector.size() - 1; vectorIndex > -1; vectorIndex--) { uString = (UniString)tranVector.get(vectorIndex); transaction = new UniDynArray(uString); // in UniVerse the following three are stored as file<1, 1>, file<1, 2> and file<1, 3> String code = transaction.extract(1).toString(); String branch = transaction.extract(2).toString(); String operator = transaction.extract(3).toString(); // now the date is the second field in the UniVerse file with the effDate being the second value String date = uSession.oconv(transaction.extract(4, 1), "D").toString(); String effDate = uSession.oconv(transaction.extract(4, 2), "D").toString(); // results in a blank field out.println("" + code + "" + branch + ""); out.println("" + operator + "" + date + "" + effDate + ""); out.println("" + uString + ""); } ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.clearswift.com ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PROC Question
Goo'day, Jay Jay and . At 22:29 11/01/06 +, you wrote: It's been a LONG time ... I can remember writing a whole PL suite in MDIS PROC (don't ask...) I recall that in PQN procs you could have a construct such as PQN M RI IP: IF %1 = 1]2]3]4]5 G 10]20]30]40]50 That's the MDIS (MDD) method of multivaluing the input and associated actions, but the OP wanted to have one input and multiple actions, IIRC, so this isn't what was asked AFAIK with UV (we'd changed all of our MDD PQN PROCS on converting ot R83 PQs), you'd have to go to an internal subroutine ([]) and call each action in turn, and return as has already been suggested, or amend your "actions" programs to CHAIN from one to anotherwhich probably wouldn't be very clever T "Bad entry G B 10 XTEN 20 XTWENTY 30 XTHIRTY 40 XFORTY 50 XFIFTY Etc - or whatever (]=value marks by the way) Otherwise PQN IF %1 # 5 G F [USER.PL BASIC.PGM1] [USER.PL BASIC.PGM2] etc M BTW - I don't really like "G F" and "G B" - much prefer labels I haven't tried this on UniVerse but I hope this helps.. Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: 11 January 2006 17:35 To: U2-Users List Subject: [U2] PROC Question Hi folks, I can't find anything in the IBM Doc's for ProVerb's that tells me how to create an entry that will allow me to put multiple commands on a single line. In a nutshell, from a "menu" when a user selects an option, I want to be able to execute multiple commands. Currently, I use multiple lines such as: IF A = 5 [USER.PL BASIC.PGM1 IF A = 5 [USER.PL BASIC.PGM2 IF A = 5 G 10 What I want to be able to do is: IF A = 5 [USER.PL BASIC.PGM1];[USER.PL BASIC.PGM2];G 10 Is my mind fried? Maybe... But is there something that will work? BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.1.371 / Virus Database: 267.14.17/227 - Release Date: 11/01/06 Regards, Bruce Nichol Talon Computer Services ALBURYNSW 2640 Australia http://www.taloncs.com.au Tel: +61 (0)411149636 Fax: +61 (0)260232119 If it ain't broke, fix it till it is! -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.1.371 / Virus Database: 267.14.17/227 - Release Date: 11/01/06 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse call to Java class
Baker Hughes wrote: Thanks to Wendy, JayJay, and Kevin who responded to my previous posts about Java. Your replies, and the docs, all indicate that the U2 Java API only accommodates calls TO UV or UD databases, or Basic subroutines. From the code examples (found, thanks Wendy), and docs, it appears there is no UV call to a Java class, from within a Basic subroutine. In this credit card project, the UV host is actually the client, calling a Java API which communicates with a Linux host running Live Processor software (by Retail Decisions). The LP server then passes the Auth request or settlement to the actual credit card processor across a frame. I realize this doesn't answer your question, but have you considered cutting out the middleman in this scenario - meaning the LP software? The software vendor may also offer an XML web service gateway that will allow you to communicate with them directly from UV. They must have some kind of web service available that their own software is connecting to. We're in the process of going live with this kind of setup with Verisign, and the implementation was not very difficult. -John -- John Hester System & Network Administrator Momentum Group Inc. (949) 833-8886 x623 http://memosamples.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse call to Java class
On 1/11/06, Baker Hughes <[EMAIL PROTECTED]> wrote: > That's wild, a separate JVM for each thread? I thought it was been slow > to load but... > So, I just kicked off a runLPClientTest.sh and set the thread count to > 18. > Then from another session I did 'ps -eaf | grep java' > Only 1 process was spawned. Doesn't this mean just 1 jvm? I don't know what their Java code is doing, and I haven't seen your test script. I was cautioning you against executing "java" at the command prompt repeatedly as every time you do that, it creates a JVM. > They have a C API as well. Do you think that would be faster/thinner? > I see now, UV is much more prepared to do a C call, than a Java call. Problem solved. (There should be sample code in the same general area you looked for the other samples.) > In-house talent pool was leaning us toward the Java API. When all you have is hammer... ;) (Did you notice that I went straight for the Servlet/HTTP solution? To me... everything's a web service.) -- Wendy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse call to Java class
On 1/11/06, Wendy wrote: >I may have edited it out, but one question I had was, what kind >of volume are we talking about here? Five transactions an hour? A minute? A second? More? 300 authorizations an hour, max; 2 thousand a day, max. This is growing steadily though. >You do *not* want to do the equivalent of: >PCPERFORM "java com.exampleMyClass param1 param2" >either directly, or indirectly by calling a script that does the same thing. It's going to >create a JVM (Java Virtual Machine) every time. That won't scale at all. That's wild, a separate JVM for each thread? I thought it was been slow to load but... So, I just kicked off a runLPClientTest.sh and set the thread count to 18. Then from another session I did 'ps -eaf | grep java' Only 1 process was spawned. Doesn't this mean just 1 jvm? >I'm finding it hard to believe that a Java API is the only way to talk to the LiveProcessor >software _and_ that all you can do with the Java API is make a call to process a single >transaction. But assuming that's all true, I'd approach this one of two ways: They have a C API as well. Do you think that would be faster/thinner? I see now, UV is much more prepared to do a C call, than a Java call. In-house talent pool was leaning us toward the Java API. >I'd still lean towards a sockets-based solution. UV would use CallHTTP to talk to an >instance of Jetty or Tomcat running a little Servlet that picks up HTTP request parameters, >makes the call to the LP server, gets that response, and then sends a response back to UV. We are doing something like this now to perform an extended search on a webservice for parts lookup, but it seems rather slow. Maybe it's just the 492kz+ parts it's searching through. >I don't like this as much: Have UV write a record to a table with the transaction >information. From Java, with UOJ, constantly read records from that table, process the >transactions, and write back to it. Make sure you lock the records properly. This would be a single threaded solution? (1 phantom or cron to control) and require polling? (which means the next batch can't start until the last one ends) The reason I thought we should make 1 auth = 1 call is to immediately service each Auth request, as soon as CSR hits key to File order (or whatever trigger we invent in order taking process, though CSR will not be waiting, necessarily, for response. We close the sale whether/not Auth has been received, leave it to Credit to mop up later). >I don't see why you can't talk directly to the LiveProcessor software with CallHTTP or a >plain Socket, though. Their Java client has to be connecting somehow... The Java client is connecting with TCP to the LP software. Thanks for help, it's keeping the cranial juices flowing. -Baker --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse call to Java class {Unclassified}
Baker, > -Original Message- > From: [EMAIL PROTECTED] On Behalf Of Baker Hughes > Sent: Thursday, 12 January 2006 10:03 > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] UniVerse call to Java class > > It looks like the closest we can get to a Java call is either: > a) embedded shell command in Basic Sub call If you use something like ShellSentence = "MyShellScriptName -a ":ARG1:" -b ":QUOTE(ArgWithSpaces):" -X ConstantString" PERFORM "sh /c '":ShellSentence:"'" You can pass arguments on the command line. > b) 'Execute' a Voc pointer from Basic Sub that has a shell command >Does anyone have an example of this? >a & b don't offer easy way to pass arguments, do they? > > c) wrap the Java call in a C program and call that through the GCI > I guess I could just use their C API (after all the hair pulling to get > the Java API to run) > > A couple goals to guide methodology: > 1) Multi-thread capability, persistent until finished, 1 authorization = 1 call > 2) Speed, with desire to eventually make this 'on-line' authorizations >if responses are fast enough (in milliseconds) I doubt if the 'PERFORM "sh /c ... ' approach will scale above a very small level Hope this helps Mike > > Thanks to everyone for the corporate musings. > > R. Baker Hughes > UniVerse Programming > Mouser Electronics, Inc. > > > > from Gordon - > >UV has the GCI (General Call Interface) that allows it to > make calls to > > >external subroutines written in C, C++ and Fortran 77. > > > >P.S. I think we should add this functionality request to our > enhancement > >request list. Fortran 77? Does that even exist anymore? > I'm thinking > a > >Java interface would be much more in demand that a Fortran 77 one. > > Well said. > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > The information contained in this Internet Email message is intended for the addressee only and may contain privileged information, but not necessarily the official views or opinions of the New Zealand Defence Force. If you are not the intended recipient you must not use, disclose, copy or distribute this message or the information in it. If you have received this message in error, please Email or telephone the sender immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PROC Question
It's been a LONG time ... I can remember writing a whole PL suite in MDIS PROC (don't ask...) I recall that in PQN procs you could have a construct such as PQN M RI IP: IF %1 = 1]2]3]4]5 G 10]20]30]40]50 T "Bad entry G B 10 XTEN 20 XTWENTY 30 XTHIRTY 40 XFORTY 50 XFIFTY Etc - or whatever (]=value marks by the way) Otherwise PQN IF %1 # 5 G F [USER.PL BASIC.PGM1] [USER.PL BASIC.PGM2] etc M BTW - I don't really like "G F" and "G B" - much prefer labels I haven't tried this on UniVerse but I hope this helps.. Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: 11 January 2006 17:35 To: U2-Users List Subject: [U2] PROC Question Hi folks, I can't find anything in the IBM Doc's for ProVerb's that tells me how to create an entry that will allow me to put multiple commands on a single line. In a nutshell, from a "menu" when a user selects an option, I want to be able to execute multiple commands. Currently, I use multiple lines such as: IF A = 5 [USER.PL BASIC.PGM1 IF A = 5 [USER.PL BASIC.PGM2 IF A = 5 G 10 What I want to be able to do is: IF A = 5 [USER.PL BASIC.PGM1];[USER.PL BASIC.PGM2];G 10 Is my mind fried? Maybe... But is there something that will work? BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse call to Java class
The way to go is a C wrapper for the Java API - most efficient way etc You need to watch you don't "leak" though. As an alternative I would recommend putting a free-standing wrapper around a Java listener process running as a service (daemon) and having it listen on a socket stream. The UniVerse process which wishes to make a call to the CC verifier then makes a socket call to open a socket stream to the listener. The listener in turn spawns a thread to deal with the received connection request and resumes listening for the (next) call. Meanwhile . The spawned thread handles the request via direct Java API and returns the result on the socket data stream before terminating the thread. This is a neat approach (if I say so myself) and I've used it in the past (or very similar ones anyway) to create TAPI and ATAPI interfaces into U2 with a full client/server API in GCI (before native socket support). The "Listener process" approach allows you to add different API interfaces as other daemons and just have them listen on a different port. That way no change to the BASIC programs is needed, just a port number in a configuration file needs editing. You can add other CC services fairly easily as requirements change. Hope it helps Regards JayJay -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: 11 January 2006 18:28 To: u2-users@listserver.u2ug.org Subject: [U2] UniVerse call to Java class Thanks to Wendy, JayJay, and Kevin who responded to my previous posts about Java. Your replies, and the docs, all indicate that the U2 Java API only accommodates calls TO UV or UD databases, or Basic subroutines. >From the code examples (found, thanks Wendy), and docs, it appears there is no UV call to a Java class, from within a Basic subroutine. In this credit card project, the UV host is actually the client, calling a Java API which communicates with a Linux host running Live Processor software (by Retail Decisions). The LP server then passes the Auth request or settlement to the actual credit card processor across a frame. We can run the Java client (a testing shell script) from the Unix command line and test the connection and run Test scenarios. That all works. What I need help on is some elegant way to make the client call from UV Basic, hopefully passing/receiving some arguments/parameters. The client is multi-threaded so the connection is persistent for the life of each call, returning a Transaction ID and various response codes (decline/approval & why, etc.). Thanks for taking the time. I'm thankful for this community. TIA. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC Difficulties
Thanks for the heads up, I do appreciate all the different ideas about this ODBC problem, but the uid and pw are both letters and numbers, no symbols. -K --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse call to Java class
On 1/11/06, Brutzman, Bill <[EMAIL PROTECTED]> wrote: > I believe that there is a way to invoke a Unix command-line thing (program) > from within UniBasic. On UniData it's PCPERFORM. I may have edited it out, but one question I had was, what kind of volume are we talking about here? Five transactions an hour? A minute? A second? More? You do *not* want to do the equivalent of: PCPERFORM "java com.exampleMyClass param1 param2" either directly, or indirectly by calling a script that does the same thing. It's going to create a JVM (Java Virtual Machine) every time. That won't scale at all. I'm finding it hard to believe that a Java API is the only way to talk to the LiveProcessor software _and_ that all you can do with the Java API is make a call to process a single transaction. But assuming that's all true, I'd approach this one of two ways: I'd still lean towards a sockets-based solution. UV would use CallHTTP to talk to an instance of Jetty or Tomcat running a little Servlet that picks up HTTP request parameters, makes the call to the LP server, gets that response, and then sends a response back to UV. The Servlet container will handle threading, parsing the request and forming the response, etc. All you'll have to do is call request.getParameter(...) insert the Java code to talk to the LP server, and response.write(...). I think. I haven't done pure Servlets for a while. :) I don't like this as much: Have UV write a record to a table with the transaction information. From Java, with UOJ, constantly read records from that table, process the transactions, and write back to it. Make sure you lock the records properly. I don't see why you can't talk directly to the LiveProcessor software with CallHTTP or a plain Socket, though. Their Java client has to be connecting somehow... -- Wendy --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse call to Java class
It looks like the closest we can get to a Java call is either: a) embedded shell command in Basic Sub call b) 'Execute' a Voc pointer from Basic Sub that has a shell command Does anyone have an example of this? a & b don't offer easy way to pass arguments, do they? c) wrap the Java call in a C program and call that through the GCI I guess I could just use their C API (after all the hair pulling to get the Java API to run) A couple goals to guide methodology: 1) Multi-thread capability, persistent until finished, 1 authorization = 1 call 2) Speed, with desire to eventually make this 'on-line' authorizations if responses are fast enough (in milliseconds) Thanks to everyone for the corporate musings. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. from Gordon - >UV has the GCI (General Call Interface) that allows it to make calls to >external subroutines written in C, C++ and Fortran 77. > >P.S. I think we should add this functionality request to our enhancement >request list. Fortran 77? Does that even exist anymore? I'm thinking a >Java interface would be much more in demand that a Fortran 77 one. Well said. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse call to Java class
> Thanks to Wendy, JayJay, and Kevin who responded to my previous posts > about Java. > > Your replies, and the docs, all indicate that the U2 Java API only > accommodates calls TO UV or UD databases, or Basic subroutines. > >>From the code examples (found, thanks Wendy), and docs, it appears there > is no UV call to a Java class, from within a Basic subroutine. > > In this credit card project, the UV host is actually the client, calling > a Java API which communicates with a Linux host running Live Processor > software (by Retail Decisions). The LP server then passes the Auth > request or settlement to the actual credit card processor across a > frame. > > We can run the Java client (a testing shell script) from the Unix > command line and test the connection and run Test scenarios. That all > works. > > What I need help on is some elegant way to make the client call from UV > Basic, hopefully passing/receiving some arguments/parameters. The > client is multi-threaded so the connection is persistent for the life of > each call, returning a Transaction ID and various response codes > (decline/approval & why, etc.). So, why don't you use the test scripts. Enhance them and then call them from uniVerse BASIC. I do that all the time for automated FTP data transfers for real-time dual database updating. If you need some pointers for command-line options, I'll be willing to help sans-fee, if it's cursory and not time-consuming. If you want the script written, I can do that, for fee. I've done that for others who needed help for picking up and passing to their database, the real-time data transfers. (that was an awkward sentence, almost like English is my primary language. Okay, it is; American English.) HTH Karl > > Thanks for taking the time. I'm thankful for this community. TIA. > > R. Baker Hughes > UniVerse Programming > Mouser Electronics, Inc. > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ > -- karl _/ _/ _/ _/_/_/ __o _/ _/ _/ _/_/ _-\<._ _/_/_/ _/_/_/ (_)/ (_) _/ _/ _/ _/ .. _/ _/ arl _/_/_/ _/ earson[EMAIL PROTECTED] -- IT Director, ATS Industrial Supply, Inc. http://www.atsindustrial.com Toll-free: 800-789-9300 x29 Direct2Desk: 801-978-4429 Facsimile: 801-972-3888 -- --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse call to Java class
I believe that there is a way to invoke a Unix command-line thing (program) from within UniBasic. --Bill -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Baker Hughes Sent: Wednesday, January 11, 2006 1:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] UniVerse call to Java class Thanks to Wendy, JayJay, and Kevin who responded to my previous posts about Java. Your replies, and the docs, all indicate that the U2 Java API only accommodates calls TO UV or UD databases, or Basic subroutines. >From the code examples (found, thanks Wendy), and docs, it appears there is no UV call to a Java class, from within a Basic subroutine. In this credit card project, the UV host is actually the client, calling a Java API which communicates with a Linux host running Live Processor software (by Retail Decisions). The LP server then passes the Auth request or settlement to the actual credit card processor across a frame. We can run the Java client (a testing shell script) from the Unix command line and test the connection and run Test scenarios. That all works. What I need help on is some elegant way to make the client call from UV Basic, hopefully passing/receiving some arguments/parameters. The client is multi-threaded so the connection is persistent for the life of each call, returning a Transaction ID and various response codes (decline/approval & why, etc.). Thanks for taking the time. I'm thankful for this community. TIA. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PROC Question
Thanks, everyone. I got exactly the answer I was afraid I would get. Yes, my mind is fried... Because of system programming standards, I need to stay with a PROC but I was hoping to be able to streamline them a little bit. I appreciate the answers everyone offered, including the ones to quit using PROC's (and the thought has crossed my mind a number of times) but for the most part, we keep the PROC's pretty simple. Again, thanks. BobW -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Wednesday, January 11, 2006 9:35 AM To: U2-Users List Subject: [U2] PROC Question Hi folks, I can't find anything in the IBM Doc's for ProVerb's that tells me how to create an entry that will allow me to put multiple commands on a single line. In a nutshell, from a "menu" when a user selects an option, I want to be able to execute multiple commands. Currently, I use multiple lines such as: IF A = 5 [USER.PL BASIC.PGM1 IF A = 5 [USER.PL BASIC.PGM2 IF A = 5 G 10 What I want to be able to do is: IF A = 5 [USER.PL BASIC.PGM1];[USER.PL BASIC.PGM2];G 10 Is my mind fried? Maybe... But is there something that will work? BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] UniVerse call to Java class
I don't even know if this is possible as I'm not a C or Java programmer. UV has the GCI (General Call Interface) that allows it to make calls to external subroutines written in C, C++ and Fortran 77. It seems to me that you should be able to create a "wrapper" in C++ that would call the Java API and then return the data from the Java credit card software to the UV application. Again, I don't know if C++ can be made to "talk" with Java either. Just an idea, Gordon P.S. I think we should add this functionality request to our enhancement request list. Fortran 77? Does that even exist anymore? I'm thinking a Java interface would be much more in demand that a Fortran 77 one. Gordon J. Glorfield Sr. Applications Developer MAMSI (A UnitedHealth Company) 301-360-8839 [EMAIL PROTECTED] wrote on 01/11/2006 01:28:00 PM: > Thanks to Wendy, JayJay, and Kevin who responded to my previous posts > about Java. > Your replies, and the docs, all indicate that the U2 Java API only > accommodates calls TO UV or UD databases, or Basic subroutines. > From the code examples (found, thanks Wendy), and docs, it appears there > is no UV call to a Java class, from within a Basic subroutine. > In this credit card project, the UV host is actually the client, calling > a Java API which communicates with a Linux host running Live Processor > software (by Retail Decisions). The LP server then passes the Auth > request or settlement to the actual credit card processor across a > frame. > We can run the Java client (a testing shell script) from the Unix > command line and test the connection and run Test scenarios. That all > works. > What I need help on is some elegant way to make the client call from UV > Basic, hopefully passing/receiving some arguments/parameters. The > client is multi-threaded so the connection is persistent for the life of > each call, returning a Transaction ID and various response codes > (decline/approval & why, etc.). > Thanks for taking the time. I'm thankful for this community. TIA. > R. Baker Hughes > UniVerse Programming > Mouser Electronics, Inc. [snip] This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PROC Question
Wouldn't you rather just rewrite the proc in basic? > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward > Sent: Wednesday, January 11, 2006 12:35 PM > To: U2-Users List > Subject: [U2] PROC Question > > > Hi folks, > > I can't find anything in the IBM Doc's for ProVerb's that > tells me how to create an entry that will allow me to put > multiple commands on a single line. In a nutshell, from a > "menu" when a user selects an option, I want to be able to > execute multiple commands. > > Currently, I use multiple lines such as: >IF A = 5 [USER.PL BASIC.PGM1 >IF A = 5 [USER.PL BASIC.PGM2 >IF A = 5 G 10 > > What I want to be able to do is: >IF A = 5 [USER.PL BASIC.PGM1];[USER.PL BASIC.PGM2];G 10 > > Is my mind fried? Maybe... But is there something that will work? > > BobW > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PROC Question
The only sensible ways are: 1. Subroutines GOSUB n n MV #1 "blah" P .. RSUB 2. Ext subroutines C has commands [file someproc] 3. Execute something sensible like a paragraph and give up using ugly PROCs Brian "Like PROC - ugly but works" -Original Message- From: "Bob Woodward"<[EMAIL PROTECTED]> Sent: 11/01/06 17:34:49 To: "U2-Users List" Subject: [U2] PROC Question Hi folks, I can't find anything in the IBM Doc's for ProVerb's that tells me how to create an entry that will allow me to put multiple commands on a single line. In a nutshell, from a "menu" when a user selects an option, I want to be able to execute multiple commands. Currently, I use multiple lines such as: IF A = 5 [USER.PL BASIC.PGM1 IF A = 5 [USER.PL BASIC.PGM2 IF A = 5 G 10 What I want to be able to do is: IF A = 5 [USER.PL BASIC.PGM1];[USER.PL BASIC.PGM2];G 10 Is my mind fried? Maybe... But is there something that will work? BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [Message truncated. Tap Edit->Mark for Download to get remaining portion.] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC Difficulties
That's right - I also had a problem with a user that had a password with a symbol in it. I don't recall which - I think it was just the "$". Colin >-Original Message- >From: robert dunnmiller > >I encountered an issue with ODBC connectivity, very similar to >what you are reporting. The solution (as incomprehensible as >it sounds) was the length of the user name and password. Once >I used a user ID that was 8 characters (or less) and a >password that was 9 characters (or less), my connectivity >issues were resolved. > >Just my $.02. > >Regards, > >Robert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PROC Question
Bob: I used to be pretty proficient in PROC and have never heard of this...but that doesn't mean it doesn't exist. :-) Bill > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward > Sent: Wednesday, January 11, 2006 9:35 AM > To: U2-Users List > Subject: [U2] PROC Question > > Hi folks, > > I can't find anything in the IBM Doc's for ProVerb's that > tells me how to create an entry that will allow me to put > multiple commands on a single line. In a nutshell, from a > "menu" when a user selects an option, I want to be able to > execute multiple commands. > > Currently, I use multiple lines such as: >IF A = 5 [USER.PL BASIC.PGM1 >IF A = 5 [USER.PL BASIC.PGM2 >IF A = 5 G 10 > > What I want to be able to do is: >IF A = 5 [USER.PL BASIC.PGM1];[USER.PL BASIC.PGM2];G 10 > > Is my mind fried? Maybe... But is there something that will work? > > BobW > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PROC Question
Why not form GO TO blocks? Example: 5 C Print Menu T C O MENU 10 C Input Menu Option IP IF A = 1 GO 100 IF A = 2 GO 200 IF A = 3 GO 300 GO 10 100 C First menu Option HRUN USER.PL BASIC.PGM1 P HRUN USER.PL BASIC.PGM2 P GO 5 200 C Second Menu Option HRUN USER.PL BASIC.PGM4 P HRUN USER.PL BASIC.PGM2 P GO 5 300 C Command Command Command GO 5 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Wednesday, January 11, 2006 9:35 AM To: U2-Users List Subject: [U2] PROC Question Hi folks, I can't find anything in the IBM Doc's for ProVerb's that tells me how to create an entry that will allow me to put multiple commands on a single line. In a nutshell, from a "menu" when a user selects an option, I want to be able to execute multiple commands. Currently, I use multiple lines such as: IF A = 5 [USER.PL BASIC.PGM1 IF A = 5 [USER.PL BASIC.PGM2 IF A = 5 G 10 What I want to be able to do is: IF A = 5 [USER.PL BASIC.PGM1];[USER.PL BASIC.PGM2];G 10 Is my mind fried? Maybe... But is there something that will work? BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PROC Question
Maybe something like this? IF A = 5 G 500 ... 500 C [USER.PL BASIC1 [USER.PL BASIC2 G 10 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Woodward Sent: Wednesday, January 11, 2006 10:35 AM To: U2-Users List Subject: [U2] PROC Question Hi folks, I can't find anything in the IBM Doc's for ProVerb's that tells me how to create an entry that will allow me to put multiple commands on a single line. In a nutshell, from a "menu" when a user selects an option, I want to be able to execute multiple commands. Currently, I use multiple lines such as: IF A = 5 [USER.PL BASIC.PGM1 IF A = 5 [USER.PL BASIC.PGM2 IF A = 5 G 10 What I want to be able to do is: IF A = 5 [USER.PL BASIC.PGM1];[USER.PL BASIC.PGM2];G 10 Is my mind fried? Maybe... But is there something that will work? BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UniVerse call to Java class
Thanks to Wendy, JayJay, and Kevin who responded to my previous posts about Java. Your replies, and the docs, all indicate that the U2 Java API only accommodates calls TO UV or UD databases, or Basic subroutines. >From the code examples (found, thanks Wendy), and docs, it appears there is no UV call to a Java class, from within a Basic subroutine. In this credit card project, the UV host is actually the client, calling a Java API which communicates with a Linux host running Live Processor software (by Retail Decisions). The LP server then passes the Auth request or settlement to the actual credit card processor across a frame. We can run the Java client (a testing shell script) from the Unix command line and test the connection and run Test scenarios. That all works. What I need help on is some elegant way to make the client call from UV Basic, hopefully passing/receiving some arguments/parameters. The client is multi-threaded so the connection is persistent for the life of each call, returning a Transaction ID and various response codes (decline/approval & why, etc.). Thanks for taking the time. I'm thankful for this community. TIA. R. Baker Hughes UniVerse Programming Mouser Electronics, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] PROC Question
That type of functionality is not possible (unless PROC has been modified since I worked in it) - that's the reason you can't find anything in the documentation. You have a choice of doing it the way you are, or using GOSUB/GOTO to define the multiple lines as a "subroutine". _ "I reject your reality and substitute my own" - Adam Savage Glenn M. Herbert - Connectivity Development Engineer Information Integration Solutions, IBM Software Group 50 Washington Street Westboro, MA 01581 508-599-7281 direct "Bob Woodward" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/11/2006 12:34 PM Please respond to u2-users To "U2-Users List" cc Subject [U2] PROC Question Hi folks, I can't find anything in the IBM Doc's for ProVerb's that tells me how to create an entry that will allow me to put multiple commands on a single line. In a nutshell, from a "menu" when a user selects an option, I want to be able to execute multiple commands. Currently, I use multiple lines such as: IF A = 5 [USER.PL BASIC.PGM1 IF A = 5 [USER.PL BASIC.PGM2 IF A = 5 G 10 What I want to be able to do is: IF A = 5 [USER.PL BASIC.PGM1];[USER.PL BASIC.PGM2];G 10 Is my mind fried? Maybe... But is there something that will work? BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC Difficulties
Thanks Robert. The user ID is currently 4 characters and the password is currently 7. -k --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] PROC Question
Hi folks, I can't find anything in the IBM Doc's for ProVerb's that tells me how to create an entry that will allow me to put multiple commands on a single line. In a nutshell, from a "menu" when a user selects an option, I want to be able to execute multiple commands. Currently, I use multiple lines such as: IF A = 5 [USER.PL BASIC.PGM1 IF A = 5 [USER.PL BASIC.PGM2 IF A = 5 G 10 What I want to be able to do is: IF A = 5 [USER.PL BASIC.PGM1];[USER.PL BASIC.PGM2];G 10 Is my mind fried? Maybe... But is there something that will work? BobW --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC Difficulties
I encountered an issue with ODBC connectivity, very similar to what you are reporting. The solution (as incomprehensible as it sounds) was the length of the user name and password. Once I used a user ID that was 8 characters (or less) and a password that was 9 characters (or less), my connectivity issues were resolved. Just my $.02. Regards, Robert Original Message: - From: Kevin King [EMAIL PROTECTED] Date: Wed, 11 Jan 2006 06:25:17 -0700 To: u2-users@listserver.u2ug.org Subject: RE: [U2] ODBC Difficulties I forgot to mention that I'm using the same user ID on both systems, so it would seem that it's not the privilege file. Also, the fact that the errors get returned immediately - as if it doesn't even make an effort to connect - makes me think something is amiss with the driver. There should be no difference installing as a User DSN vs. System DSN, right? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ mail2web - Check your email from the web at http://mail2web.com/ . --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] Training resources in India.
Does anyone out there have any information regarding U2 training availability in India? In particular the Kolkata area of India. Rich Taylor | Senior Programmer/Analyst --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] UV: Other ways of replicating?
UniVerse users, Recently, we've been looking at ways of developing a high availability cluster for our production UniVerse environment. Thanks to www.linux-ha.org we've been able to install two machines at different locations (cities twenty miles apart) and if the primary machine drops, users can log into the same IP address within a few seconds. The problem we have run into is replicating our data across the two nodes. The best way would be database replication. Unfortunately, UniVerse can't replicate the type 1 and type 19 files, which we use extensively. Further, we cannot use ALTER.TABLE or CLEAR.FILE on replicated files. (These from the Administrators manual.) The second option we've looked at is some sort of disk replication. IBM recommends DRBD for use with DB2. Unfortunately, it seems that this would not provide referential integrity. The third option we looked at was a complicated mix of transaction logs and NFS mounts. Our standby box would be constantly updating itself off of the transaction logs of the primary. In the event of an outage, the standby comes up more or less updated and the dead primary can refresh itself off of the standby's logs when it comes back up. Does anyone have any experience getting around the shortcomings of UniVerse's replication? Thanks, Mike Doyle Unix Developer / Administrator --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC Difficulties
Rats, that was my best guess - unless it's some kind of "domain" type issue. (I don't give up easy do I?) Which version of the driver are you using? There were different drivers with the 6.0a and 6.0b client CD's, I might have even gotten a patched one from IBM. I always use the System DSN. I think there was a reason for it - but it escapes me now. Colin >-Original Message- >From: Kevin King > >I forgot to mention that I'm using the same user ID on both >systems, so it would seem that it's not the privilege file. >Also, the fact that the errors get returned immediately - as >if it doesn't even make an effort to connect - makes me think >something is amiss with the driver. > >There should be no difference installing as a User DSN vs. >System DSN, right? > >-Kevin --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ODBC Difficulties
I forgot to mention that I'm using the same user ID on both systems, so it would seem that it's not the privilege file. Also, the fact that the errors get returned immediately - as if it doesn't even make an effort to connect - makes me think something is amiss with the driver. There should be no difference installing as a User DSN vs. System DSN, right? -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DATE conversion problem
Hi, Universe defaults to American style date format. To get round this, I explicitly set european date format when I create the session object: sess.command("DATE.FORMAT ON") where sess is the session object. hth, cheers, asvin [EMAIL PROTECTED] wrote on 11/01/2006 11:08:40: > REPOSTED FOR NONMEMBER: "Kryka, Richard" <[EMAIL PROTECTED]> > I have a specific problem whereby any formatting I do using > UniObjects always gives me the date in US format even though all PC > settings say UK settings. > > I think that UniObjects goes back to the UniVerse system for date > conversions. So you may want to look at your settings there. Be > careful about using the UniObjects date conversion - every conversion is > a call back to UniVerse. If you have a large array coming from UniVerse > with internal dates and attempt to convert them within VB, it gets very > slow. We wrote our own VB date conversion routines to get around this. > Dick Kryka > Director of Applications > CCCS of Greater Denver, Inc. > Paragon Financial Services > 303-632-2226 > [EMAIL PROTECTED] > --- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ HSBC Bank plc may be solicited in the course of its placement efforts for a new issue, by investment clients of the firm for whom the Bank as a firm already provides other services. It may equally decide to allocate to its own proprietary book or with an associate of HSBC Group. This represents a potential conflict of interest. HSBC Bank plc has internal arrangements designed to ensure that the firm would give unbiased and full advice to the corporate finance client about the valuation and pricing of the offering as well as internal systems, controls and procedures to identify and manage conflicts of interest. HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ, United Kingdom Registered in England - Number 14259 Authorised and regulated by the Financial Services Authority. - This transmission has been issued by a member of the HSBC Group "HSBC" for the information of the addressee only and should not be reproduced and/or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] DATE conversion problem
REPOSTED FOR NONMEMBER: "Kryka, Richard" <[EMAIL PROTECTED]> I have a specific problem whereby any formatting I do using UniObjects always gives me the date in US format even though all PC settings say UK settings. I think that UniObjects goes back to the UniVerse system for date conversions. So you may want to look at your settings there. Be careful about using the UniObjects date conversion - every conversion is a call back to UniVerse. If you have a large array coming from UniVerse with internal dates and attempt to convert them within VB, it gets very slow. We wrote our own VB date conversion routines to get around this. Dick Kryka Director of Applications CCCS of Greater Denver, Inc. Paragon Financial Services 303-632-2226 [EMAIL PROTECTED] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/