Re: [U2] AD: Credit Card Processing
Everyone has to abide by PCI We use a company called COMMIDEA is the UK, we do it out of a basic program using callhttp Works fine Also they have an interface that allows you to register a card so you can use it again and not have to store the CV2 which is aainst PCI Bob -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jerry Sent: 30 June 2011 17:44 To: U2 Users List Subject: [U2] AD: Credit Card Processing If that is near your maximum in a day I don't think you would be under the rules of PCI. But can never tell. You can check the standards at: www.pcisecuritystandards.org It might be cheaper to have one of the online PCI compliant card processors do the billing or you could have a PCI compliant billing company do the billing for you. Yes I work for one. Jerry Banker Affiliated Acceptance Corporation 1-800-233-8483 On 6/30/2011 11:04 AM, Bryan Evans wrote: I am looking for a multi-value (UniVerse specifically) product to handle credit card processing. Does anyone know of or can recommend a product? We are an HP-UX UniVerse shop. The volume of credit cards processed would be very low - 100 orders or less per day. Thank you in advance, Bryan Evans Orbit Irrigation Products Inc. ___ 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 __ 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] Convert to Numeric
Kevin, Sorry - of course line 212 - it was getting late... Line 212 and the code leading up to it is as follows: X.B.ORIG.APPROVED.AMT = OCONV(V.B.ORIG.APPROVED.AMT, MD2) X.B.ORIG.APPROVED.AMT = FMT(X.B.ORIG.APPROVED.AMT,15R) X.MDEBITS.YTD = SUM(VL.B.APPR.MDEBITS) X.MDEBITS.YTD = OCONV(X.MDEBITS.YTD,MD2) X.MDEBITS.YTD = FMT(X.MDEBITS.YTD,15R) X.MCREDITS.YTD = SUM(VL.B.APPR.MCREDITS) X.MCREDITS.YTD = OCONV(X.MCREDITS.YTD, MD2) X.MCREDITS.YTD = FMT(X.MCREDITS.YTD, 15R) Line 212 X.CRNT.BUDGT.AMT = X.B.ORIG.APPROVED.AMT + X.MDEBITS.YTD - X.MCREDITS.YTD When I pull the data, from the database, straight into Excel V.B.ORIG.APPROVED.AMT does not appear numeric (LEFT justified etc.) though it is defined as numeric in the DICT. Thanks, Greg From: Kevin King precisonl...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Date: 06/30/2011 09:16 PM Subject:Re: [U2] Convert to Numeric Sent by:u2-users-boun...@listserver.u2ug.org What does A26S.GET.GLS.INFO line 212 say? Yes, you can force values numeric but at what expense? ___ 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] Convert to Numeric
aside from the ICONV/OCONV, I'd try moving the three FMT() statements after line 212. Might the FMT() be forcing some spaces to the beginning of the numbers in order to make it a length of 15? X.B.ORIG.APPROVED.AMT = OCONV(V.B.ORIG.APPROVED.AMT, MD2) X.MDEBITS.YTD = SUM(VL.B.APPR.MDEBITS) X.MDEBITS.YTD = OCONV(X.MDEBITS.YTD,MD2) X.MCREDITS.YTD = SUM(VL.B.APPR.MCREDITS) X.MCREDITS.YTD = OCONV(X.MCREDITS.YTD, MD2) Line 212 X.CRNT.BUDGT.AMT = X.B.ORIG.APPROVED.AMT + X.MDEBITS.YTD - X.MCREDITS.YTD X.B.ORIG.APPROVED.AMT = FMT(X.B.ORIG.APPROVED.AMT,15R) X.MDEBITS.YTD = FMT(X.MDEBITS.YTD,15R) X.MCREDITS.YTD = FMT(X.MCREDITS.YTD, 15R) and probably X.CRNT.BUGT.AMT = FMT(X.CRNT.BUGT.AMT,15R) George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Friday, July 01, 2011 7:49 AM To: U2 Users List Subject: Re: [U2] Convert to Numeric Kevin, Sorry - of course line 212 - it was getting late... Line 212 and the code leading up to it is as follows: X.B.ORIG.APPROVED.AMT = OCONV(V.B.ORIG.APPROVED.AMT, MD2) X.B.ORIG.APPROVED.AMT = FMT(X.B.ORIG.APPROVED.AMT,15R) X.MDEBITS.YTD = SUM(VL.B.APPR.MDEBITS) X.MDEBITS.YTD = OCONV(X.MDEBITS.YTD,MD2) X.MDEBITS.YTD = FMT(X.MDEBITS.YTD,15R) X.MCREDITS.YTD = SUM(VL.B.APPR.MCREDITS) X.MCREDITS.YTD = OCONV(X.MCREDITS.YTD, MD2) X.MCREDITS.YTD = FMT(X.MCREDITS.YTD, 15R) Line 212 X.CRNT.BUDGT.AMT = X.B.ORIG.APPROVED.AMT + X.MDEBITS.YTD - X.MCREDITS.YTD When I pull the data, from the database, straight into Excel V.B.ORIG.APPROVED.AMT does not appear numeric (LEFT justified etc.) though it is defined as numeric in the DICT. Thanks, Greg From: Kevin King precisonl...@gmail.com To: U2 Users List u2-users@listserver.u2ug.org Date: 06/30/2011 09:16 PM Subject:Re: [U2] Convert to Numeric Sent by:u2-users-boun...@listserver.u2ug.org What does A26S.GET.GLS.INFO line 212 say? Yes, you can force values numeric but at what expense? ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Convert to Numeric
ICONV doesn't convert to numeric, it just moves the decimal place to the right and ICONV moves it the left, at least when using MDx. FMT is what is converting your numbers to strings *1 or +0 will convert convert your strings to numbers (assuming no , or $) George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Friday, July 01, 2011 7:55 AM To: U2 Users List Subject: Re: [U2] Convert to Numeric David, Ouch! and I know this... Yes, I need to try first ICONV to take whatever to numeric and then process. As always THANKS, Greg From: David Jordan da...@dacono.com.au To: U2 Users List u2-users@listserver.u2ug.org Date: 06/30/2011 10:14 PM Subject:Re: [U2] Convert to Numeric Sent by:u2-users-boun...@listserver.u2ug.org Hi Greg I may have misinterpreted your email. However just wanted to make sure you understood that if you want to convert $13,000.00 to numeric you need to do an ICONV. OCONV does the opposite and converts 130 to $13,000.00 Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Friday, 1 July 2011 10:50 AM To: U2 Users List Subject: Re: [U2] Convert to Numeric Guys, I'm getting some wildly unexpected values returned... I have attempted formatting (FMT) and converting (OCONV) and have looked at the data which appears to be correct(no O etc...). The DICT has them set at MD2, and 15R. I notice that I am also getting the following message: In CF.OBJ/_A26S.GET.GLS.INFO at line 212 Non-numeric found when numeric required. Any suggestions how I can force these values numeric? Thanks, Greg ___ 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 ___ 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] Convert to Numeric
oops meant to type OCONV moves to the left. -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of George Gallen Sent: Friday, July 01, 2011 9:26 AM To: U2 Users List Subject: Re: [U2] Convert to Numeric ICONV doesn't convert to numeric, it just moves the decimal place to the right and ICONV moves it the left, at least when using MDx. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Convert to Numeric
The behavior varies somewhat by platform. Are you using universe or unidata? I'm guessing you're on unidata because you are using the MD conversion code (I haven't seen that used much on universe) The 2 lines: X.B.ORIG.APPROVED.AMT = OCONV(V.B.ORIG.APPROVED.AMT, MD2) X.B.ORIG.APPROVED.AMT = FMT(X.B.ORIG.APPROVED.AMT,15R) could be replaced with one: X.B.ORIG.APPROVED.AMT = OCONV(V.B.ORIG.APPROVED.AMT,MR2#15) As a general rule, you don't want to do conversion/formatting until you actually output. The exception is when you have to deal with numbers stored with a different number of implied decimal places, and then you need to descale then to a common format before doing math. The definition of what is numeric varies by platform. For example: 0001 A=' 123' 0002 B=' 1,000' 0003 CRT A+1 0004 CRT B+1 0005 CRT ICONV(A,'MD')+1 0006 CRT ICONV(B,'MD')+1 on unidata, you will get non-numeric errors for both lines 3 and 4, but on universe you only get an error for line 4. universe is perfectly happy with leading and trailing spaces in numbers, but neither likes the comma. For both universe and unidata, lines 5 and 6 are fine. iconv does try to convert to numeric, removing spaces and valid numeric punctuation. ICONV will fail if there are alpha characters (it will return 0, but will NOT print a message--you need to check the STATUS() function yourself), and might return the incorrect number if you include descaling or decimal placement codes, but simple 'MD' doesn't do that. If you suspect invalid numeric data, you should use the NUM() function to test (or iconv, also testing the STATUS() result) On Jul 1, 2011, at 9:26 AM, George Gallen wrote: ICONV doesn't convert to numeric, it just moves the decimal place to the right and ICONV moves it the left, at least when using MDx. FMT is what is converting your numbers to strings *1 or +0 will convert convert your strings to numbers (assuming no , or $) George -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users- boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Friday, July 01, 2011 7:55 AM To: U2 Users List Subject: Re: [U2] Convert to Numeric David, Ouch! and I know this... Yes, I need to try first ICONV to take whatever to numeric and then process. As always THANKS, Greg From: David Jordan da...@dacono.com.au To: U2 Users List u2-users@listserver.u2ug.org Date: 06/30/2011 10:14 PM Subject:Re: [U2] Convert to Numeric Sent by:u2-users-boun...@listserver.u2ug.org Hi Greg I may have misinterpreted your email. However just wanted to make sure you understood that if you want to convert $13,000.00 to numeric you need to do an ICONV. OCONV does the opposite and converts 130 to $13,000.00 Regards David Jordan -Original Message- From: u2-users-boun...@listserver.u2ug.org [ mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Greg Coelho Sent: Friday, 1 July 2011 10:50 AM To: U2 Users List Subject: Re: [U2] Convert to Numeric Guys, I'm getting some wildly unexpected values returned... I have attempted formatting (FMT) and converting (OCONV) and have looked at the data which appears to be correct(no O etc...). The DICT has them set at MD2, and 15R. I notice that I am also getting the following message: In CF.OBJ/_A26S.GET.GLS.INFO at line 212 Non-numeric found when numeric required. Any suggestions how I can force these values numeric? Thanks, Greg ___ 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 ___ 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 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
[U2] [UV] SPOOLER LOCK
We have an issue where the spooler lock keeps having to get cleared manually. We stop the spooler, clear the lock and restart the spooler and within 15-30 minutes, the lock returns and does not clear. Cause ?Solution ? Thanks, Barry Rogen PNY Technologies, Inc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] SPOOLER LOCK [not-secure]
Hmmm... run CONFIG ALL and find the directory for UVSPOOL. Make sure that it's not filling up. Are you on Windows or a Unix? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Friday, July 01, 2011 1:52 PM To: U2 Users List Subject: [U2] [UV] SPOOLER LOCK We have an issue where the spooler lock keeps having to get cleared manually. We stop the spooler, clear the lock and restart the spooler and within 15-30 minutes, the lock returns and does not clear. Cause ?Solution ? Thanks, Barry Rogen PNY Technologies, Inc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIAL INFORMATION: The information contained in this e-mail may be confidential and protected from general disclosure. If the recipient or reader of this e-mail is not the intended recipient or a person responsible to receive this e-mail for the intended recipient, please do not disseminate, distribute or copy it. If you received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. We will take immediate and appropriate action to see to it that this mistake is corrected.[*LD*] ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] [UV] SPOOLER LOCK [not-secure]
Unix Barry Rogen Senior Programmer/Analyst PNY Technologies, Inc. (973) 560-5327 bro...@pny.com We are continually faced with great opportunities brilliantly disguised as insoluble problems. John W Gardner -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hennessey, Mark F. Sent: Friday, July 01, 2011 1:59 PM To: 'U2 Users List' Subject: Re: [U2] [UV] SPOOLER LOCK [not-secure] Hmmm... run CONFIG ALL and find the directory for UVSPOOL. Make sure that it's not filling up. Are you on Windows or a Unix? -Original Message- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Barry Rogen Sent: Friday, July 01, 2011 1:52 PM To: U2 Users List Subject: [U2] [UV] SPOOLER LOCK We have an issue where the spooler lock keeps having to get cleared manually. We stop the spooler, clear the lock and restart the spooler and within 15-30 minutes, the lock returns and does not clear. Cause ?Solution ? Thanks, Barry Rogen PNY Technologies, Inc ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users CONFIDENTIAL INFORMATION: The information contained in this e-mail may be confidential and protected from general disclosure. If the recipient or reader of this e-mail is not the intended recipient or a person responsible to receive this e-mail for the intended recipient, please do not disseminate, distribute or copy it. If you received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. We will take immediate and appropriate action to see to it that this mistake is corrected.[*LD*] ___ 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