Author Topic: Converting mainframe Hex character  (Read 846 times)

DDP021

  • Sr. Member
  • ****
  • Posts: 343
    • View Profile
Converting mainframe Hex character
« on: July 12, 2022, 03:07:49 AM »
Hi,

We have a mainframe file loading to CMOD.  One of the mainframe characters is a | character (x'4F') .  When the file is loaded into CMOD, the character is converted to an ! character.   Does anyone know why this would be happening??

Mehmet S Yersel

  • Jr. Member
  • **
  • Posts: 57
    • View Profile
    • LinkedIn Profile
Re: Converting mainframe Hex character
« Reply #1 on: July 12, 2022, 05:54:10 AM »
Is it possible the code page document created in is not matching the one used to load it in CMOD?
Check this link out, there is a list of differences between the 2 code pages: 
https://www.ibm.com/support/pages/conversion-character-differences-between-ccsid-037-and-ccsid-500
#zOS #Multiplatforms
#DB2 #OAM
#AFP #RiCOH AFP2PDF #SnowBound
#Finance #Telecom #Airlines
#ICN #IHS #WAS ND #Cert and Key Management
#Migrations #Data Modeling #RACF-2-CMOD Synch
#FileTek AMMO #ABI #RMDS #RADAR

Justin Derrick

  • IBM Content Manager OnDemand Consultant
  • Administrator
  • Hero Member
  • *****
  • Posts: 2229
  • CMOD Guru for hire...
    • View Profile
    • Tenacious Consulting
Re: Converting mainframe Hex character
« Reply #2 on: July 22, 2022, 01:47:17 PM »
Can you post your indexing parameters so we can see what's going on?

Thanks.

-JD.
IBM CMOD Professional Services: http://TenaciousConsulting.com
Call:  +1-866-533-7742  or  eMail:  jd@justinderrick.com
IBM CMOD Wiki:  https://CMOD.wiki/
FREE IBM CMOD Education & Webinars:  https://CMOD.Training/

Interests: #AIX #Linux #Multiplatforms #DB2 #TSM #SP #Performance #Security #Audits #Customizing #Availability #HA #DR

DDP021

  • Sr. Member
  • ****
  • Posts: 343
    • View Profile
Re: Converting mainframe Hex character
« Reply #3 on: July 24, 2022, 04:10:10 AM »
Justin,

Apologize for the late response.   The issue we found was, On Windows and mainframe, X’4F’ displays as a pipe symbol.  On Linux, x’6A’ displays a pipe symbol.   The submitter of the data decided on using x’5E’ which is a ; (semicolon) on the output.  We did give them another option, x'BB' which did display in CMOD as and "|".   But since they were the ones updating the datafile, we left the decision up to them!!   As always, thank you, and everyone, for their replies!!   Take care.   Dave