Re: Drop Case API

Tom,
Thanks for the example.
It never hurts to have another tool in my toolbox.
 
Jeff Young
Sr. Programmer Analyst
IBM -e(logo) server Certified Systems Exper - iSeries Technical Solutions V5R2 
IBM  Certified Specialist- e(logo) server i5Series Technical Solutions Designer V5R3
IBM  Certified Specialist- e(logo)server i5Series Technical Solutions Implementer V5R3
  
 






________________________________
From: Tom Liotta <qsrvbas@xxxxxxxxxxxx>
To: rpg400-l@xxxxxxxxxxxx
Sent: Sunday, April 12, 2009 1:51:44 PM
Subject: 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...