When EXPORTing the contents of the result browser to a file, national characters are incorrectly translated.

Document ID : KB000054806
Last Modified Date : 14/02/2018
Show Technical Document Details

Description

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.

Solution

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.