I would like to point out a very nice function in SQL that you can use to translate character fields in any file from lowercase to uppercase.

The following SQL statement translates all lowercase characters in field TEXT in file TXTFIL to uppercase through the SQL TRANSLATE function. (Characters in TEXT that are not lowercase alphabetic characters are not affected by the TRANSLATE function.)

 UPDATE TXTFILE SET TEXT=TRANSLATE(TEXT) 

Every AS/400 is capable of executing SQL statements-even those without the SQL/400 licensed program-through Query Management/400, which is part of OS/400. For those who are unfamiliar with this feature, I will briefly describe how to execute an SQL statement through Query Management.

Query Management executes SQL statements that have been keyed into a source member and compiled into an object (type *QMQRY). You create *QMQRY objects with the Create Query Management Query (CRTQMQRY) command and execute them with the Start Query Management Query (STRQMQRY) command.

This process can be broken down into four basic steps:

1. Create a source physical file called QQMQRYSRC with a record length of 91.

2. Create a source member in file QQMQRYSRC (member type QMQRY) to contain the SQL statement you want to execute.

3. Create a QMQRY object from the source member with the CRTQMQRY command.

4. Execute the query with the STRQMQRY command.