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 <[email protected]> To: U2 Users List <[email protected]> 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: [email protected] > [mailto:[email protected]] 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: [email protected] >> [mailto:[email protected]] 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 >> [email protected] >> http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
