Syntax

When you are considering a particular code-page conversion, you want to check an existing database for characters that do not appear in the target code page. This is precisely what is done by the PROUTIL utility with the CONVCHAR CHARSCAN qualifier. It searches for every occurrence of specified characters in every CHARACTER field in the database, using the code page associated with the database. It reports the total number of matched fields, and for each matched field, reports the table name, field name, and record id.

proutil db-name -C convchar charscan target-code-page "character-list"
  -cpinternal internal-code-page
  -cpstream stream-code-page
db-name
The database to be converted.
target-codepage
The code page to which you are converting.
character-list
A list of characters. The character list consists of code-page positions separated by commas. The string can include decimal or hexadecimal values for up to ten characters.
Note: For the complete syntax of the PROUTIL utility, see Manage the OpenEdge Database.

Here are some examples of scanning databases for character conflicts:

  • You have an ISO8859-1 database called mydb that you are thinking of converting to 1252. To scan this database for the presence of characters not in 1252, run the following command:
    proutil mydb -C convchar charscan 1252 "128,138,140,142,154,156,158,159"
  • You have an IBM437 database called mydb that you are thinking of converting to ISO8859-15. To scan this database for the presence of characters not in ISO8859-15, run the following command:
    proutil mydb -C convchar charscan ISO8859-15 "206,207,209,215,217,172,171,219"