Tags

, , , ,

Recently we have encountered an issue with Hex value 41, which also looks like SPACE in normal view.

We have received a file which had this value in between spaces. Say example “MINNI IS HERE”. The space that you see between MINNI and IS actually had a HEX value of 41 instead of 40 (SPACE).

This value is one time updated into ADMIN table, and then compared against the same column available in other tables. So here the issue is that ADMIN table had the issue character X’41’ and all other tables had valid data X’40’.

For naked eye, both the data looked similar, so it was not sure, whey there is no match found against the ADMIN table.

Identification and Resolution:

So SPUFI was run to get the data into a file, then its HEX value was compared between ADMIN table and other tables. Now issue char X’41’ was identified and it was updated with SPACE(X’40’) in the ADMIN table and NOW other tables were able to find the match in the ADMIN table.

Note:

If the issue char X’41’ needs to be replaced in multiple records in a file, the SORT options ALTSEQ, FINDREP can be used as shown in below posts.

SORT – ALTSEQ

SORT – FINDREP

 

SORT JOIN – TO JOIN TWO FILES BASED ON A KEY
KNOW YOUR MAINFRAME
CA7 – LJOB, LQ, LRLOG
CA7 – ASSIGN PF KEYS TO PERFORM YOUR COMMANDS
CA7 – LEAD TIME CONCEPT (LOOK BACK ISSUE)
CA7 Commonly used Commands
REXX – INITIAL SETUP
Mainframe Manuals/References/Guides/Documents Download Links
HEX Value 41 – Confused as SPACE (Hex value of 40)
EVER WONDERED WHAT DOES Z MEAN IN Z/OS
Search for a string that is in mixed case inside a PDS
S0C7 ISSUE – FIND THE INVALID (FAULT) DATA
HRECALL – MASS RECALL IN BATCH MODE
Nice Article to answer the myths on Mainframes
MAINFRAME – PS DATASET GETTING NUMBER AT END AUTOMATICALLY
MAINFRAME – GRANT and REVOKE Dataset Access
File Status Key Overview
TSO/E COMMANDS
SDSF; Status panel (ST) Columns
ABEND CODES
Glossary of z/OS terms and abbreviations
AMODE and RMODE
IMS INTERVIEW QUESTIONS
SDSF TIPS
NDM – FASTER MODE
FILEMAXX
BATCH PIPES
What is a Catalog
Important SQL CODES and ABEND CODES
Conditional processing
Advertisements