Locale considerations

You can modify the data source connection definitions to use different local code pages.

Before you begin

You have the option to change the default code page (US/English IBM 1047) that the studio uses to perform character data translations between the native Java character encoding (UTF-8) and the mainframe.

Procedure

1. To configure the data source connection definition, in the Active Connections view, close all open connections.
2. On the Client tab, expand Data Virtualization Manager > Data Sources > JDBC > Default Config File.
3. Right-click the data source that you want to modify and click Edit.
4. In the Data Source Editor, click the Connection String tab.
5. Add or modify the Charset setting to use the appropriate EBCDIC code page. For example, Charset=IBM037.
6. If LGID=ENC exists in the connection string, delete it to avoid a conflict with the Charset setting.
7. Close the Data Source Editor.
8. When prompted, click Yes to save the data source definition.
9. To change the default Charset that the studio uses when creating connection definitions, from the Window menu select Preferences, expand DV Data > Driver.
10. In Connection Overrides, enter the new Charset setting and click Apply.
11. On the Server tab, expand SQL > Data.
12. Right-click the data source to which you want to connect and select Create Connection Definition (DSN).
13. Accept the default name that is displayed or enter a new DSN name and click OK.
14. In the Data Source Editor, click the Connection String tab and confirm that the new Charset setting displays in the connection string.

Results

When running queries using the new data source definition, the character data (including language specific glyphs) that you chose is displayed in the SQL Results view.