CA Datacom - DBCA DatacomCA Datacom - ADCA Datacom - ServerCA CISCA Common Services for z/OSCA 90s ServicesCA Database Management Solutions for DB2 for z/OSCA Common Product Services ComponentCA Common ServicesCA Datacom/ADCA ecoMeter Server Component FOCCA Easytrieve Report Generator for Common ServicesCA Infocai MaintenanceCA IPCUnicenter CA-JCLCheck Common ComponentCA Mainframe VM Product ManagerCA Chorus Software ManagerCA On Demand PortalCA Service Desk Manager - Unified Self ServiceCA PAM Client for Linux for zSeriesCA Mainframe Connector for Linux on System zCA Graphical Management InterfaceCA Web Administrator for Top SecretCA CA- Xpertware
Issue/Introduction
There are multiple code pages used for EBCDIC format, and it is possible to have, for example, 1047 for the operating system, 037 for COBOL compiles, and 500 for MQ-Series tasks.
Does CA Datacom/DB use any special code pages when storing its data?
Environment
Release: DATABB00200-14.0-Datacom/AD Component:
Resolution
The MUF and CA Datacom/DB databases do nothing special with the definition of a code page but will default to use the system setting.
Essentially, if you define a field as CHAR(8), you will store 8 characters in the field, and we don't perform any data translation of data in the records, but we store whatever the application passes to us.
There is, of course, a different response when dealing with DBCS data (like Kanji, for example), or data that originates through an application using JDBC type-4 connections, where a codepage can be specified in the CA Datacom Server configuration. Additionally, some application tools like CA Ideal can use an internal translation table to change characters like currency symbols. Again, this has no effect on the actual data storage, but only on the interpretation of the input and output characters in specific applications.