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

Products

• IDMS
• IDMS - Database
• IDMS - ADS
• VISUAL EXPRESS

Issue/Introduction

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.

Environment

Release: VISEXP05200-1.5-Visual Express-Reporter
Component: