When using CA-IDMS/Server to access an IDMS database with ODBC, the user can customize the translation table for EBCDIC ? ASCII translation of the non-standard characters in the code pages in use. If a user has done so, the following problem can occur in Visual Express.
If the result of an SQL SELECT statement is being viewed in a result browser, it can be exported to an external file with /File/Export. The resultant exported file can have the national characters incorrectly translated.
The problem does not happen if the export is done with a #RetExport script command.
When specifying the target file information in the Export Data dialog box, there are a number of checkboxes. One of them is called ?ANSI format?. Check this and the problem will not occur.