RE: how to process an RTF string on the iSeries?

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

> 1) I understand it processes a "file". In my case, the RTF string is a
> VARCHAR() column in one of my tables. In order to leverage RTFREADR, am
> I
> going to have to a) store the VARCHAR() in a file b) execute RTFREADR
> against that file c) copy the output file to whereever?
>
> 2) What exactly is RTFREADR returning? The text from the RTF string
> without
> all the control characters? Is it one long string or is each "line" a
> record
> in the output .txt file?

To reiterate the immortal / valuable words of Mr. Wells:  "GOOGLE RTFREADR"
I have no idea what RTFREADR returns; I did this out of curiosity to see if
the port process would be an issue, and was pleased to find that it was not.

To use it as is, write your varchar to an IFS file, invoke the program,
directing to another file, and read in the result.  Or modify the program to
not use files.  From what you describe, it sounds like an SQL function would
be the ideal answer.  (SELECT RTFTEXT(mycol) FROM RTFTABLE.)  How
critical/urgent is this?

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
"Ninety-eight percent of the adults in this country are decent, hardworking,
honest Americans.  It's the other lousy two percent that get all the
publicity.  But then we elected them."
        -- Lily Tomlin