Greg Coelho | 1 Jul 02:50 2011
Picon

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 <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Kevin King | 1 Jul 03:16 2011
Picon

Re: [U2] Convert to Numeric

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 <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

David Jordan | 1 Jul 04:14 2011
Picon

Re: [U2] Convert to Numeric

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 1300000 to $13,000.00

Regards

David Jordan

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org [mailto:u2-users-bounces <at> 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
_______________________________________________
(Continue reading)

Rob Sobers | 1 Jul 05:47 2011
Picon

Re: [U2] Git and U2

Good point, Dan.

Dropbox is such a good service, too.  It's a shame that a) they let it
happen (unit tests, man!) and b.) they handled it so poorly PR-wise.  On the
bright side, it's not nearly as bad as Citibank or Sony.

-Rob

On Thu, Jun 30, 2011 at 3:43 PM, Dan McGrath <danmcg.au <at> gmail.com> wrote:

> Rob, might not be the best idea to say secure cloud-based and Dropbox in
> the
> same email as a comparison after what happened to dropbox recently ;)
> _______________________________________________
> U2-Users mailing list
> U2-Users <at> listserver.u2ug.org
> http://listserver.u2ug.org/mailman/listinfo/u2-users
>
_______________________________________________
U2-Users mailing list
U2-Users <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Bob Witney | 1 Jul 08:15 2011
Picon

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-bounces <at> listserver.u2ug.org
[mailto:u2-users-bounces <at> 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
(Continue reading)

Greg Coelho | 1 Jul 13:48 2011
Picon

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 <precisonline <at> gmail.com>
To:     U2 Users List <u2-users <at> listserver.u2ug.org>
Date:   06/30/2011 09:16 PM
Subject:        Re: [U2] Convert to Numeric
Sent by:        u2-users-bounces <at> listserver.u2ug.org
(Continue reading)

Greg Coelho | 1 Jul 13:54 2011
Picon

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 <David <at> dacono.com.au>
To:     U2 Users List <u2-users <at> listserver.u2ug.org>
Date:   06/30/2011 10:14 PM
Subject:        Re: [U2] Convert to Numeric
Sent by:        u2-users-bounces <at> 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 1300000 to 
$13,000.00

Regards

David Jordan

-----Original Message-----
From: u2-users-bounces <at> listserver.u2ug.org [
mailto:u2-users-bounces <at> listserver.u2ug.org] On Behalf Of Greg Coelho
Sent: Friday, 1 July 2011 10:50 AM
(Continue reading)

George Gallen | 1 Jul 15:24 2011

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-bounces <at> listserver.u2ug.org [mailto:u2-users-
> bounces <at> 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:
> 
(Continue reading)

George Gallen | 1 Jul 15:26 2011

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-bounces <at> listserver.u2ug.org [mailto:u2-users-
> bounces <at> 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 <David <at> dacono.com.au>
> To:     U2 Users List <u2-users <at> listserver.u2ug.org>
> Date:   06/30/2011 10:14 PM
(Continue reading)

George Gallen | 1 Jul 15:32 2011

Re: [U2] Convert to Numeric

oops meant to type OCONV moves to the left.

> -----Original Message-----
> From: u2-users-bounces <at> listserver.u2ug.org [mailto:u2-users-
> bounces <at> 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 <at> listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users


Gmane