Re: [U2] Unix to SQL Server
Hello, On 11/14/05, Norman, David (SAAS) [EMAIL PROTECTED] wrote: I know I'm probably going over old ground again, but what's the present state of play for UniVerse on HP-UX connecting to SQL Server on w2000/2003 to update tables ? Do I need middleware ? Most likely unless you want to get down and dirty with communicating using custom C function calls. At least, my understanding. If so, what is recommended ? UV10.0.16 HP-UX 11 I would recommend Datastage (formerly by Ascential Software and now by IBM). HTH, Andy -- The Linux philosophy is 'Laugh in the face of danger'. Oops. Wrong One. 'Do it yourself'. Yes, that's it. Linus Torvalds --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unix to SQL Server
Old ground it is - you either need a third party unix odbc driver for ms Sql or a third party odbc bridge (my preferred) from the likes of easysoft. On 11/15/05, Norman, David (SAAS) [EMAIL PROTECTED] wrote: I know I'm probably going over old ground again, but what's the present state of play for UniVerse on HP-UX connecting to SQL Server on w2000/2003 to update tables ? Do I need middleware ? If so, what is recommended ? UV10.0.16 HP-UX 11 Thanks, David Norman Senior Software Engineer SA Ambulance Service Box 3, GPO Adelaide, South Australia 5001 *+61 8 8274 0384 fax +61 8 8271 0758 * [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] --- 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] support of pterm command options under red hat linux or better idea
You probably need to tweak the terminfo files. We are running Universe/Linux and we use VP terminals. Here is our /usr/ibm/uv/terminfo/v/vp file; [EMAIL PROTECTED] v]# infocmp vp # Reconstructed via infocmp from file: /usr/share/terminfo/v/vp vp|av|vwpt|viewpoint|Adds viewpoint, am, bw, cols#80, lines#24, bel=^G, civis=^W, clear=^L, cnorm=^X, cr=^M, cub1=^H, cuf1=^F, cup=\EY%p1%' '%+%c%p2%' '%+%c, cuu1=^Z, ed=\Ek, el=\EK, ht=^I, ind=^J, is2=\E%!5n\036\031\E%5n\026\031\r, kbs=^H, kcbt=\EI, kclr=^L, kcub1=^U, kcud1=^J, kcuf1=^F, kcuu1=^Z, kdch1=\177, ked=\Ek, kel=\EK, kf1=^B1\r, kf10=^B\:\r, kf2=^B2\r, kf3=^B3\r, kf4=^B4\r, kf5=^B5\r, kf6=^B6\r, kf7=^B7\r, kf8=^B8\r, kf9=^B9\r, khome=^A, khts=^I, kll=^A, knp=^V, kpp=^^, lf1=F1, lf2=F2, lf3=F3, lf4=F4, lf5=F5, lf6=F6, lf7=F7, lf8=F8, ll=^A, mc4=^T, mc5=^R, pad=\0, prot=^N, sgr0=^O, vpa=\013%p1%' '%+%c, And here is the linux terminfo; [EMAIL PROTECTED] v]# pwd /usr/share/terminfo/v [EMAIL PROTECTED] v]# infocmp vp # Reconstructed via infocmp from file: /usr/share/terminfo/v/vp vp|av|vwpt|viewpoint|Adds viewpoint, am, bw, cols#80, lines#24, bel=^G, civis=^W, clear=^L, cnorm=^X, cr=^M, cub1=^H, cuf1=^F, cup=\EY%p1%' '%+%c%p2%' '%+%c, cuu1=^Z, ed=\Ek, el=\EK, ht=^I, ind=^J, is2=\E%!5n\036\031\E%5n\026\031\r, kbs=^H, kcbt=\EI, kclr=^L, kcub1=^U, kcud1=^J, kcuf1=^F, kcuu1=^Z, kdch1=\177, ked=\Ek, kel=\EK, kf1=^B1\r, kf10=^B\:\r, kf2=^B2\r, kf3=^B3\r, kf4=^B4\r, kf5=^B5\r, kf6=^B6\r, kf7=^B7\r, kf8=^B8\r, kf9=^B9\r, khome=^A, khts=^I, kll=^A, knp=^V, kpp=^^, lf1=F1, lf2=F2, lf3=F3, lf4=F4, lf5=F5, lf6=F6, lf7=F7, lf8=F8, ll=^A, mc4=^T, mc5=^R, pad=\0, prot=^N, sgr0=^O, vpa=\013%p1%' '%+%c, Chapter 10 in the administering manual has the info on uvtic... Hope This Helps Anthony Dzikiewicz -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MIS Sent: Tuesday, November 15, 2005 9:53 AM To: u2-users@listserver.u2ug.org Subject: [U2] support of pterm command options under red hat linux or better idea I have universe 10.0 for linux. The documentation says that under BSD's, the pterm susp command is supported, but under sysV systems, the pterm susp command is not supported. How would I determine for sure whether it is supported or not on my live system? The problem is we are running the ADDS VP emulation, (for no reason apparent to me), and it sends CTRL-Z as the up arrow key. Linux traps that command as the suspend command in either telnet or bash before it gets sent to UV. On this list, Ben Rosenberg said the way to fix that is to run pterm susp off. He also mentioned another way, but that requires setting the linux user shell to bash, but our software vendor wants the linux user shell set to mv. After setting the linux user shell to mv, we can't run the linux comand: stty susp ^-. If anybody has any advice, or even pointers to specific differences between the linux UV version and unix UV versions, I would greatly appreciate it. Thank you, Matt Grab MIS Administrator Cindy Rowe Auto Glass --- 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] Need help with NFAUSER
We have NFA working from Windows to HP-UX. The last remaining problem is that, since we're running at a console, we get prompted for a username and password. Page 3-28 of the Developing OFS/NFA Applications manual says, UniBasic provides the NFAUSER function which enables you to set the user name and password in a UniBasic program. Syntax: NFAUSER(username, password) When I try this, I get: BASIC BP_SOURCE XWDS.BCI -i Compiling Unibasic: BP_SOURCE\XWDS.BCI in mode 'u'. main program: syntax error at or before line 34 NFAUSER( user, pass ) --^ Expecting: array,label,variable,verb,MAT,COM,ON,BREAK,PAGE,GOSUB compilation failed This seems to be the last holdup to our ODBC-access-from-UniData solution, which (since we never could get it to work from HP-UX) involves a Windows box speaking ODBC to Sybase, then NFA to UniData on HP-UX. Am I missing something obvious? There's no VOC pointer for NFAUSER. The docs say it's been available since UniData 5. Has it been replaced with something else? Thanks, -- Wendy Smoak --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Credit Card Handlers
It is certainly possible. The questions to ask include the authorization service provider you want to work with (or several depending on your business topology), the level of integration you want (API or full integration), and of course the big one: Cost. There are a number of companies that provide credit card services with varying levels of integration ability and cost. At Precision Solutions, our Achieve credit card interface that can be configured to talk to whatever service provider you choose, so you're not specifically limited to a specific service. We have clients who use a single Achieve instance that communicates with several backend service providers across multiple countries, servicing several front-end (both U2 and non-U2) clients. And if at some point you decide to change service providers, your business system application does not need to change to adapt, as Achieve handles the protocol issues and communication details with your new service provider. Additional information about Achieve, including screen shots, can be found at http://www.PrecisOnline.com/achieve4.html. (Apologies to the group for the ad.) -Kevin [EMAIL PROTECTED] http://www.PrecisOnline.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, November 15, 2005 11:12 AM To: u2-users@listserver.u2ug.org Subject: [U2] Credit Card Handlers Oh wise ones... We have a competitor at one client that processes credit cards for them with line-item detail of their purchases. I'm not familiar enough with credit card processing to know if doing so via U2 is possible. Currently we have a card swiper in a central location and all cards are processed there. I'd like a solution that would allow our sales team to just type the number in and have things automagically happen, with a verification printed on the forms we currently generate in our 'legacy' U2 application. We aren't using anything other than the text-based green screen application, albeit via nice XP-based PCs (Okay, I'd rather they ran on Linux as I do). TIA -- 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/ -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.1/169 - Release Date: 11/15/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Unix to SQL Server
Norman, David (SAAS) wrote: I know I'm probably going over old ground again, but what's the present state of play for UniVerse on HP-UX connecting to SQL Server on w2000/2003 to update tables ? Do I need middleware ? If so, what is recommended ? UV10.0.16 HP-UX 11 As mentioned, you'll need ODBC middleware. The major ODBC middleware providers are OpenLink (that's what we use), EasySoft, and DataDirect. Any of these should work fine from HP-UX to SQL Server. I'd suggest doing a free trial with all three and see which one you like best from a performance and ease of use perspective. Once you have ODBC middleware installed, you can use UniVerse's BCI interface to update SQL Server tables directly from basic programs. -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] support of pterm command options under red hat linux or better idea
On Tuesday 15 November 2005 11:59, Anthony Dzikiewicz wrote: You probably need to tweak the terminfo files. We are running Universe/Linux and we use VP terminals. Here is our /usr/ibm/uv/terminfo/v/vp file; Chapter 10 in the administering manual has the info on uvtic... Hope This Helps Anthony Dzikiewicz Thank you. I looked at the terminfo files, and I read and re-read the chapter on uvtic. It appeared that everything was correct as far as the terminfo file. What version of Linux and what version of Universe are you running? I found another route, but I would like to find all routes to fix this, because I intend to connect to Universe from PDA's as well. I found that you can run a unix/linux command from the uv environment by running sh -c command. In the LOGIN file, or at some similar point, we are going to put this command. sh -c stty susp '^-' That tells the linux system to look for ctrl- as it's suspend key. I tested it and it works perfectly. Thank you, Matt Grab --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Credit Card Handlers [ad response]
Please feel free to take a look at our webpage for NebulaPay and contact me for more information. NebulaPay has not yet been ported to U2 but we'd greatly appreciate an opportunity to do the port. http:// removethisNebula-RnD.com/products/financial.htm Thanks. Tony Gravagno Nebula RD TG@ removethisNebula-RnD.com karlp wrote: Oh wise ones... We have a competitor at one client that processes credit cards for them with line-item detail of their purchases. I'm not familiar enough with credit card processing to know if doing so via U2 is possible. Currently we have a card swiper in a central location and all cards are processed there. I'd like a solution that would allow our sales team to just type the number in and have things automagically happen, with a verification printed on the forms we currently generate in our 'legacy' U2 application. We aren't using anything other than the text-based green screen application, albeit via nice XP-based PCs (Okay, I'd rather they ran on Linux as I do). --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Credit Card Handlers
We just implemented an online credit card processing. We can process a credit card order from our HPUX UniVerse box as well as void credit card charges in the case of orders being cancelled. Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, November 15, 2005 1:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] Credit Card Handlers Oh wise ones... We have a competitor at one client that processes credit cards for them with line-item detail of their purchases. I'm not familiar enough with credit card processing to know if doing so via U2 is possible. Currently we have a card swiper in a central location and all cards are processed there. I'd like a solution that would allow our sales team to just type the number in and have things automagically happen, with a verification printed on the forms we currently generate in our 'legacy' U2 application. We aren't using anything other than the text-based green screen application, albeit via nice XP-based PCs (Okay, I'd rather they ran on Linux as I do). TIA -- 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/ NOT INTENDED AS A SUBSTITUTE FOR A WRITING NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER. This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Credit Card Handlers
Line item detailed statements is called level-3 processing and not all merchant banks or credit cards support it. Give Fred or Jake a call @ Total Computing and ask them about Level-3 support. I know they were working on it, but I haven't talked to anyone in a while. TotaLink is definitely worth the setup cost and monthly fees. I think they don't charge enough, but then again I need to decrease expenses as much as possible - so I'm very happy with the pricing structure as it is! www.total-computing.com --- Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 e-mail: [EMAIL PROTECTED] --- www.allspec.com --- -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, November 15, 2005 1:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] Credit Card Handlers Oh wise ones... We have a competitor at one client that processes credit cards for them with line-item detail of their purchases. I'm not familiar enough with credit card processing to know if doing so via U2 is possible. Currently we have a card swiper in a central location and all cards are processed there. I'd like a solution that would allow our sales team to just type the number in and have things automagically happen, with a verification printed on the forms we currently generate in our 'legacy' U2 application. We aren't using anything other than the text-based green screen application, albeit via nice XP-based PCs (Okay, I'd rather they ran on Linux as I do). TIA -- 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/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Credit Card Handlers
I did this in a prior life...it was fairly easy since our card processor (Alliance Data Systems) had a product called ads-link that lived on the AIX server (along with Pick database). I just had to pass strings of data to it via named pipes, and read same (I'm simplifying). It handled all the back end communications. Check with your provider and see if they have such a tool. There are still lots of little issues you'll need to work out; i.e. phone line goes down and you have to do manual transactions, customers want to use multiple cards on one transaction, etc. Mark From: [EMAIL PROTECTED] on behalf of [EMAIL PROTECTED] Sent: Tue 11/15/2005 11:11 AM To: u2-users@listserver.u2ug.org Subject: [U2] Credit Card Handlers Oh wise ones... We have a competitor at one client that processes credit cards for them with line-item detail of their purchases. I'm not familiar enough with credit card processing to know if doing so via U2 is possible. Currently we have a card swiper in a central location and all cards are processed there. I'd like a solution that would allow our sales team to just type the number in and have things automagically happen, with a verification printed on the forms we currently generate in our 'legacy' U2 application. We aren't using anything other than the text-based green screen application, albeit via nice XP-based PCs (Okay, I'd rather they ran on Linux as I do). [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] 64 bit VS. 32 bit
Question, Santa will be nice to us this year. Looking at a new HP-4440 with a pair of PA8900 1-ghz processors, a couple of gig of mem, several hundred gb of disk in raid 5 array running HP UX 11.11 (or 11.23, not sure yet). We currenty are an end user on a HP-9000 (HP UX 11.0)using Unidata 6.1.0 (32 bit), SB+ Developer 5.3.7; all access is via SBClient; User system here is SB+ GUI, all development is SB+ GUI. Question...debating as to whether to move to 64 bit system or stay with 32 bit? What advantages? What pitfalls? Thanks, Jerry M Parkany DB Admin ARL, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] support of pterm command options under red hat linux or better idea
Matt, -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MIS Sent: Tuesday, November 15, 2005 2:08 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] support of pterm command options under red hat linux or better idea On Tuesday 15 November 2005 11:59, Anthony Dzikiewicz wrote: You probably need to tweak the terminfo files. We are running Universe/Linux and we use VP terminals. Here is our /usr/ibm/uv/terminfo/v/vp file; Chapter 10 in the administering manual has the info on uvtic... Hope This Helps Anthony Dzikiewicz Thank you. I looked at the terminfo files, and I read and re-read the chapter on uvtic. It appeared that everything was correct as far as the terminfo file. Here are some notes I made on doing uvtic; cd /usr/ibm/uv/terminfo rm -rf ;*get rid of whats there now Copy the modified terminfo.src to /usr/ibm/uv/sample ;* this is one big file with everything Copy the modified terminfo file to unix /usr/share/terminfo/v/* ;* this is the individual terminal file created via infocmp Compile all Linux; tic /usr/share/terminfo/v/vt100.src ;* or what ever terminal source file you are dealing with Universe; /usr/ibm/uv/bin/uvtic -a /usr/ibm/uv/sample/terminfo.src Restart Universe What version of Linux and what version of Universe are you running? 10.1.1 Universe on RHEL 3 (2.4.21-32.Elsmp) I found another route, but I would like to find all routes to fix this, because I intend to connect to Universe from PDA's as well. I found that you can run a unix/linux command from the uv environment by running sh -c command. In the LOGIN file, or at some similar point, we are going to put this command. sh -c stty susp '^-' We do something similar. In the LOGIN para, we run a program GET.TERM.TYPE. This program determines the TTY and sets the terminal characteristics. We maintain a control file of all our terminals (term type, baud rate, printer is attached, what digi they are plugged into, etc...). We use this control file for many things in our applications. On our Adds 4000 terminal the up arrow returns SEQ(26) - 'SUB' The sh -c stty susp '^-' is a good temporary solution, because it will get things done. Another way of doing the same thing is via the inittab file. For example here is a snippet of our inittab setting serial port characteristics; dA3:2345:once:ditty-rp /dev/ttyA15 9600 cs7 parenb -parodd -cstopb You could put the stty attributes here as well. Also in the users '.profile', you could also set the same characteristics. I would think that you should be able to set that attribute in the terminfo (when you find out what the actual label for it is), compile it and be done with it forever. Make sure you change both Linux and Universe terminfo files. That tells the linux system to look for ctrl- as it's suspend key. I tested it and it works perfectly. Thank you, Matt Grab --- 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] 64 bit VS. 32 bit
Jerry - I am working for a customer who is moving to the 64 bit version of Unidata (6.1.13-64). Benchmarking and preliminary load testing has not revealed any issues with the 64 bit implementation. The most significant aspect of the 64 bit port is how shared memory is managed, esp. where you have encountered errno=24 messages in the past (unable to attach a shared memory segment). As of this writing, we have not encountered any pitfalls. If you would like further information, feel free to contact me off line. Regards, Robert DunnMiller CIO, dmcs, Inc. Phone: +1 903 763 1175 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jerry Parkany Sent: Tuesday, November 15, 2005 15:19 To: u2-users@listserver.u2ug.org Subject: [U2] 64 bit VS. 32 bit Question, Santa will be nice to us this year. Looking at a new HP-4440 with a pair of PA8900 1-ghz processors, a couple of gig of mem, several hundred gb of disk in raid 5 array running HP UX 11.11 (or 11.23, not sure yet). We currenty are an end user on a HP-9000 (HP UX 11.0)using Unidata 6.1.0 (32 bit), SB+ Developer 5.3.7; all access is via SBClient; User system here is SB+ GUI, all development is SB+ GUI. Question...debating as to whether to move to 64 bit system or stay with 32 bit? What advantages? What pitfalls? Thanks, Jerry M Parkany DB Admin ARL, 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] Credit Card Handlers
Check out http://www.nebula-rnd.com/products/financial.htm Ron White Barry Rogen wrote: We just implemented an online credit card processing. We can process a credit card order from our HPUX UniVerse box as well as void credit card charges in the case of orders being cancelled. Barry Rogen PNY Technologies, Inc. Senior Programmer/Analyst (973) 515 - 9700 ext 5327 [EMAIL PROTECTED] - Far better it is to dare mighty things, to win glorious triumphs even though checkered by failure, than to rank with those poor spirits who neither enjoy nor suffer much because they live in the gray twilight that knows neither victory nor defeat -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, November 15, 2005 1:12 PM To: u2-users@listserver.u2ug.org Subject: [U2] Credit Card Handlers Oh wise ones... We have a competitor at one client that processes credit cards for them with line-item detail of their purchases. I'm not familiar enough with credit card processing to know if doing so via U2 is possible. Currently we have a card swiper in a central location and all cards are processed there. I'd like a solution that would allow our sales team to just type the number in and have things automagically happen, with a verification printed on the forms we currently generate in our 'legacy' U2 application. We aren't using anything other than the text-based green screen application, albeit via nice XP-based PCs (Okay, I'd rather they ran on Linux as I do). TIA --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] 64 bit VS. 32 bit
Re UniData, if you do not need more than 1.75GB of shared memory to exist on the system at any point in time (sum up ALL of the shared memory segments - not just the UniData generated ones), stick with the 32-bit version of UniData. It has a smaller footprint. This is application and size of user license dependent (plus whether or not your run RFS or Replication - which require additional shared memory segments). Difficult to guess what your needs might be. You can run either 32-bit or 64-bit OS with the UniData 32-bit port. (Of course, you must run 64-bit OS if you use the UniData 64-bit port). Wally Terhune Manager - U2 Advanced Client Support IBM Information Management 4700 South Syracuse Street, Denver, CO 80237 Tel: 303.773.7969 New Number! Fax: 303.773.5915 New Number! [EMAIL PROTECTED] Jerry Parkany [EMAIL PROTECTED] .com To Sent by: u2-users@listserver.u2ug.org [EMAIL PROTECTED] cc stserver.u2ug.org Subject [U2] 64 bit VS. 32 bit 11/15/2005 02:18 PM Please respond to u2-users Question, Santa will be nice to us this year. Looking at a new HP-4440 with a pair of PA8900 1-ghz processors, a couple of gig of mem, several hundred gb of disk in raid 5 array running HP UX 11.11 (or 11.23, not sure yet). We currenty are an end user on a HP-9000 (HP UX 11.0)using Unidata 6.1.0 (32 bit), SB+ Developer 5.3.7; all access is via SBClient; User system here is SB+ GUI, all development is SB+ GUI. Question...debating as to whether to move to 64 bit system or stay with 32 bit? What advantages? What pitfalls? Thanks, Jerry M Parkany DB Admin ARL, Inc. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ [demime 1.01d removed an attachment of type image/gif which had a name of graycol.gif] [demime 1.01d removed an attachment of type image/gif which had a name of pic16671.gif] [demime 1.01d removed an attachment of type image/gif which had a name of ecblank.gif] --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
Re: [U2] Credit Card Handlers
[EMAIL PROTECTED] wrote: Oh wise ones... We have a competitor at one client that processes credit cards for them with line-item detail of their purchases. I'm not familiar enough with credit card processing to know if doing so via U2 is possible. Currently we have a card swiper in a central location and all cards are processed there. I'd like a solution that would allow our sales team to just type the number in and have things automagically happen, with a verification printed on the forms we currently generate in our 'legacy' U2 application. We aren't using anything other than the text-based green screen application, albeit via nice XP-based PCs (Okay, I'd rather they ran on Linux as I do). I'm in the process of setting up that very thing. We currently use a swiping solution, but are going to start taking payments through our web site. Rather than having two different solutions (1 for web, 1 for UniVerse), I've decided to do everything from the UniVerse side. We already pass UV data back to the web site via UOJ, so it's trivial for me to pass credit card authentication data back. All you need is a credit card gateway provider that offers a web service you can talk to over an SSL connection. I'm testing Verisign's PayFlow Pro service at the moment, and have had no trouble sending XML requests from UV and getting data back. I did have to install a piece of software from their SDK on the UV server (linux) to talk to their server, but once I did it was a piece of cake. I initially tried using the linux curl program (works fine for talking to UPS's web service), but had no success. I think Verisign's web service is doing something a little non-standard. I'm just writing an XML request to a temp file, then shelling out to Verisign's program and passing it the file name: EXECUTE 'SH -c ':EXECUTABLE:' ':PFPRO.HOST:' ':XML.PATH:'/':REQ.ID:'', OUT XML.TXT Then I parse the XML text I get back. There's a document from Verisign named XMLPay.pdf with examples of all the XML requests and a table of error codes you might get back. I just copied/pasted one of the examples into a basic program, stuck it in a variable, and filled in the blanks. -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] Unix to SQL Server
We're using the SQLXML IIS interface to update our data warehouse. This is SQL middleware if you like, but comes with MSSQL-2k. Nothing to install on UV, we run stock standard UV basic programs using the Http and XML basic functions to update and retrieve data. Stuart -Original Message- Subject: [U2] Unix to SQL Server I know I'm probably going over old ground again, but what's the present state of play for UniVerse on HP-UX connecting to SQL Server on w2000/2003 to update tables ? Do I need middleware ? If so, what is recommended ? UV10.0.16 HP-UX 11 ** This email message and any files transmitted with it are confidential and intended solely for the use of addressed recipient(s). If you have received this email in error please notify the Spotless IS Support Centre (+61 3 9269 7555) immediately, who will advise further action. This footnote also confirms that this email message has been scanned for the presence of computer related viruses. ** --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/