UPCASE() will also function as OCONVS() If you put in a dynamic array into UPCASE(), it will upcase the entire string and leave the @VM, @AM... untouched.
I use this on UV when reading items, especially for searching, I'll upcase the entire dynamic array, then proceed to do my indexes or locates. > -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of Martin Phillips > Sent: Wednesday, June 22, 2011 6:32 AM > To: U2 Users List > Subject: Re: [U2] uppercase > > Hi Jeff, > > The difference is probably only one of performance. Using OCONV > requires the > conversion code to be decoded in order to work out what to do. Using > UPCASE() can go straight off to do the real work without any additional > decoding. > > I suspect not, but there may be some difference of interpretation if > you > have NLS installed. > > > Martin Phillips > Ladybridge Systems Ltd > 17b Coldstream Lane, Hardingstone, Northampton NN4 6DB, England > +44 (0)1604-709200 > > ----- Original Message ----- > From: "Jeff Butera" <[email protected]> > To: <[email protected]> > Sent: Wednesday, June 22, 2011 11:24 AM > Subject: [U2] uppercase > > > > On unidata, can anyone shed light on the differences between > UPCASE(...) > > and OCONV(...,'MCU')? > > > > I know OCONVS(...,'MCU') will preserve @VM and other unidata > delimiters, > > but for single valued data is their any difference in the above? > > > > > > -- > > Jeff Butera, PhD > > Manager of ERP Systems > > Hampshire College > > 413-559-5556 > > > > _______________________________________________ > > 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
