Not to be too obtuse, but if the only point is to convert MM.MM to MMMM you could just use CONVERT "." TO ""
-----Original Message----- From: Charlie Noah <cwn...@comcast.net> To: U2 Users List <u2-users@listserver.u2ug.org> Sent: Wed, May 8, 2013 7:34 am Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. NUM() will validate '' (null string) as numeric, and I believe some implementations would validate '.' (decimal point) as numeric, although the version of Jbase I'm on, running Universe emulation, does not. Charlie On 05-08-2013 8:39 AM, George Gallen wrote: > The only thing I could think of is it could validate it as being a number, > but then > So would NUM(). > > George > > -----Original Message----- > From: u2-users-boun...@listserver.u2ug.org > [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley > Sent: Wednesday, May 08, 2013 9:37 AM > To: U2 Users List > Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, HTTP, XML, SCTX , MQS, SOAP or database variable. > > George, > > After sending it I thought, "Well,... that OCONV acomplishes nothing!" > > Dale > > On 05/08/2013 08:32 AM, George Gallen wrote: >> What purpose will the OCONV(var,"MD0") serve? >> >> -----Original Message----- >> From: u2-users-boun...@listserver.u2ug.org >> [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of dale kelley >> Sent: Tuesday, May 07, 2013 6:06 PM >> To: U2 Users List >> Subject: Re: [U2] Illegal use of the file, select, cursor, BCI, Socket, >> HTTP, XML, SCTX , MQS, SOAP or database variable. >> >> if var is XXX.XX >> ICONV(var,"MD2") then OCONV(var,"MD0") >> >> Dale >> >> On 05/07/2013 12:04 PM, Sathya wrote: >>> Wjhonson<wjhonson<at> aol.com> writes: >>> >>>> Satya the OSOPEN command.. what version of the system are you running? >>>> >>> Hi,. >>> Thanks everyone for the suggestions and I have sorted out the issue. Now I >>> want to write some dollar values to a file. But the format in which it is >>> in the file is XXX.XX, but I need to write it as XXXXX. Without the >>> decimals the simple numbers. >>> >>> Can some help me in doing so. >>> >>> Thanks& Regards, >>> Sathya V. >>> >> _______________________________________________ >> 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
