Re: Need help to convert a name in upper case, to mixed case

Python!

Here's an interpretive session. Of course you'd do this in a script stored
in the IFS and invoked from a CL. None of the silly >>> stuff would of
course be there at runtime, that is just interpretive sesssion detritus.

fname = "jack"
lname = "woehr"
print(fname.capitalize() + " " + lname.capitalize())

Jack Woehr

On Mon, Jan 14, 2019 at 2:09 PM Jay Vaughn <jeffersonvaughn@xxxxxxxxx>
wrote:

Alan

You won’t find any functions in rpg or sql that will do this, I don’t
believe.

Just write your own procedure (my preference would be an sql udf), and by
all means terminate that off platform call to achieve this functionality.

Jay

On Jan 14, 2019, at 3:45 PM, Alan Shore <ashore@xxxxxxxx> wrote:

Hi everyone
Before I forget, we are on V7r3

We have a process in place that makes a call (java) to an external

server, passing in the customers name (in upper case) to have it returned
in mixed case - good for a letter

For example - my name would be translated from ALAN SHORE, to Alan Shore
This was built 12 or 13 years ago, and we never had a problem - until

yesterday

We could not contact that external server - and the program is forced

into msgw

This program is the backbone to out Order Management system - so no

orders were being processed

Fortunately we discovered the root of the problem (someone had turned

the server off) and we were able to process the orders

Now, here is my question
Rather than contact this external server, is there anything that can be

placed (or used) on the AS/400 that will do this translation?

I hope what I wrote makes some sense

As always, any and all replies gratefully accepted


Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

Help support midrange.com by shopping at amazon.com with our affiliate

link: https://amazon.midrange.com
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com