HOW TO USE A QASCII TRANSLATION TABLE

Assuming you have a DB2/400 physical file CHARS with the field FIELD
which is stored in EBCDIC (CCSID 37) with a value of 'abc' (x'818283')
then the following logical file DDS:

     A          R CHARS                     PFILE(CHARS)
     A            FIELD              I      TRNTBL(QASCII)

would cause a RPG program when reading the record to "see" the value
x'616263' which is lowercase 'abc' in ASCII.  Is this what you are
attempting to do?

For converting uppercase letters to lowercase, I would suggest using
the Convert Case (QLGCNVCS or QlgConvertCase) APIs documented in the
National Language Support chapter of the System API Reference.  The
API provides proper conversion for ASCII, EBCDIC, and Unicode encoded
data.

Bruce Vining

>
>I have got a program which reads ascii values from a database table. In
>the logical file, there is a field called TRNTBL, but whenever I specify
>QASCII here, it reports an error. I don't know how to use this TRNTBL
>keyword for my program. Please help me in knowing more about this
>keyword.
>
>
>Also is there method for converting uppercase letters to lowercase
>letters through translation tables or are there any program readily
>available to do so? I remember seeing QCASE256 translation table for
>conversion from lowercase to uppercase, but from uppercase to lowercase
>iam not sure, please help me
>
>My mail Id is prakashsubramani@hotmail.com
>
>Prakash
>

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---