Re: Drop Case API

Jeff Young wrote:

Performance is not critical in this case.
I am converting a file that has about 22K records and I need to convert one field in the record to Drop Case (1st letter of each word as CAPITAL, the rest as lower).
Do you have some REXX code that I could use as a base to do this on the fly? (Called from by RPG IV program).

Jeff:

I didn't have anything better that I wanted to do last night and this was staying in mind. So I put a basic example together to see how it would look. It works well enough on my little model 170 at V5R3.

See http://code.midrange.com/bdc779c70e.html

It's the SQL that created a small table for testing plus a REXX proc that loops through the table (using SQL) setting a VARCHAR column to Drop Case.

It's a bit more complex than just the small part that does the Drop Case by itself. But you already have your RPG solution, so I might as well go the extra distance.

Tom Liotta

________________________________
From: Tom Liotta <qsrvbas@xxxxxxxxxxxx>

Jeff Young wrote:

Is there an API or sample code for converting a text string from UPPER CASE to Drop Case?

Jeff:

How well must it perform? A REXX procedure could do this pretty easily, but you wouldn't want to do it over a million rows with lots of columns...